Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Finance For Non Finance Managers

Authors: Jai Kumar Batra

1st Edition

9352806964, 978-9352806966

More Books

Students also viewed these Accounting questions