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:

  1. Determine the Cash Flow From Assets (FCF), Cash Flow to Creditors, and Cash Flow to Shareholders for the firm.

Based on the excel information provided, please answer the following using excel

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!