| 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 | 1,140,000 | 2,012,500 | 2,531,250 | 2,310,000 |
| Cash Collections on Sales |
| 10% in month of sale | | 20,000 | 35,000 | 40,000 | 50,000 | 55,000 | 70,000 | 70,000 | 65,000 | 90,000 | 85,000 | 75,000 | 50,000 | 114,000 | 201,250 | 253,125 | 231,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 | 255,000 | 416,875 | 576,563 | 687,500 |
| 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 | 210,000 | 503,125 | 767,813 | 924,000 |
| 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 | 108,000 | 327,750 | 590,625 | 742,500 |
| 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 | 45,000 | 45,000 | 45,000 | 45,000 |
| Total Cash Inflow | | 110,000 | 205,000 | 302,500 | 347,500 | 440,000 | 517,500 | 602,500 | 665,000 | 722,500 | 762,500 | 812,500 | 820,000 | 732,000 | 1,494,000 | 2,233,125 | 2,630,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) | (570,000) | (1,006,250) | (1,265,625) | (1,155,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) | (570,000) | (1,006,250) | (1,265,625) | (1,155,000) |
| Other Cash Payments |
| Other production cost 30% | (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) | (171,000) | (301,875) | (379,688) | (346,500) |
| of Material cost paid month | | (45,000) | (30,000) | (52,500) | (60,000) | (75,000) | (82,500) | (105,000) | (105,000) | (97,500) | (135,000) | (127,500) | (112,500) | (153,000) | (250,125) | (345,938) | (412,500) |
| after Purchase |
| Selling and Marketing Expense | | (10,000) | (17,500) | (20,000) | (25,000) | (27,500) | (35,000) | (35,000) | (32,500) | (45,000) | (42,500) | (37,500) | (25,000) | (57,000) | (100,625) | (126,563) | (115,500) |
| General and Adminstrative expenses | | (40,000) | (70,000) | (80,000) | (100,000) | (110,000) | (140,000) | (140,000) | (130,000) | (180,000) | (170,000) | (150,000) | (100,000) | (228,000) | (402,500) | (506,250) | (462,000) |
| Interest Payment | | (375) | (375) | (375) | (375) | (375) | (375) | (375) | (375) | (375) | (375) | (375) | (75,000) | (4,500) | (4,500) | (4,500) | (17,364) |
| Tax Payment | | 0 | 0 | 0 | (15,000) | 0 | 0 | (15,000) | 0 | 0 | (15,000) | 0 | 0 | 0 | (32,250) | (16,875) | (16,500) |
| Dividend Payment |
| Total Cash Outlfows | | (225,375) | (345,375) | (412,875) | (525,375) | (570,375) | (712,875) | (750,375) | (690,375) | (907,875) | (915,375) | (802,875) | (637,500) | (1,183,500) | (2,098,125) | (2,645,438) | (2,525,364) |
| Net Cash Gain/(Loss) | | (115,375) | (140,375) | (110,375) | (177,875) | (130,375) | (195,375) | (147,875) | (25,375) | (185,375) | (152,875) | 9,625 | 182,500 | (451,500) | (604,125) | (412,313) | 104,636 |
| Cash Flow Summary |
| Cash Balance start of the month | | 2,650,000 | 2,534,625 | 2,394,250 | 2,283,875 | 2,106,000 | 1,975,625 | 1,780,250 | 1,632,375 | 1,607,000 | 1,421,625 | 1,268,750 | 1,278,375 | 1,460,875 | 1,009,375 | 405,250 | 150,000 |
| Net Cash Gain/loss | | (115,375) | (140,375) | (110,375) | (177,875) | (130,375) | (195,375) | (147,875) | (25,375) | (185,375) | (152,875) | 9,625 | 182,500 | (451,500) | (604,125) | (412,313) | 104,636 |
| Cash Balance at end of month | | 2,534,625 | 2,394,250 | 2,283,875 | 2,106,000 | 1,975,625 | 1,780,250 | 1,632,375 | 1,607,000 | 1,421,625 | 1,268,750 | 1,278,375 | 1,460,875 | 1,009,375 | 405,250 | 150,000 | 254,636 |
| Minium cash Balance desired | | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 |
| Surplus cash (deficit) | | 2,534,625 | 2,394,250 | 2,283,875 | 2,106,000 | 1,975,625 | 1,780,250 | 1,632,375 | 1,607,000 | 1,421,625 | 1,268,750 | 1,278,375 | 1,460,875 | 1,009,375 | 405,250 | (142,938) | 254,636 |
| External Financing Summary |
| External Financing Balance | 50,000 | 50,000 | | | | | | | | | | | | 50,000 |
| at start of month |
| New Financing Required | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | (142,938) | 0 |
| (negative amount from cash |
| suplus (deficit) |
| External Financing Requirement | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 142,938 | 0 |
| External Financing Balance | | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 192,938 | 192,938 |
elialb1
budget_hw.xls
