Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 | ||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started