Please help me figure out the month's Cash balance should be $659,591. I don't know...

60.1K

Verified Solution

Question

Accounting

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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students