| Genesis Cash Budget ($000) |
| | Monthly Budget | | | | | | | | | | | | | Quarterly Budget |
| | Dec | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec | March | June | Sept | Dec |
| Cash Inflow |
| Sales (Reference only) | 300,000 | 200,000 | 350,000 | 400,000 | 500,000 | 550,000 | 700,000 | 700,000 | 650,000 | 900,000 | 850,000 | 750,000 | 500,000 | 150,000 | 190,000 | 3,000,000 | 2,400,000 |
| Cash Collections on Sales |
| 10% in month of sale |
| 25% in first month after sale |
| 35% in second month after sale |
| 30% in third month after sale |
| Other Cash Receipts |
| Total Cash Inflow |
| Cash Outflows |
| Material Purchases (reference only) |
| Payment for Material Purchase |
| 100% in month after purchase |
| Other Cash Payments |
| Other production cost 30% |
| of Material cost paid month |
| after Purchase |
| Selling and Marketing Expense |
| General and Adminstrative expenses |
| Interest Payment |
| Tax Payment |
| Dividend Payment |
| Total Cash Outlfows |
| Net Cash Gain/(Loss) |
| Cash Flow Summary |
| Cash Balance start of the month |
| Net Cash Gain/loss |
| Cash Balance at end of month |
| Minium cash Balance desired |
| Surplus cash (deficit) |
| External Financing Summary |
| External Financing Balance |
| at start of month |
| New Financing Required |
| (negative amount from cash |
| suplus (deficit) |
| External Financing Requirement |
| External Financing Balance |
Lisa Smith
genesis.xlsx
