Each student will calculate and submit a separate Word or PDF document for their selected retailer using data from the abbreviated income statements and balance sheets included in their Annual Reports. Same-store sales increase or decrease compared to prior year 5. Gross margin dollars & percentage SG&A expense dollars & percentage Operating profit margin dollars & percentage Net profit margin (after taxes) dollars &percentage Inventory turnover Asset turnover Return on Assets (ROA) percentage GMROI (10%) The Group will then prepare a PowerPoint presentation to contain the following: Rank the retailers according to the calculated financial categories above for the four or five retailers depending on team size. Analyze and discuss why the percentages and ratios differ for the two retailers. s Analyze which retailer has the better overall financial performance. Why is ROA a good measure of a retailers' financial performance? Consolidated Statements of Cash Flows Sin millions February 3 2018 January 28, 2017 January 30, 2016 1.000 $ 1.228 897 6R3 10 654 39 657 201 (99) 104 49 59 129 162 (13) 108 201 (17) 315 (335) (21) (196) 117 290 2.141 (193) 199 10 518 23 123 86 36 (536) (140) (94) 1.343 2.557 (688) (4,325) 4,018 (580) (3,045) 2.689 Fiscal Years Ended Operating activities Net camnings Adjustments to reconcile net earings to sotal cash provided by operating activities: Depreciation Restructuring charges Gain on sale of business Stock-based compensation Deferred income taxes Othernet Changes in operating assets and liabilities: Receivables Merchandise inventories Other assets Accounts payable Other liabilities Income taxes Total cash provided by operating activities Investing activities Additions to property and equipment, net of S123, 548 and 392 respectively, of non-cash capital expenditures Purchases of investments Sales of investments Proceeds from sale of business, net of cash transferred Proceeds from property disposition Other, net Total cash used in investing activities Financing activities Repurchase of common stock Prepayment of accelerated share repurchase Issuance of common stock Dividends paid Repayments of debt Other, net Total cash used in financing activities Effect of exchange rate changes on cash Increase (decrease) in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash at beginning of period, excluding held for sale Cash, cash equivalents and restricted cash at beginning of period, held for sale Cash, cash equivalents and restricted cash at end of period Supplemental disclosure of cash flow information Income taxes paid Interest paid See Notes to Consolidated Financial Statements. (649) (2.281) 2.427 (51) 56 1.002) 28 (526 (877 (2,004) (698) 163 (409) (46) (1) 2.297 25 (1.133) 171 (505) (394) 8 (1.418) 10 272 (1.000) (55) 47 (499) (28) (D) (1 536) (38) (757) 2.433 2,161 2,616 302 1.300 S 2.433 S 2.161 3665 81 628 $ 76 550 77 Consolidated Balance Sheets $ in millions, except per share and share amounts February 3, 2015 January 28, 2017 1.1015 2.032 1.049 5,209 438 2.340 1.681 1.347 4.864 384 10,516 2.327 5.410 340 &700 618 2.227 4,998 300 8143 5,850 2.293 425 622 13,856 2.421 425 374 13.049 $ Assets Current Assets Cash and cash equivalents Short-term investments Receivables, net Merchandise inventories Other current assets Total current assets Property and Equipment Land and buildings Leaschold improvements Fixtures and equipment Property under capital and financing lases Less accumulated depreciation Net property and equipment Goodwill Other Assets Total Assets Liabilities and Equity Current Liabilities Accounts payable Unredeemed gift card liabilities Deferred revenue Accrued compensation and related expenses Accrued liabilities Accrued income taxes Current portion of long-term debt Total current liabilities Long-Term Liabilities Long-Term Debt Contingencies and Commitments (Note 12) Equity Best Buy Co., Inc. Shareholders' Equity Preferred stock, S1.00 par value: Authorized -- 400,000 shares; Issued and outstanding --- none Common stock. 50.10 par value: Authorized -- 1.0 billion shares Issued and outstanding -- 282.988,000 and 311,108,000 shares, respectively Additional paid in capital Retained earnings Accumulated other comprehensive income Total cquity Total Liabilities and Equity See Notes to Consolidated Financial Statements 4.984 427 418 4.873 385 453 561 864 137 544 7.817 DO 11 358 865 26 44 7.122 704 1.321 1 28 31 3.270 314 3.612 13.049 $ 4.399 279 4,709 13.856 s Consolidated Statements of Comprehensive Income S in millions Fiscal Years Ended Net carnings Foreign currency translation adjustments Reclassification of foreign currency translations adjustments into earnings due to sale of business Comprehensive income See Notes to Consolidated Financial Statements. February 3. January 28, January 30. 2018 2017 2016 s 1,000 S 1.228 S 897 35 10 (2) 1,236 $ (67) 786 $ 1,035 2018 Consolidated Statements of Earnings S and shares in millions, except per share amounts February 3, January 28, January 30, Fiscal Years Ended 2017 2016 Revenue 42,151 5 39,403 $ 39,528 Cost of goods sold 32,275 29.963 30,334 Restructuring charges - cost of goods sold 3 Gross profit 9,876 9,440 9,191 Selling, general and administrative expenses 8,023 7,547 7,618 Restructuring charges 10 39 198 Operating income 1.843 1,854 1,375 Other income (expense) Gain on sale of investments 3 2 Investment income and other 48 31 13 Interest expense (75) (72) (80) Earnings from continuing operations before income tax expense 1,817 1.816 1,310 Income tax expense 818 609 503 Net earnings from continuing operations 999 1,207 807 Gain from discontinued operations (Note 2), net of tax expense of $0, S7 and Si. respectively 21 90 Net earnings $ 1,000 228 897 1 3.33 $ Basic earnings per share Continuing operations Discontinued operations Basic earnings per share 3.79 $ 0.07 3.86 $ 2.33 0.26 $ 3.33 $ 2.59 3.26 $ Diluted earnings per share Continuing operations Discontinued operations Diluted camnings per share 3.74 $ 0.07 3.81 2.30 0.26 2.56 S 3.26 $ Weighted average common shares outstanding Basic Diluted See Notes to Consolidated Financial Statements. 300.4 307.1 318.5 322.6 346,5 350.7