Question
1. Use the information in the provided Income Statement and Balance Sheet to create the 2016 Statement of Cash Flows for ABC Company. This should
1. Use the information in the provided Income Statement and Balance Sheet to create the 2016 Statement of Cash Flows for ABC Company. This should be created on Tab 3 of the Excel Workbook. (I HAVE ALREADY MADE THE STATEMENT OF CASH FLOWS, SEE BELOW)
2. Formulas: a. Use Excel to setup the Statement of Cash Flows by linking the values from the Income Statement and the Balance Sheet. b. Use Excel formulas to calculate all totals and sub-totals. (AGAIN, I HAVE ALREADY MADE THE STATEMENT OF CASH FLOWS, SEE BELOW)
3. Complete the ratio calculations for 2016 on Tab 4 using the Income Statement and Balance Sheet. All ratios should be linked back to your financial statements.
I am needing help on:
A. Whether or not my Statement of Cash Flows is correct or not. If wrong, please fix.
B. What to enter in the "Ratios to Calculate" table.
ABC Company Income Statement For the Years Ended January 30, 2016 and 2015 USD in Millions Jan. 31, 2016 Jan. 31, 2015 19,204 19,023 Net sales Cost of merchandise sold 12,098 12,265 6,939 Gross margin 6,925 Operating expenses: 4,452 4,350 Selling, general and administrative Depreciation and amortization 934 886 Operating income 1,553 1,689 327 Interest expense, net 340 Loss on sale of property and equipment 169 0 Income before income taxes 1,349 1,057 384 Provision for income taxes 482 867 S 673 Net incomeStep 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