| 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 | | | 105,000 | 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 |
| 30% in third month after sale | | | | 90,000 | 60,000 | 105,000 | 120,000 | 150,000 | 165,000 | 210,000 | 210,000 | 195,000 | 270,000 | 255,000 | 225,000 | 150,000 | 45,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 | 205,000 | 302,500 | 347,500 | 440,000 | 517,500 | 602,500 | 665,000 | 722,500 | 762,500 | 812,500 | 820,000 | 672,500 | 471,500 | 565,000 | 1,116,500 |
| 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 |
| Net Cash Gain/(Loss) | -105,000 | -150,000 | -12,500 | -25,000 | -52,500 | -22,500 | -15,000 | -42,500 | 47,500 | 75,000 | -50,000 | 72,500 | 132,500 | 295,000 | 311,500 | -323,500 | 1,116,500 |
| Cash Flow Summary |
| Cash Balance start of the month | 15,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,005 | 25,006 | 25,007 | 25,008 |
| Net Cash Gain/loss | -105,000 | -150,000 | -12,500 | -25,000 | -52,500 | -22,500 | -15,000 | -42,500 | 47,500 | 75,000 | -50,000 | 72,500 | 132,500 | 295,000 | 311,500 | -323,500 | 1,116,500 |
| Cash Balance at end of month | -90,000 | -125,000 | 12,500 | 0 | -27,500 | 2,500 | 10,000 | -17,500 | 72,500 | 100,000 | -25,000 | 97,500 | 157,500 | 320,005 | 336,506 | -298,493 | 1,141,508 |
| Minium cash Balance desired | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,005 | 25,006 | 25,007 | 25,008 |
| Surplus cash (deficit) | -115,000 | -150,000 | -12,500 | -25,000 | -52,500 | -22,500 | -15,000 | -42,500 | 47,500 | 75,000 | -50,000 | 72,500 | 132,500 | 295,000 | 311,500 | -323,500 | 1,116,500 |
| External Financing Summary |
| External Financing Balance |
| at start of month | | 115,000 | 265,000 | 277,500 | 302,500 | 355,000 | 377,500 | 392,500 | 435,000 | 387,500 | 312,500 | 362,500 | 290,000 | 157,500 | -137,500 | -449,000 | -125,500 |
| New Financing Required |
| (negative amount from cash |
| suplus (deficit) |
| External Financing Requirement | 115,000 | 150,000 | 12,500 | 25,000 | 52,500 | 22,500 | 15,000 | 42,500 | -47,500 | -75,000 | 50,000 | -72,500 | -132,500 | -295,000 | -311,500 | 323,500 | -1,116,500 |
| External Financing Balance | 115,000 | 265,000 | 277,500 | 302,500 | 355,000 | 377,500 | 392,500 | 435,000 | 387,500 | 312,500 | 362,500 | 290,000 | 157,500 | -137,500 | -449,000 | -125,500 | -1,242,000 |
morpre
m3_a2_cash_budget.xlsx
