Question

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

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

Answer 1

Cash Sheet

		March	April	May	June	July	Aug	Sep	Oct	Nov	Dec
Beginning Cash Balance		60,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000
Add:	Receipts	14,000	21,500	21,000	24,000	28,000	33,000	41,500	51,000	50,500	57,500
Total Cash Available		74,000	71,500	71,000	74,000	78,000	83,000	91,500	101,000	100,500	107,500
Less:	Disbursement
	Google Map	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 Disbursement		67,300	67,300	67,300	67,300	67,300	67,300	67,300	67,300	67,300	67,300
Cash Excess/Deficiency		6,700	4,200	3,700	6,700	10,700	15,700	24,200	33,700	33,200	40,200
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		43,300	45,800	46,300	43,300	39,300	34,300	25,800	16,300	16,800	9,800
Surplus Cash		0	0	0	0	0	0	0	0	0	0
Ending Cash Balance		50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000