1 2 3 The Home Depot, Inc. --> do not make any changes to columns A, B, C, D, E Consolidated Statement of Earnings --> all your linking & formulas are within this worksheet only (no linking to Company worksheets) (amounts in millions, except per share data) Fiscal Year Ended Horizontal Analysis Vertical Analysis $ Increase (Decrease) % Increase (Decrease) % of Net Sales Feb. 03, 2019 Feb. 02, 2020 Jan. 31, 2021 2020 vs 2019 2021 vs 2020 2020 vs 2019 2021 vs 2020 Feb. 03, 2019 Feb. 02, 2020 Jan. 31, 2021 $ 108,203 $ 110,225 $ 132,110 71,043 72,653 87,257 37,160 37,572 44,853 4. 5 6 7 Net sales 8 Cost of sales 9 Gross profit 10 Operating expenses: 11 SG&A 12 Depreciation 13 Total operating expenses 14 Total income from operations 15 Non-operating income (expense): 16 Interest expense, net 17 Earnings before provision for income taxes 18 Provision for income tax 19 Net income 20 21 22 23 19,513 2,117 21,630 15,530 19,740 1,989 21,729 15,843 24,447 2,128 26,575 18,278 (974) 14,556 3,435 11,121 $ (1,128) 14,715 3,473 11,242 $ (1,300) 16,978 4,112 12,866 $ TRUE TRUE TRUE The Home Depot, Inc. Consolidated Balance Sheets (amounts in millions, except per share data) Feb. 03, 2019 Feb. 02, 2020lan. 31, 2021 % of Total Assets Feb. 03, 2019 Feb. 02, 2020lan. 31, 2021 6 Feb. 03, 2019 Feb. 02, 2020 Jan. 31, 2021 2020 vs 2019 2021 vs 2020 2020 vs 2019 2021 vs 2020 25 $ Increase (Decrease) % Increase (Decrease) 26 Feb. 03, 2019 Feb. 02, 2020 Jan. 31, 2021 2020 vs 2019 2021 vs 2020 2020 vs 2019 2021 vs 2020 27 Assets 28 Cash and cash equivalents $ 1,778 $ 2,133 $ 7,895 29 Accounts receivable, net 1,936 2,106 2,992 30 Inventories 13,925 14,531 16,627 31 Other current assets 890 1,040 963 32 Total current assets 18,529 19,810 28,477 33 Property and equipment, cost 34 Land 8,363 8,390 8,543 35 Buildings and Other 22,116 22,804 25,139 36 Furniture, Fixtures and Equipment 12,460 13,666 15,119 37 Less accumulated depreciation (20,564) (22,090) (24,096) 38 Property and equipment, net 22,375 22,770 24,705 39 Intangibles and other assets 3,099 8,656 17,399 40 Total assets $ 44,003 $ 51,236 $ 70,581 41 TRUE TRUE TRUE 42 Current liabilities: 43 Accounts payable $ 7,755 $ 7,787 $ 11,606 44 Other current payables & accrued expenses 7,179 8,472 8,737 45 Deferred revenue 1,782 2,116 2,823 46 Total current liabilities 16,716 18,375 23,166 47 LT debt, excluding current portion 26,807 28,670 35,822 48 Other long-term liabilities 2,358 7,307 8,294 49 Total liabilities 45,881 54,352 67,282 50 Stockholders' equity: 51 Common stock 89 89 89 52 Paid-in capital 10,578 11,001 11,540 53 Retained earnings + AOCL 45,651 50,990 57,463 54 Treasury stock (58,196) (65,196) (65,793) 55 Total stockholders' equity (1,878) (3,116) 3,299 56 Total liabilities and stockholders' equit $ 44,003 $ 51,236 $ 70,581 57 TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE Multiple Choice Ratio Analysis Questions: show your answer by green highlight example: More Less About same 1. Which year had the highest gross margin total dollars? 2019 2020 2021 2. Is the trend in gross profit margin %... improving declining steady 3. Look at $ increase in gross profit 2021 vs 2020 and compare to increase in net income 2021 vs 2020. What was main factor why NIS increase so much lower than GP S increase? cost of sales SG&A tax expense Multiple Choice Ratio Analysis Questions: 19 4. The total $ balance of Inventory has increased every year. As a % of Total Assets, what's happening with trend in inventory? increasing decreasing about same 5. As a % of total assets is the company's investment in Property & Equipment increasing decreasing about same 6. Look at the increases in Total Liabilities both periods compared to the S changes in Total Equity both periods. What do you think happened to the company's debt to equity ratio? improved deteriorated about same Yes No 7a. Are the % of Total Assets the same for cells K40, L40, M40, K56, L56, M56 all the same? 7b. Do you understand why, makes sense to you? Yes No