Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Income statement is provided below the question. Please show cell formulas and screen shots thank you 2. Balance Sheet (2019/20 millions of dollars) Assets

The Income statement is provided below the question. Please show cell formulas and screen shots thank you

image text in transcribed

image text in transcribed

2. Balance Sheet (2019/20 millions of dollars) Assets 2019 2020 Liab. & Common Equity 2019 2020 Current Assets $2130 $2260 Current Liabilities $1620 $1710 Fixed Assets $500 $750 LT Debt $800 $1041 Total Liabilities $2420 $2751 Common Stock $210 $210 Total Assets $2630 $3010 Add to Retained $0 $49 Total Liab. & Equity $2630 $3010 Given the above Income Statement and Balance Sheet from 2019-20, compute the Cash Flow from Assets (include: Operating Cash Flow, Net Capital Spending and Net Working Capital), CFC, and CFS. Briefly explain the significance of this Cash Flow analysis in terms of where the cash is "coming from" and how it is being used" (final results on OCF, Change in NWC, Change in Cap Spending; components of CFC and CFS) as well as how this company is financing its asset growth. (9 points) Calibri (Body) 12 Paste B I U E13 fx B C A 1 1 Income Statement 2 3 Sales 4 Less: Costs of Goods Sold 5 Gross Profit 6 Less: Depreciation 7 EBIT 8 Less: Interest Expense 9 EBT 10 Less: Taxes 11 Net Income 12 Less: Dividend 13 Addition to retained Earnings 14 15 600 300 300 150 150 30 120 41 79 30 49

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

Accounting In Business

Authors: R. J. Bull

5th Edition

0408014865, 978-0408014861

More Books

Students also viewed these Accounting questions

Question

5.2 Summarize the environment of recruitment.

Answered: 1 week ago