Cash Budget
		Maintain a minimum month end cash balance of $40,000
		Maintains a 15% open line of credit for $125,000
			Borrowing happens on the first day of the month
			Repayments are made on the last day of the month
		Cash dividend paid in August							$60,000
		Equipment purchases made in Q3 2021
			Equipment purchased with cash in July						$55,000
			Equipment purchased with cash in September						$150,000
		June 30 ending cash balance was $40,000

July, August and September.

I got stuck on the financing part, I do not know how to solve it.

Construct Cash Budget | July $40,000 $420,000 $460,000 Quarter 3, 2021 August September $40,000 $51.969 $495,000 $630,000 $535,000 $681,969 Total $40,000 $1,545,000 $1,585,000 $ 90,112.50 $112,781.25 $61,125 $70,875.00 $151,875 $168,125.00 $70,000 $71,250.00 $55,000 | $60,000 $ 428,112.50 $483,031 $ (31,887.50 $51,969 $128.281.25 $84,375.00 $190,625.00 $75,000.00 $150,000.00 Beginning Cash Balance Add: Cash collections Total cash available Less: Cash disbursements Materials Direct labor Manufacturing O/H Selling and Admin Equipment purchase Dividend Total disbursements Excess Deficiency) Financing Borrowing Repayments Interest Total financing Ending Cash Balance $ 331,175.00 $216,375.00 $510,625.00 $216,250.00 $ 205,000.00 $628,281.25 $53,687.50 $ 1,479,425.00 $105,575.00 $71,887.50 - - - - - $71,887.50 $71,887.50) ($2,875.50 ($74,763.00) $30,812.00 $40,000 $51,969 $53,688