Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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_2

Step: 3

blur-text-image_3

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 Principles Managerial Concepts

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Kinnear, Joan E. Barlow

7th Canadian Edition

1119310296, 978-1119310297

More Books

Students also viewed these Accounting questions

Question

What is the purpose of the federal Employment Equity Act?

Answered: 1 week ago