Genesis Energy Cash Position Analysis - Please don't contact me if you can't follow instructions and write a graduate style paper!!!!
micell32
M3A2GenesisCashBudget.xlsxM3,A2
| Module 3, Assignment 2 Template | |||||||||||||||||||||||||||
| Genesis Cash Budget | |||||||||||||||||||||||||||
| Year 0 Argosy: Argosy: Note, the percentages used in Year0 may be different from those estimated in the budget. | Monthly Cash Budget Year 1 | Monthly Cash Budget Year 2 | |||||||||||||||||||||||||
| Dec | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |||
| Cash Inflow | |||||||||||||||||||||||||||
| Sales (Reference only) | 300,000 | 350,000 | 350,000 | 400,000 | 400,000 | 300,000 | 350,000 | 450,000 | 550,000 | 600,000 | 700,000 | 750,000 | 600,000 | 550,000 | 500,000 | 450,000 | 450,000 | 450,000 | 500,000 | 550,000 | 600,000 | 750,000 | 800,000 | 800,000 | 600,000 | ||
| Cash Collections on Sales | |||||||||||||||||||||||||||
| 10% in month of sale | 30,000 | 35,000 | 35,000 | 40,000 | 40,000 | 30,000 | 35,000 | 45,000 | 55,000 | 60,000 | 70,000 | 75,000 | 60,000 | 55,000 | 50,000 | 45,000 | 45,000 | 45,000 | 50,000 | 55,000 | 60,000 | 75,000 | 80,000 | 80,000 | 60,000 | ||
| 25% in first month after sale | 75,000 | 75,000 | 87,500 | 87,500 | 100,000 | 100,000 | 75,000 | 87,500 | 112,500 | 137,500 | 150,000 | 175,000 | 187,500 | 150,000 | 137,500 | 125,000 | 112,500 | 112,500 | 112,500 | 125,000 | 137,500 | 150,000 | 187,500 | 200,000 | 200,000 | ||
| 35% in second month after sale | 105,000 | 105,000 | 105,000 | 122,500 | 122,500 | 140,000 | 140,000 | 105,000 | 122,500 | 157,500 | 192,500 | 210,000 | 245,000 | 262,500 | 210,000 | 192,500 | 175,000 | 157,500 | 157,500 | 157,500 | 175,000 | 192,500 | 210,000 | 262,500 | 280,000 | ||
| 30% in third month after sale | 90,000 | 90,000 | 90,000 | 90,000 | 105,000 | 105,000 | 120,000 | 120,000 | 90,000 | 105,000 | 135,000 | 165,000 | 180,000 | 210,000 | 225,000 | 180,000 | 165,000 | 150,000 | 135,000 | 135,000 | 135,000 | 150,000 | 165,000 | 180,000 | 225,000 | ||
| Other Cash Receipts | 12,500 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | ||
| Total Cash Inflow | 312,500 | 320,000 | 332,500 | 355,000 | 382,500 | 390,000 | 385,000 | 372,500 | 395,000 | 475,000 | 562,500 | 640,000 | 687,500 | 697,500 | 642,500 | 562,500 | 517,500 | 485,000 | 475,000 | 492,500 | 527,500 | 587,500 | 662,500 | 742,500 | 785,000 | ||
| Cash Outflows | |||||||||||||||||||||||||||
| Material Purchases (Reference only) | 150,000 | 157,500 | 157,500 | 180,000 | 180,000 | 135,000 | 157,500 | 202,500 | 247,500 | 270,000 | 315,000 | 337,500 | 270,000 | 247,500 | 225,000 | 202,500 | 202,500 | 202,500 | 225,000 | 247,500 | 270,000 | 337,500 | 360,000 | 360,000 | 270,000 | ||
| Payment for Material Purchase | |||||||||||||||||||||||||||
| 100% in month after purchase | 150,000 | 150,000 | 157,500 | 157,500 | 180,000 | 180,000 | 135,000 | 157,500 | 202,500 | 247,500 | 270,000 | 315,000 | 337,500 | 270,000 | 247,500 | 225,000 | 202,500 | 202,500 | 202,500 | 225,000 | 247,500 | 270,000 | 337,500 | 360,000 | 360,000 | ||
| Other Cash Payments: | |||||||||||||||||||||||||||
| Other production cost 30% | |||||||||||||||||||||||||||
| of Material cost paid month | |||||||||||||||||||||||||||
| after Purchase | 45,000 | 45,000 | 47,250 | 47,250 | 54,000 | 54,000 | 40,500 | 47,250 | 60,750 | 74,250 | 81,000 | 94,500 | 101,250 | 81,000 | 74,250 | 67,500 | 60,750 | 60,750 | 60,750 | 67,500 | 74,250 | 81,000 | 101,250 | 108,000 | 108,000 | ||
| Selling and Marketing Expense | 15,000 | 21,000 | 21,000 | 24,000 | 24,000 | 18,000 | 21,000 | 27,000 | 33,000 | 36,000 | 42,000 | 45,000 | 36,000 | 33,000 | 30,000 | 27,000 | 27,000 | 27,000 | 30,000 | 33,000 | 36,000 | 45,000 | 48,000 | 48,000 | 36,000 | ||
| General and Administrative expenses | 60,000 | 63,000 | 63,000 | 72,000 | 72,000 | 54,000 | 63,000 | 81,000 | 99,000 | 108,000 | 126,000 | 135,000 | 108,000 | 99,000 | 90,000 | 81,000 | 81,000 | 81,000 | 90,000 | 99,000 | 108,000 | 135,000 | 144,000 | 144,000 | 108,000 | ||
| Interest Payment | 75,000 | 10,000 | - 0 | ||||||||||||||||||||||||
| Tax Payment | . | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | |||||||||||||||||||||
| Dividend Payment | - 0 | ||||||||||||||||||||||||||
| Total Cash Outflows | 345,000 | 294,000 | 288,750 | 300,750 | 345,000 | 306,000 | 259,500 | 327,750 | 395,250 | 465,750 | 534,000 | 589,500 | 592,750 | 498,000 | 441,750 | 400,500 | 371,250 | 371,250 | 383,250 | 424,500 | 465,750 | 531,000 | 630,750 | 660,000 | 612,000 | ||
| Net Cash Gain/(Loss) | (32,500) | 26,000 | 43,750 | 54,250 | 37,500 | 84,000 | 125,500 | 44,750 | (250) | 9,250 | 28,500 | 50,500 | 94,750 | 199,500 | 200,750 | 162,000 | 146,250 | 113,750 | 91,750 | 68,000 | 61,750 | 56,500 | 31,750 | 82,500 | 173,000 | ||
| Cash Flow Summary | |||||||||||||||||||||||||||
| Cash Balance start of the month | 10,000 | (32,500) | (31,500) | (12,750) | 16,500 | 29,000 | 88,000 | 188,500 | 208,250 | 183,000 | 167,250 | 170,750 | 196,250 | 771,000 | 970,500 | 1,171,250 | 1,333,250 | 1,479,500 | 1,593,250 | 1,685,000 | 1,753,000 | 1,814,750 | 1,871,250 | 1,903,000 | 1,985,500 | ||
| Net Cash Gain/loss | (32,500) | 26,000 | 43,750 | 54,250 | 37,500 | 84,000 | 125,500 | 44,750 | (250) | 9,250 | 28,500 | 50,500 | 94,750 | 199,500 | 200,750 | 162,000 | 146,250 | 113,750 | 91,750 | 68,000 | 61,750 | 56,500 | 31,750 | 82,500 | 173,000 | ||
| Cash Balance at end of month | (22,500) | (6,500) | 12,250 | 41,500 | 54,000 | 113,000 | 213,500 | 233,250 | 208,000 | 192,250 | 195,750 | 221,250 | 291,000 | 970,500 | 1,171,250 | 1,333,250 | 1,479,500 | 1,593,250 | 1,685,000 | 1,753,000 | 1,814,750 | 1,871,250 | 1,903,000 | 1,985,500 | 2,158,500 | ||
| Minimum Cash Balance desired | 10,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,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | ||
| Surplus cash (deficit) | (32,500) | (31,500) | (12,750) | 16,500 | 29,000 | 88,000 | 188,500 | 208,250 | 183,000 | 167,250 | 170,750 | 196,250 | 266,000 | 945,500 | 1,146,250 | 1,308,250 | 1,454,500 | 1,568,250 | 1,660,000 | 1,728,000 | 1,789,750 | 1,846,250 | 1,878,000 | 1,960,500 | 2,133,500 | ||
| External Financing Summary | |||||||||||||||||||||||||||
| External Financing Balance | |||||||||||||||||||||||||||
| at start of month | - 0 | (32,500) | (64,000) | (76,500) | (60,000) | (31,000) | - 0 | - 0 | |||||||||||||||||||
| New Financing Required | |||||||||||||||||||||||||||
| negative amount from cash | (12,750) | ||||||||||||||||||||||||||
| surplus (deficit) | (32,500) | (31,500) | (12,750) | 16,500 | 29,000 | 88,000 | |||||||||||||||||||||
| External Financing Requirement | (32,500) | (31,500) | (12,750) | - 0 | |||||||||||||||||||||||
| External Financing Balance | -32,500 | -64,000 | -76,750 | -60,000 | -31,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
