Based on the excel information below, please answer the following using excel formula's:

1. Determine the Cash Flow From Assets (FCF), Cash Flow to Creditors, and Cash Flow to Shareholders for the firm.
2. Assume you are sitting in a board meeting discussing the firms plans for sales growth. You are telling the board that you expect to grow sales by 20 %. After explaining your plan, a board member asks you for an estimate of how much funding you will need in 2020. What is your answer if you use the formula for External Funds Needed?
3. Now assume the board member asks whether or not you can achieve the growth holding your capital structure constant. What is your answer?
4. Calculate the following ratios for the firm for 2019.

Current Quick Cash Debt

Equity Mult Cash Coverage Inventory Turn Days Sales in Inv

Rec Turn Days Sales Out Total Asset Turn Profit Margin

ROA ROE

5. Also calculate ROE using the expanded DuPont formula.

A B C D E F G H K L 1 2 3 4 5 Assets: Cash Accounts Receivable Inventory Total Current Balance Sheet Liab+Eq: Acc Payable Accruals Total Current 2019 2018 $ 160 $ 154 $ 575 $ 455 $ 555 $ 450 $ 1,290 $ 1,059 2019 2018 $ 266 $ 100 $ 200 $ 150 $ 466 $ 250 6 Income Statement 2019 Sales $ 1,509 Cost of Goods Sold $ 900 Depreciation $ 90 Operating Income $ 519 7 00 O 350 Long-Term Debt Total Liab $ $ 380 $ 846 $ 10 600 70 Net Fixed Assets Total Assets $ 1,650 $ 1,400 $ 2,940 $ 2,459 Interest Expense Pre-tax Income $ $ 11 449 12 13 Taxes 212 $ $ Net Income 237 14 15 Common @ Par $ Capital Surplus $ Retained Earnings $ Treasury Stock $ Total Eq $ Total Liab & Eq $ 55 $ 45 585 $ 494 1,504 $ 1,370 (50) $ (50) 2,094 $ 1,859 2,940 $ 2,459 16 103 Dividends Addition to RE's $ $ 17 134 18 19 20