Question
How do I calculate the External Financing Summary from the information below? JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER CASH
How do I calculate the External Financing Summary from the information below?
JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER CASH FLOW SUMMARY 1.Cash balance at start of month 0 -45,000 -90,000 -80,000 -125,000 -127,600 -145,000 -21,600 217,400 382,200 813,600 1,043,200 2.Net cash gain (loss) during month -45,000 -45,000 10,000 -45,000 -2,600 -17,400 123,400 239,000 164,800 431,400 229,600 -97,400 3.Cash bal. at end of month (before financing) -45,000 -90,000 -80,000 -125,000 -127,600 -145,000 -21,600 217,400 382,200 813,600 1,043,200 945,800 4.Minimum cash balance desired 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 5.Surplus cash (OR) Deficit cash (Line 3 - Line 4) -5,000 -40,000 -30,000 -75,000 -77,600 -95,000 28,400 167,400 332,200 763,600 993,200 895,800 EXTERNAL FINANCING SUMMARY 6.External financing balance - start of month 7.New financing reqd (negative of Line 5) (if deficit!) 8.Financing repayments (if surplus!) 9.Ext financing balance - end of month 10.Cash bal at end of mo (Line3 + Line7 + Line8)
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