60.1K

Verified Solution

Link Copied!

Please help me figure out the month's Cash balance should be $659,591. I don't know which step I wrong. Th minimum cash in every month is $15000 and the interested rate to borrow the money is 10%.

				SCENARIO 1
				Le, Le Co
				Cash Budget
				For the Three Months Ending June 30, 202X
				April	May	June	Quarter
Cash balance beginning of month				$ 16,000	$ (315,650)	$ (813,350)	$ 16,000
Add cash from customers				4,011,850	5,448,900	7,281,600	16,742,350
Total cash available				4,027,850	5,133,250	6,468,250	16,758,350
Less cash payments:
	Purchase of Inventory			3,736,500	5,172,000	4,824,000	13,732,500
	Sales commissions			537,600	691,200	921,600	2,150,400
	Salaries and wages			49,000	49,000	49,000	147,000
	Utilities			1,700	1,700	1,700	5,100
	Misc			2,700	2,700	2,700	8,100
	Dividends paid			16,000			16,000
	Equipment Purchases				30,000		30,000
	Total cash paid			4,343,500	5,946,600	5,799,000	16,089,100
Excess (deficiency) of available over pmts				(315,650)	(813,350)	669,250	669,250
Financing
	Borrowing (Repayment)			330,650	828,350	(644,592)	514,408
	Interest					(9,658)	(9,658)
	Total financing			330,650	828,350	(654,250)	504,750
Cash balance end of month				$ 15,000	$ 15,000	$ 15,000	$ 1,174,000

Answer & Explanation Solved by verified expert

See Answer