Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
fake invome statement from my study guide. having a hard time figuring out how to put this into excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started