I'm not the best at cash budget, and need this done for my group to look over in a few hours. I have an example of how our professor did it in class and my worksheet completed by another expert with my cash budget so far. I need the calculations and boxes to be filled out for the cash budget (if there's something I'm missing or not enough information, please let me know and I can provide the information required)
Edit: hoping this is what you meant
| | | March | April | May | June | July | August | September | October | November | December |
| Beginning Cash Balance | | 60,000 | | | | | | | | | |
| Add: | Receipts | | | | | | | | | | |
| Total Cash Available | | | | | | | | | | | |
| Less: | Disbursements | | | | | | | | | | |
| | Google Maps | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 |
| | Ads | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 |
| | Wages (team) | 44,500 | 44,500 | 44,500 | 44,500 | 44,500 | 44,500 | 44,500 | 44,500 | 44,500 | 44,500 |
| | App Development | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 |
| | R&D | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 |
| Total Disbursements | | | | | | | | | | | |
| Cash Excess/Deficiency | | | | | | | | | | | |
| Min. Cash Balance Desired | | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 |
| Financing Required | | | | | | | | | | | |
| Surplus Cash | | | | | | | | | | | |
| Ending Cash Balance | | | | | | | | | | | |
Cash Budget June, July, August, 19XX June July August Beg. Cash Balance $ 6,000 S 6,000 S 6,350 Add: Receipts 22.000 24500 19.500 (522,000 + 24.500 + 19,500)/3 months average build rate of $22,000 Less: Dish for Purch $20,250 $12,750 $18,000 Selling & Admin 2,500 2,500 2,500 Rent 750 750 750 Dividende 600 1450 (528,700 + 17,450 - 21,250)/3 months average burn rate of $22,467 Total Disbursements $28,700 $17.450 $21,250 (700) 13,050 4,600 6,000 6,000 6,000 Surplus Cash 6,700 7,050 Cash Excess: (Deficiency) Min Cash Balance Desired Financing Required Ending Cash Balance 1,400 $ 6,000 56,350 $6,000 Cash Budget June, July, August, 19XX June July August Bey Cash Balance $6.000 56.000 56.350 Al Race 22000 24.500 19.500 22 -34500 19.500 3 months to build rate of $22.000 Les for Puch 530.250 12.750 18.000 Selle 2.500 2.500 2.500 Monthly Net Cuh Bum-5457b 7 50 Druidende 600 $28.700 0100) 517,450 13.050 Toale DU Via Case Baie Desi Fencing Required Surplus Saling Curl Balance $21,250 4.500 6,000 1,400 6,700 56000 7.050 56.350 $6,000 Worksheet File Edit View @ Share Insert Format Data Tools Add-ons Help Last edit was 1 hour ago ? 100% - $ % . .00 123, - 11 - BI . A . PE - 1 - + Y. n a fx | Formula Total Sales for the month March 20,000 April 25,000 May 20,000 June 25,000 July 30,000 August 35,000 September 45,000 2 October 55,000 November 50,000 December 60,000 14,000 Net Sales Collections 70% month of sale 20% month follow 10% 2nd month Total Receipts 70% x Current Net Sales 20% x Previous Month Net Sales 10% x Net Sales of Two Months Prior 17,500 4,000 14,000 5,000 2,000 21,000 17,500 4,000 2,500 24,000 21,000 5,000 2,000 28,000 24,500 6,000 2,500 33,000 31,500 7,000 3,000 41,500 38,500 9,000 3,500 51,000 35,000 11,000 4,500 50,500 42,000 10,000 5,500 57,500 6 14,000 21,500 9 10 Net Purchases 30% next month sales 30% x Next Month Sales 7,500 6,000 7,500 9,000 10,500 13,500 16,500 15,000 18,000 11 5,250 5,250 12 13 14 15 Payments 70% month of purchase 30% month follow Total Disbursement for purchases 70% x Current Net Purchases 30% x Previous Month Net Purchases 4,200 2,250 6,450 1,800 6,300 2,250 8,550 7,350 2,700 10,050 9,450 3,150 12,600 11,550 4,050 15,600 10,500 4,950 15,450 12,600 4,500 17,100 5,400 5,400 5,250 7,050 Cash Budget File Edit View A Share Insert Format Data Tools Add-ons Help All changes saved in Drive n a ? 100% - $ % ._ .00 123 Default (Ari.. - 10 - BI . A . ES - E, I , O, - + D Y E . H March May June July August September October November December April 60,000 2 Beginning Cash Balance Receipts 5 300 Total Cash Available Less: Disbursements Google Maps Ads Wages (team) App Development R&D Total Disbursements Cash Excess/Deficiency Min. Cash Balance Desired Financing Required Surplus Cash Ending Cash Balance 300 7,500 44,500 5,000 10,000 7,500 44,500 5,000 10.000 300 7,500 44,500 5,000 10.000 300 7,500 44,500 5,000 10,000 300 7,500 44,500 5,000 10,000 300 7,500 44.500 5,000 10,000 300 7,500 44,500 5,000 10,000 300 7,500 44,500 5,000 10,000 300 7,500 44.500 5,000 10,000 300 7,500 44,500 5,000 10,000 - 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 12 13 14 15 16
