Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 2 Part Use the information from your forecast to calculate the sources and uses once you get your balance sheet to balance-typically in iteration

image text in transcribed

Part 2 Part Use the information from your forecast to calculate the sources and uses once you get your balance sheet to balance-typically in iteration number 4. Part 2 is worth 5 points. Sources of Cash Begin with net income and depreciation. Any asset that declines or liability that increases will be a source of cash. Sum total sources of cash. Ti Total sources of cash Uses of Cash Any asset that increases or liability that declines will be a use of cash. Sum total uses of cash. Total uses of cash External funding required The difference between sources and uses of cash equal the external funding required, aka Additional Funding Needed (AFN) in your textbook. The company plans to spend $55 on new fixed assets and has a depreciation expense of $25. Start with Oin bank loan for first iteration. Hold amortization of debt principle constant at $100 and keep accrued wages constant Long-term debt amortizes by 100 each year. No new common stock is issued nor repurchased. Use BASE for retained earnings. Plug your balance in to the next iteration's bank loan if this value is positive. If negative, subtract from bank loan. Once bank loan is zero, add to marketable securities. Part 2 Part Use the information from your forecast to calculate the sources and uses once you get your balance sheet to balance-typically in iteration number 4. Part 2 is worth 5 points. Sources of Cash Begin with net income and depreciation. Any asset that declines or liability that increases will be a source of cash. Sum total sources of cash. Ti Total sources of cash Uses of Cash Any asset that increases or liability that declines will be a use of cash. Sum total uses of cash. Total uses of cash External funding required The difference between sources and uses of cash equal the external funding required, aka Additional Funding Needed (AFN) in your textbook. The company plans to spend $55 on new fixed assets and has a depreciation expense of $25. Start with Oin bank loan for first iteration. Hold amortization of debt principle constant at $100 and keep accrued wages constant Long-term debt amortizes by 100 each year. No new common stock is issued nor repurchased. Use BASE for retained earnings. Plug your balance in to the next iteration's bank loan if this value is positive. If negative, subtract from bank loan. Once bank loan is zero, add to marketable securities

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

Equity Valuation And Portfolio Management

Authors: Frank J. Fabozzi, Harry M. Markowitz

1st Edition

047092991X, 9780470929919

More Books

Students also viewed these Finance questions