Question: Based on the excel information provided, please answer the following using excel formula's: Determine the Cash Flow From Assets (FCF), Cash Flow to Creditors, and
Based on the excel information provided, please answer the following using excel formula's:
- Determine the Cash Flow From Assets (FCF), Cash Flow to Creditors, and Cash Flow to Shareholders for the firm.

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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
