Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the information in the provided Income Statement and Balance Sheet to create the 2017 Statement of Cash Flows and ratio calculations for 2017. Income
Use the information in the provided Income Statement and Balance Sheet to create the 2017 Statement of Cash Flows and ratio calculations for 2017.
Income Statement For the Years Ended December 31, 2017 and 2016 $ in millions 2016 2017 Revenue Net sales Cost of merchandise sold $27,528 37,043 20,807 16,236 16,099 11,429 Gross Profit Operating Expenses Selling, general and administrative Depreciation Amortization 5,757 1,223 124 4,449 5,985 2,499 124 7,752 Operating income Interest expense, net Gain/(Loss) on sale of property & equip 273 (149) 4,027 114 Income before income taxes 7,695 1,762 $ 5,933 Provision for income taxes 1,366 Net income $2,661 Balance Sheet December 31, 2017 and 2016 in millions 2016 2017 Current Assets Cash and cash equivalents Accounts Receivable, net Merchandise inventories Other current assets 1,610 $ 1,228 4,938 2,518 1,358 5,299 217 9,392 193 7,969 Total Current Assets Long-Term Assets 13,739 273 14,012 23,404 Property and equipment, net Intangible assets, net 10,844 Total Long-Term Assets Total Assets 397 11,241 19,210 $ Current Liabilities Accounts payable Accrued liabilities Income taxes payable Current portion of long-term debt 563 $ 206 110 451 779 258 84 470 1,591 Total Current Liabilities 1,330 Non-current Liabilities 4,450 5,780 Long-term debt 4,277 5,868 Total Liabilities Shareholders' Equity Common stock;.01 par value; 9,000 share authorized; 325 and 330 shares issued & outstanding respectively Paid-in capital Treasury stock, at cost, 160 & 175 Retained earnings 3,167 966 18,228 13,430 3,931 (10,513) 24,117 17,536 23,404 Total Shareholders' Equity Total Liabilities and Shareholders' Equity 19,210 $ Additional Information: The company paid dividends of $44 in 2017 The company purchased treasury stock of $2,547 during 2017, and sold stock for $764 during 2017. No other stock transactions took place The company purchased $7,545 in equipment during the year. In addition, equipment was sold for $2,265; the equipment had a book value at the time of sale of $2,151 There were no purchases or sales of intangible assets. Any change from 2016 to 2017 relates to amortization. The company paid payments of $450 on its debt obligations, but also took an additional $296 in new debt during the yearStep 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