| 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 | 30,000 | 20,000 | 35,000 | 40,000 | 50,000 | 55,000 | 70,000 | 70,000 | 65,000 | 90,000 | 85,000 | 75,000 | 50,000 | 15,000 | 19,000 | 300,000 | 240,000 |
| 25% in first month after sale | 75,000 | 50,000 | 87,500 | 100,000 | 125,000 | 137,500 | 175,000 | 175,000 | 162,500 | 225,000 | 212,500 | 187,500 | 125,000 | 37,500 | 47,500 | 750,000 |
| 35% in second month after sale | 70,000 | 122,500 | 140,000 | 175,000 | 192,500 | 245,000 | 245,000 | 227,500 | 315,000 | 297,500 | 262,500 | 175,000 | 52,500 | 66,500 | 1,050,000 |
| 30% in third month after sale | 105,000 | 120,000 | 150,000 | 165,000 | 210,000 | 210,000 | 195,000 | 270,000 | 255,000 | 225,000 | 150,000 | 45,000 | 57,000 | 900,000 |
| Other Cash Receipts | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 |
| Total Cash Inflow | 45,000 | 110,000 | 170,000 | 370,000 | 425,000 | 520,000 | 580,000 | 715,000 | 710,000 | 690,000 | 910,000 | 855,000 | 740,000 | 480,000 | 169,000 | 486,000 | 2,955,000 |
| Cash Outflows |
| Material Purchases (reference only) | 150,000 | 100,000 | 175,000 | 200,000 | 250,000 | 275,000 | 350,000 | 350,000 | 325,000 | 450,000 | 425,000 | 375,000 | 250,000 | 75,000 | 95,000 | 1,500,000 | 1,200,000 |
| Payment for Material Purchase |
| 100% in month after purchase | 150,000 | 100,000 | 175,000 | 200,000 | 250,000 | 275,000 | 350,000 | 350,000 | 325,000 | 450,000 | 425,000 | 375,000 | 250,000 | 75,000 | 95,000 | 1,500,000 |
| Other Cash Payments |
| Other production cost 30% |
| of Material cost paid month |
| after Purchase | 45,000 | 30,000 | 52,500 | 60,000 | 75,000 | 82,500 | 105,000 | 105,000 | 97,500 | 135,000 | 127,500 | 112,500 | 75,000 | 22,500 | 28,500 | 450,000 |
| Selling and Marketing Expense | 15,000 | 10,000 | 17,500 | 20,000 | 25,000 | 27,500 | 35,000 | 35,000 | 32,500 | 45,000 | 42,500 | 37,500 | 25,000 | 7,500 | 9,500 | 150,000 | 120,000 |
| General and Adminstrative expenses | 60,000 | 40,000 | 70,000 | 80,000 | 100,000 | 110,000 | 140,000 | 140,000 | 130,000 | 180,000 | 170,000 | 150,000 | 100,000 | 30,000 | 38,000 | 600,000 | 480,000 |
| Interest Payment | 75,000 | 75,000 | 75,000 |
| Tax Payment | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 |
| Dividend Payment |
| Total Cash Outlfows | 150,000 | 260,000 | 217,500 | 327,500 | 400,000 | 462,500 | 532,500 | 645,000 | 617,500 | 647,500 | 812,500 | 740,000 | 687,500 | 377,500 | 160,000 | 888,500 | 2,640,000 |
| Net Cash Gain/(Loss) | (105,000) | (150,000) | (47,500) | 42,500 | 25,000 | 57,500 | 47,500 | 70,000 | 92,500 | 42,500 | 97,500 | 115,000 | 52,500 | 102,500 | 9,000 | (402,500) | 315,000 |
| Cash Flow Summary |
| Cash Balance start of the month | 15,000 |
| 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 |
aewtts
m3_a2_cash_budget.xlsx
