Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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

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

Financial Management For Public Health And Not-for-Profit Organizations

Authors: Steven A. Finkler, Daniel L. Smith, Thad D. Calabrese, Robert M. Purtell

7th Edition

1071835335, 978-1071835333

More Books

Students also viewed these Finance questions