Question: fake invome statement from my study guide. having a hard time figuring out how to put this into excel . Given the above Income Statement
fake invome statement from my study guide. having a hard time figuring out how to put this into excel. Given the above Income Statement and Balance Sheet from 2018-19, 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" as well as how this company is financing its "growth". (10 pts.) 1. What is the structure of the Income Statement (in millions of $'s), assuming the following inputs? Make sure you include EBIT, EBT, and Net Income. (5 Points) Cost of Goods Sold: $300 Interest Paid $30 Taxes $41 Depreciation $150 Sales $600 Dividends $30 Addition to RE $49 Balance Sheet Assets Current Assets Fixed Assets 2018 2019 $2130 $2260 $500 $750 Liab. & Common Equity 2018 2019 Current Liabilities $1620 $1710 LT Debt $800 $1041 Total Liabilities $2420 $2751 Common Stock $210 $210 Add to Retained $0 $49 Total Liab. & Equity $2630 $3010 Total Assets $2630 $3010 Other Information 2019 Price of Stock: $48 2019 Shares Outstanding: 200
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
