Using an Excel spreadsheet* and your company's financial statements, compute the following for the most recent two years (chapters with information on each ratio are in parenthesis next to the ratio, refer to the tables in Section 13.3 Ratio Analysis on WileyPlus or pages 661-662, Appendix 13A provides a great example of ratio analysis):
- Current ratio (2,13)
- Working capital (not really a ratio) (2, 13)
- Inventory turnover ratio (6, 13)
- Accounts Receivable turnover ratio (8, 13)
- Debt to total assets ratio (2, 13)
- Return on assets (9,13)
- Asset turnover ratio (9, 13)
- Return on equity (11, 13)
- Gross profit ratio (5, 13)
- Profit margin ratio (5, 13)
Table of Contents Item 6. Selected Financial Data. The following table presents our selected financial data. The table should be read in conjunction with Item 7, Management's Discuss Item 8, Financial Statements and Supplementary Data, of this Annual Report on Form 10-K. Five-Year Financial Highlights $ in millions, except per share amounts Fiscal Year 2020(1) 2019 Consolidated Statements of Earnings Data Revenue $ 43,638 $ 42,879 Operating income 2,009 1,900 Net earnings from continuing operations 1,541 1,464 Gain from discontinued operations Net earnings 1,541 1,464 Per Share Data Diluted net earnings from continuing operations $ 5.75 $ 5.20 Net gain from discontinued operations Diluted net earnings 5.75 5.20 Cash dividends declared and paid 2.00 1.80 Operating Statistics Comparable sales growth(3) Gross profit rate Selling, general and administrative expenses rate Operating income rate Year-End Data Current ratio (4) 1.1 1.2 Total assets $ 15,591 $ 12,901 Debt, including current portion 1,271 1,388 Total equity 3,479 3,306 Number of stores Domestic(5) 1,009 1,026 International 222 212 Total 1.231 1,238 Retail square footage (in thousands) Domestic(5) 38,821 39,500 International 4,711 4,607 Total 43,532 44,107 (1) In the first quarter of fiscal 2020, we adopted new lease accounting guidance that resulted in the recognition of operating lease assets and operating lease liabilities 2.1 % 23.0 % 18.3 % 4.6% 4.8 % 23.2% 18.7 % 4.4 % Liquidity Ratios Working capital Current ratio p. 54 p. 54 Inventory turnover p. 283 Current assets - Current liabilities Current assets Current liabilities Cost of goods sold Average inventory 365 days Inventory turnover Net credit sales Average net accounts receivable 365 days Accounts receivable turnover Days in inventory p. 283 Accounts receivable turnover p. 395 Average collection period p. 395 Solvency Ratios Debt to assets ratio p. 56 Times interest earned Total liabilities Total assets Net income + Interest expense + Income tax expense Interest expense Net cash provided Capital Cash by operating activities expenditures dividends p. 497 Free cash flow p. 57 ILLUSTRATION 13-18 Summary of profitability ratios Profitability Ratios Earnings per share p. 53 Price-earnings ratio p. 660 Gross profit rate p. 234 Profit margin p. 235 Net income - Preferred dividends Weighted-average common shares outstanding Market price per share Earnings per share Gross profit Net sales Net income Net sales Net income Average total assets Net sales Average total assets Cash dividends declared on common stock Net income Net income - Preferred dividends Average common stockholders' equity Return on assets p. 444 Asset turnover p. 446 p. 560 Payout ratio Return on common stockholders' equity P. 561 Table of Contents Consolidated Balance Sheets $ in millions, except per share and share amounts February 1, 2020 February 2, 2019 $ $ 2.229 1,149 5,174 305 8,857 1,980 1,015 5,409 466 8,870 Assets Current assets Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets Property and equipment Land and buildings Leasehold improvements Fixtures and equipment Property under capital and financing leases Property under finance leases Gross property and equipment Less accumulated depreciation Net property and equipment Operating lease assets Goodwill Other assets Total assets 650 2,203 6,286 637 2,119 5,865 579 9,200 6.690 2,510 89 9.228 6.900 2.328 2.709 984 713 15,591 915 606 12.901 5,257 290 446 482 982 Liabilities and equity Current liabilities Accounts payable Unredeemed gift card liabilities Deferred revenue Accrued compensation and related expenses Accrued liabilities Current portion of operating lease liabilities Current portion of long-term debt Total current liabilities Long-term operating lease liabilities Long-term liabilities Long-term debt Contingencies and commitments (Note 13) Equity Best Buy Co., Inc. Shareholders' Equity Preferred stock, $1.00 par value: Authorized 400,000 shares; Issued and outstanding none Common stock, $0.10 par value: Authorized 1.0 billion shares; Issued and outstanding 256,494,000 and 265,703,000 shares, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive income Total equity Total liabilities and equity 5,288 281 501 410 906 660 14 8,060 2,138 657 1,257 56 7,513 750 1,332 26 27 3,158 295 3,479 15.591 2,985 294 3,306 12.901 See Notes to Consolidated Financial Statements. Consolidated Results Selected consolidated financial data was as follows ($ in millions, except per share amounts): 2.1 % 23.0 % 23.2% 18.3 % 18.7 % Consolidated Performance Summary 2020 2019 Revenue $ 43,638 42,879 Revenue % increase 1.8 % 1.7 % Comparable sales growth (1) 4.8 % Gross profit $ 10,048 $ 9,961 Gross profit as a % of revenue(2) SG&A $ 7,998 $ SG&A as a % of revenue 8,015 Restructuring charges $ 41 $ 46 Operating income $ 2,009 $ 1,900 Operating income as a % of revenue 4.6% Net earnings from continuing operations $ 1,541 $ 1,464 Gain from discontinued operations(3) $ $ Net earnings $ 1,541 $ 1,464 Diluted earnings per share $ 5.75 $ 5.20 (1) Comparable sales exclude the impact of the extra week in fiscal 2018. On March 1, 2018, we announced our intent to close all of our 257 remaining Best Buy Mobile stand-alone stores in the U.S. As a result, all revenue rel excluded from the comparable sales calculation beginning in March 2018. On October 1, 2018, we acquired all outstanding shares of GreatCall and on May 9, 2019, we acquired all outstanding shares of CST. Consistent w results of GreatCall are included in our comparable sales calculation beginning in the fourth quarter of fiscal 2020, and the results of CST are excluded from our comparable sales calculation for the periods presented. 4.4 % Table of Contents Income tax expense was comprised of the following ($ in millions): 2020 2019 2018 Current: Federal $ $ $ State Foreign 261 73 48 382 275 75 64 414 547 59 50 656 4 Deferred: Federal State Foreign 56 8 6 70 452 6 10 424 141 11 10 162 818 Income tax expense Deferred taxes are the result of differences between the bases of assets and liabilities for financial reporting and income tax purposes. Deferred tax assets and liabilities were comprised of the following ($ in millions): February 2, 2019 $ 52 74 35 40 46 Deferred revenue Compensation and benefits Stock-based compensation Other accrued expenses Accrued property expenses Operating lease liabilities Loss and credit carryforwards Other Total deferred tax assets Valuation allowance Total deferred tax assets after valuation allowance Inventory Property and equipment Operating lease assets Goodwill and intangibles Other Total deferred tax liabilities Net deferred tax assets (liabilities) February 1, 2020 1 57 57 34 37 13 734 127 46 1,105 (96) 1,009 (40) (237) (692) (45) (15) (1,029) (20) 134 38 419 (91) 328 (61) (184) (12) (16) (273) 55 Deferred taxes were presented as follows ($ in millions): February 1, 2020 February 2, 2019 $ $ 55 Balance Sheet Location Other assets Long-term liabilities Net deferred tax assets (liabilities) 9 (29) (20) 55 Table of Contents 15. Quarterly Financial Information (Unaudited) Unaudited quarterly results were as follows ($ in millions, except per share amounts): Quarter 1st 2nd 3rd 4th Fiscal Year Fiscal 2020 Revenue Gross profit Operating income Net earnings Basic earnings per share(1) Diluted earnings per share(1) $ $ $ $ 9,142 2. 169 334 265 0.99 0.98 $ $ $ $ $ $ $ $ $ $ 9,536 2,283 313 238 0.89 0.89 9,764 2,361 395 293 1.11 1.10 15,196 3,235 967 745 2.87 2.84 43,638 10,048 2,009 1,541 5.82 5.75 $ $ $ $ $ $ 4th Fiscal Year Quarter 1st 2nd 3rd Fiscal 2019 Revenue 9,109 $ 9,379 $ 9,590 $ Gross profit 2,125 $ 2,229 $ 2,324 $ Operating income $ 265 $ 335 $ $ 322 $ Net earnings $ 208 244 $ 277 $ Basic earnings per share(1) $ 0.74 $ 0.88 $ 1.01 $ Diluted earnings per share(1) $ 0.72 0.86 $ 0.99 $ (1) The sum of our quarterly diluted earnings per share does not equal our annual diluted earnings per share due to differences in quarterly and annual weighted average shares outstanding. 14,801 3,283 978 735 2.73 2.69 $ $ $ $ $ $ 42.879 9,961 1,900 1,464 5.30 5.20