Cash Budget Spreadsheet
squekkThis is what the Professor provided me with
You have errors on the calculations of cash outflows and external financing required.
Your recommendations were good for Genesis
For cash outflows
Cash Outflows | Dec | Jan | Feb |
Material Purchases (reference only) | 150,000 | 100,000 | 175,000 |
Payment for Material Purchase | |||
100% in month after purchase | - | 150,000 | 100,000 |
Other Cash Payments: | |||
Other production cost 30% | |||
of Material cost paid month | |||
after Purchase | 45,000 | 30,000 | |
Selling and Marketing Expense | 15,000 | 10,000 | 17,500 |
General and Administrative expenses | 60,000 | 40,000 | 70,000 |
Interest Payment | 75,000 | ||
Tax Payment | . | 15,000 | - |
Dividend Payment | - | - | - |
Total Cash Outflows | 150,000 | 260,000 | 217,500 |
External Financing Summary | Dec | Jan | Feb |
External Financing Balance | |||
at start of month | - | 115,000 | 265,000 |
New Financing Required | |||
negative amount from cash | |||
surplus (deficit) | (115,000) | (150,000) | (12,500) |
External Financing Requirement | (115,000) | (265,000) | (277,500) |
External Financing Balance | 115,000 | 265,000 | 277,500 |
13 years ago
