Please Zoom in if needed, this was posted to the best of my ability. I appreciate the help in advance.

SLA Checklist ACFI - 101 Accounting Lab Use the following checklist for the Financial Analysis SLA. After you are "done" with your SLA, you should run through this list. If you need to go back and make changes, you should run through this list again after you make changes. Repeat this process until your SLA is truly complete & accurate. 1 The Excel file is properly named with the SLA #, your first initial, your last name. For example, my SLA 1 would be named "SLA 1 DAbelli". note: do not use the symbol # in your file name, it creates problems opening from Blackboard. Do rename as noted; otherwise file name too long & can't open when I download from Bikbd 2 Columns F thru M are 100% formula and/or linked formula; no manual entries or copy/paste of values not using formulas and linking means the work is not accurate 3 I answered all multiple choice ratio analysis questions for the IS and the BS not answering all questions means the assignment is incomplete 4 I have checked all my % columns for reasonableness, they make sense for the particular area you can catch your own errors by conducting a reasonableness review of your results 5 I have formatted all cells that contain figures properly and appropriately. All dollar amounts have proper comma placement, and dollar sign placement if applicable xx,xxx or $XX,XXX All figures presented without O's after decimal (no pennies if dollars; at least two decimals for all ratios and multiples xx.xx All percentages have proper percent sign placement xx.xx% The cell is the proper size to allow the entire number to show without modification by the instructor (fix any column widths before submission) 6 I certify this SLA file of the completed assignment is my work. I did not receive this completed file from anyone else. working collaborativley with other students is acceptable; passing of another person's work as your own is not 7 My worksheets are visually appealing, easy to read/understand, and in good form as required Another name for Horizontal and Vertical analysis is "Common-size" financials Note: any tutorial videos provided are NOT 100% answers, just guidance. After you complete, review your work! And use the Special Checklist for this SLA Newer Year-Older Year = $ Increase (Decrease) - Older Year = % Percentage Change Common-size Income Statement presented as a % Percentage of Net Sales Item Amount : Net Sales columnrow 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, 2020lan. 31, 2021 , , , $ 108,203 S 110,225 $ 132,110 71,043 72,653 87,257 37,160 37,572 44,853 Multiple Choice Ratio Analysis Questions: show your answer by green highlight example: More Less About same 1. Vhich gear had the highest gross margin total dollars? 2019 2020 2021 2. Is the trend in gross profit margin %... X improving declining steady Net sales Cost of sales Gross profit Operating expenses: SG&A Depreciation Total operating expenses Total income from operations Non-operating income (expense): Interest expense, net Earnings before provision for income Provision for income tax Net income 19,513 2,117 21,630 15,530 19,740 1,989 21,729 15,843 24,447 2,128 26,575 18,278 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 NI $ increase so much lover than GP $ increase? ost of sale SG&A tax expense 1974) (1,128) (1,300) 14,556 14,715 16,978 3,435 3,473 4,112 $ 11,121 $ 11,242 $ 12.866 TY 7X TAN The Home Depot, Inc. Consolidated Balance Sheets (amounts in millions, except per share data) As of: Horizontal Analysis $ Increase (Decrease) % Increase Decrease Feb. 03, 2019 Feb. 02, 2020 Jan. 31, 2021 2020 vs 2019 2021 vs 2020 2020 vs 2019 2021 vs 2020 Multiple Choice Ratio Analysis Questions: Vertical Analysis % of Total Assets Feb. 03, 2019 Feb. 02, 2020lan. 31, 2021 $ 4. The total balance of Inventory has increased every year. $ . As a % of Total Assets, what's happening with trend in invaincreasingdecreasingabout same 1,778 5 1,936 13,925 890 18,529 2,133 $ 2,106 14,531 1,040 19,810 7,895 2,992 16,627 963 28,477 5. As a % of total assets is the company's investment in Princreasingdecreasincabout same Assets Cash and cash equivalents Accounts receivable, net Inventories Other current assets Total current assets Property and equipment, cost , Land Buildings and Other Furniture, Fixtures and Equipment Less accumulated depreciation Property and equipment, net Intangibles and other assets Total assets 6. Look at the increases in Total Liabilities both periods compared to the changes in Total Equity both periods. Vhat do you think happened to the company's debt to equity ratio? improved eteriorate about same No 8,363 22,116 12,460 (20,564) 22,375 3,099 44,003 $ TAX 8,390 22,804 13,666 (22,090) 22,770 8,656 51,236 $ TAYU 8,543 25,139 15,119 (24,096) 24,705 17,399 70,581 TAYU 7a. Are the % of Total Assets the same for cells K40, L40, M40, K56,1 7b. Do you understand why, makes sense to you? Yes Yes No $ Current liabilities: Accounts payable $ Other current payables & accrued expense Deferred revenue Total current liabilities LT debt, excluding current portion Other long-term liabilities Total liabilities Stockholders' equity: Common stock Paid-in capital Retained earnings + AOCL Treasury stock Total stockholders' equity Total liabilities and stockholders' equity $ 7,755 S 7,179 1,782 16,716 26,807 2.358 45,881 7,787 5 8,472 2,116 18,375 28,670 7,307 54,352 11,606 8,737 2,823 23,166 35,822 8,294 67,282 89 10,578 45,651 (58,196) (1,878) 44,003 $ 89 11,001 50,990 (65,196) (3,116) 51,236 $ 89 11,540 57,463 (65,793) 3,299 70,581 Jan. 31, 2021 Feb. 02, 2020 Feb. 03, 2019 $ 7,895 2,992 16,627 963 28,477 24,705 5,962 7,126 4,311 70,581 $ 2,133 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 51,236 $ 1,778 1,936 13,925 890 18,529 22,375 0 2,252 847 44,003 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets Net property and equipment Operating lease right-of-use assets Goodwill Other assets Total assets Current Liabilities: Short-term debt Accounts payable Accrued salaries and related expenses Sales taxes payable Deferred revenue Income taxes payable Current installments of long-term debt Current operating lease liabilities Other accrued expenses Total current liabilities Long-term debt, excluding current installments Long-term operating lease liabilities Deferred income taxes Other long-term liabilities Total liabilities Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,789 shares at January 31, 2021 and 1,786 shares at February 2, 2020; outstanding: 1,077 shares at January 31, 2021 and February 2, Paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost, 712 shares at January 31, 2021 and 709 shares at February 2, 2020 Total stockholders' equity Total liabilities and stockholders' equity 0 11,606 2,463 774 2,823 193 1,416 828 3,063 23,166 35,822 5,356 1,131 1,807 67,282 89 974 7,787 1,494 605 2,116 55 1,839 828 2,677 18,375 28,670 5,066 706 1,535 54,352 89 1,339 7,755 1,506 656 1,782 11 1,056 0 2,611 16,716 26,807 0 491 1,867 45,881 89 11,540 58,134 (671) (65,793) 11,001 51,729 (739) (65,196) 10,578 46,423 (772) (58,196) 3,299 $ 70,581 (3,116) $ 51,236 (1,878) $ 44,003 TRUE TRUE Common Stock, shares outstanding (in shares) Common Stock, authorized (in shares) Common Stock, par value in dollars per share) 1,077 10,000 $ 0.05 1,077 10,000 $ 0.05 12 Months Ended Jan. 31, 2021 Feb. 02, 2020 Feb. 03, 2019 $ 132,110 87,257 44,853 $ 110,225 72,653 37,572 $ 108,203 71,043 37,160 Consolidated Statements of Earnings- USD ($) shares in Millions, $ in Millions Income Statement [Abstract] Net sales Cost of sales Gross profit Operating expenses: Selling, general and administrative Depreciation and amortization Impairment loss Total operating expenses Operating income Interest and other income) expense: Interest and investment income Interest expense Other Interest and other, net Earnings before provision for income taxes Provision for income taxes Net earnings Basic weighted average common shares 24,447 2,128 0 26,575 18,278 19,740 1,989 0 21,729 15,843 19,513 1,870 247 21,630 15,530 (47) 1,347 0 1,300 16,978 (73) 1,201 0 (93) 1,051 16 974 14,556 1,128 14,715 4,112 $ 12,866 1,074 3,473 $ 11,242 1,093 3,435 $ 11,121 1,137 $ 11.98 1,078 $ 10.29 1,097 $ 9.78 1,143 Basic earnings per share Diluted weighted average common shares Diluted earnings per share $ 11.94 $ 10.25 $ 9.73 - Feb. 02, 2020 Feb. 03, 2019 $44,860 22,090 $ 42,939 20,564 22,770 22,375 8,390 8,363 Property and Leases (Net Property and Equipment) (Details) - USD ($) $ Jan. 31, 2021 in Millions Property, plant and Equipment [Line Items] Property and equipment, at cost $ 48,801 Less accumulated depreciation and 24,096 finance lease amortization Net property and equipment 24,705 Land Property, Plant and Equipment [Line Items) Property and equipment, at cost 8,543 Buildings Property, Plant and Equipment [Line Items) Property and equipment, at cost 18,838 Furniture, fixtures, and equipment Property, Plant and Equipment [Line Items) Property and equipment, at cost 15,119 Leasehold improvements Property, plant and Equipment [Line Items) Finance lease, right-of-use assets 1,925 Construction in progress Property, Plant and Equipment [Line Items) Property and equipment, at cost 1,068 Finance leases Property, Plant and Equipment [Line Items) Finance lease, right-of-use assets $ 3,308 18,432 18,199 13,666 12,460 1,789 1,705 1,005 820 $1,578 $ 1,392 Cover Page - USD ($) $ in Billions 12 Months Ended Jan. 31, 2021 Mar. 05, 2021 Jul. 31, 2020 Cover (Abstract] Document Type Document Annual Report Document Period End Date Current Fiscal Year End Date Document Transition Report Entity File Number Entity Registrant Name Entity Incorporation, State or Country Code Entity Tax Identification Number Entity Address, Address Line One Entity Address, City or Town Entity Address, State or Province Entity Address, Postal Zip Code City Area Code Local Phone Number Title of 12(b) Security Trading Symbol Security Exchange Name Entity Well-known Seasoned Issuer Entity Voluntary Filers Entity Current Reporting Status Entity Interactive Data Current Entity Filer Category Entity Small Business Entity Emerging Growth Company ICFR Auditor Attestation Flag Entity Shell Company Entity Public Float Entity Common Stock, Shares Outstanding Documents Incorporated by Reference 10-K true Jan. 31, 2021 --01-31 false 1-8207 HOME DEPOT, INC. DE 95-3261426 2455 Paces Ferry Road Atlanta, GA 30339 770 433-8211 Common Stock, $0.05 Par Value Per Share HD NYSE Yes No Yes Yes Large Accelerated Filer false false true false $285.6 1,077,069,383 Portions of the registrant's proxy statement for the 2021 Annual Meeting of Shareholders are incorporated by reference in Part III of this Form 10-K to the extent described herein. Amendment Flag Document Fiscal Year Focus Document Fiscal Period Focus Entity Central Index Key false 2020 FY 0000354950 SLA Checklist ACFI - 101 Accounting Lab Use the following checklist for the Financial Analysis SLA. After you are "done" with your SLA, you should run through this list. If you need to go back and make changes, you should run through this list again after you make changes. Repeat this process until your SLA is truly complete & accurate. 1 The Excel file is properly named with the SLA #, your first initial, your last name. For example, my SLA 1 would be named "SLA 1 DAbelli". note: do not use the symbol # in your file name, it creates problems opening from Blackboard. Do rename as noted; otherwise file name too long & can't open when I download from Bikbd 2 Columns F thru M are 100% formula and/or linked formula; no manual entries or copy/paste of values not using formulas and linking means the work is not accurate 3 I answered all multiple choice ratio analysis questions for the IS and the BS not answering all questions means the assignment is incomplete 4 I have checked all my % columns for reasonableness, they make sense for the particular area you can catch your own errors by conducting a reasonableness review of your results 5 I have formatted all cells that contain figures properly and appropriately. All dollar amounts have proper comma placement, and dollar sign placement if applicable xx,xxx or $XX,XXX All figures presented without O's after decimal (no pennies if dollars; at least two decimals for all ratios and multiples xx.xx All percentages have proper percent sign placement xx.xx% The cell is the proper size to allow the entire number to show without modification by the instructor (fix any column widths before submission) 6 I certify this SLA file of the completed assignment is my work. I did not receive this completed file from anyone else. working collaborativley with other students is acceptable; passing of another person's work as your own is not 7 My worksheets are visually appealing, easy to read/understand, and in good form as required Another name for Horizontal and Vertical analysis is "Common-size" financials Note: any tutorial videos provided are NOT 100% answers, just guidance. After you complete, review your work! And use the Special Checklist for this SLA Newer Year-Older Year = $ Increase (Decrease) - Older Year = % Percentage Change Common-size Income Statement presented as a % Percentage of Net Sales Item Amount : Net Sales columnrow 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, 2020lan. 31, 2021 , , , $ 108,203 S 110,225 $ 132,110 71,043 72,653 87,257 37,160 37,572 44,853 Multiple Choice Ratio Analysis Questions: show your answer by green highlight example: More Less About same 1. Vhich gear had the highest gross margin total dollars? 2019 2020 2021 2. Is the trend in gross profit margin %... X improving declining steady Net sales Cost of sales Gross profit Operating expenses: SG&A Depreciation Total operating expenses Total income from operations Non-operating income (expense): Interest expense, net Earnings before provision for income Provision for income tax Net income 19,513 2,117 21,630 15,530 19,740 1,989 21,729 15,843 24,447 2,128 26,575 18,278 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 NI $ increase so much lover than GP $ increase? ost of sale SG&A tax expense 1974) (1,128) (1,300) 14,556 14,715 16,978 3,435 3,473 4,112 $ 11,121 $ 11,242 $ 12.866 TY 7X TAN The Home Depot, Inc. Consolidated Balance Sheets (amounts in millions, except per share data) As of: Horizontal Analysis $ Increase (Decrease) % Increase Decrease Feb. 03, 2019 Feb. 02, 2020 Jan. 31, 2021 2020 vs 2019 2021 vs 2020 2020 vs 2019 2021 vs 2020 Multiple Choice Ratio Analysis Questions: Vertical Analysis % of Total Assets Feb. 03, 2019 Feb. 02, 2020lan. 31, 2021 $ 4. The total balance of Inventory has increased every year. $ . As a % of Total Assets, what's happening with trend in invaincreasingdecreasingabout same 1,778 5 1,936 13,925 890 18,529 2,133 $ 2,106 14,531 1,040 19,810 7,895 2,992 16,627 963 28,477 5. As a % of total assets is the company's investment in Princreasingdecreasincabout same Assets Cash and cash equivalents Accounts receivable, net Inventories Other current assets Total current assets Property and equipment, cost , Land Buildings and Other Furniture, Fixtures and Equipment Less accumulated depreciation Property and equipment, net Intangibles and other assets Total assets 6. Look at the increases in Total Liabilities both periods compared to the changes in Total Equity both periods. Vhat do you think happened to the company's debt to equity ratio? improved eteriorate about same No 8,363 22,116 12,460 (20,564) 22,375 3,099 44,003 $ TAX 8,390 22,804 13,666 (22,090) 22,770 8,656 51,236 $ TAYU 8,543 25,139 15,119 (24,096) 24,705 17,399 70,581 TAYU 7a. Are the % of Total Assets the same for cells K40, L40, M40, K56,1 7b. Do you understand why, makes sense to you? Yes Yes No $ Current liabilities: Accounts payable $ Other current payables & accrued expense Deferred revenue Total current liabilities LT debt, excluding current portion Other long-term liabilities Total liabilities Stockholders' equity: Common stock Paid-in capital Retained earnings + AOCL Treasury stock Total stockholders' equity Total liabilities and stockholders' equity $ 7,755 S 7,179 1,782 16,716 26,807 2.358 45,881 7,787 5 8,472 2,116 18,375 28,670 7,307 54,352 11,606 8,737 2,823 23,166 35,822 8,294 67,282 89 10,578 45,651 (58,196) (1,878) 44,003 $ 89 11,001 50,990 (65,196) (3,116) 51,236 $ 89 11,540 57,463 (65,793) 3,299 70,581 Jan. 31, 2021 Feb. 02, 2020 Feb. 03, 2019 $ 7,895 2,992 16,627 963 28,477 24,705 5,962 7,126 4,311 70,581 $ 2,133 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 51,236 $ 1,778 1,936 13,925 890 18,529 22,375 0 2,252 847 44,003 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets Net property and equipment Operating lease right-of-use assets Goodwill Other assets Total assets Current Liabilities: Short-term debt Accounts payable Accrued salaries and related expenses Sales taxes payable Deferred revenue Income taxes payable Current installments of long-term debt Current operating lease liabilities Other accrued expenses Total current liabilities Long-term debt, excluding current installments Long-term operating lease liabilities Deferred income taxes Other long-term liabilities Total liabilities Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,789 shares at January 31, 2021 and 1,786 shares at February 2, 2020; outstanding: 1,077 shares at January 31, 2021 and February 2, Paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost, 712 shares at January 31, 2021 and 709 shares at February 2, 2020 Total stockholders' equity Total liabilities and stockholders' equity 0 11,606 2,463 774 2,823 193 1,416 828 3,063 23,166 35,822 5,356 1,131 1,807 67,282 89 974 7,787 1,494 605 2,116 55 1,839 828 2,677 18,375 28,670 5,066 706 1,535 54,352 89 1,339 7,755 1,506 656 1,782 11 1,056 0 2,611 16,716 26,807 0 491 1,867 45,881 89 11,540 58,134 (671) (65,793) 11,001 51,729 (739) (65,196) 10,578 46,423 (772) (58,196) 3,299 $ 70,581 (3,116) $ 51,236 (1,878) $ 44,003 TRUE TRUE Common Stock, shares outstanding (in shares) Common Stock, authorized (in shares) Common Stock, par value in dollars per share) 1,077 10,000 $ 0.05 1,077 10,000 $ 0.05 12 Months Ended Jan. 31, 2021 Feb. 02, 2020 Feb. 03, 2019 $ 132,110 87,257 44,853 $ 110,225 72,653 37,572 $ 108,203 71,043 37,160 Consolidated Statements of Earnings- USD ($) shares in Millions, $ in Millions Income Statement [Abstract] Net sales Cost of sales Gross profit Operating expenses: Selling, general and administrative Depreciation and amortization Impairment loss Total operating expenses Operating income Interest and other income) expense: Interest and investment income Interest expense Other Interest and other, net Earnings before provision for income taxes Provision for income taxes Net earnings Basic weighted average common shares 24,447 2,128 0 26,575 18,278 19,740 1,989 0 21,729 15,843 19,513 1,870 247 21,630 15,530 (47) 1,347 0 1,300 16,978 (73) 1,201 0 (93) 1,051 16 974 14,556 1,128 14,715 4,112 $ 12,866 1,074 3,473 $ 11,242 1,093 3,435 $ 11,121 1,137 $ 11.98 1,078 $ 10.29 1,097 $ 9.78 1,143 Basic earnings per share Diluted weighted average common shares Diluted earnings per share $ 11.94 $ 10.25 $ 9.73 - Feb. 02, 2020 Feb. 03, 2019 $44,860 22,090 $ 42,939 20,564 22,770 22,375 8,390 8,363 Property and Leases (Net Property and Equipment) (Details) - USD ($) $ Jan. 31, 2021 in Millions Property, plant and Equipment [Line Items] Property and equipment, at cost $ 48,801 Less accumulated depreciation and 24,096 finance lease amortization Net property and equipment 24,705 Land Property, Plant and Equipment [Line Items) Property and equipment, at cost 8,543 Buildings Property, Plant and Equipment [Line Items) Property and equipment, at cost 18,838 Furniture, fixtures, and equipment Property, Plant and Equipment [Line Items) Property and equipment, at cost 15,119 Leasehold improvements Property, plant and Equipment [Line Items) Finance lease, right-of-use assets 1,925 Construction in progress Property, Plant and Equipment [Line Items) Property and equipment, at cost 1,068 Finance leases Property, Plant and Equipment [Line Items) Finance lease, right-of-use assets $ 3,308 18,432 18,199 13,666 12,460 1,789 1,705 1,005 820 $1,578 $ 1,392 Cover Page - USD ($) $ in Billions 12 Months Ended Jan. 31, 2021 Mar. 05, 2021 Jul. 31, 2020 Cover (Abstract] Document Type Document Annual Report Document Period End Date Current Fiscal Year End Date Document Transition Report Entity File Number Entity Registrant Name Entity Incorporation, State or Country Code Entity Tax Identification Number Entity Address, Address Line One Entity Address, City or Town Entity Address, State or Province Entity Address, Postal Zip Code City Area Code Local Phone Number Title of 12(b) Security Trading Symbol Security Exchange Name Entity Well-known Seasoned Issuer Entity Voluntary Filers Entity Current Reporting Status Entity Interactive Data Current Entity Filer Category Entity Small Business Entity Emerging Growth Company ICFR Auditor Attestation Flag Entity Shell Company Entity Public Float Entity Common Stock, Shares Outstanding Documents Incorporated by Reference 10-K true Jan. 31, 2021 --01-31 false 1-8207 HOME DEPOT, INC. DE 95-3261426 2455 Paces Ferry Road Atlanta, GA 30339 770 433-8211 Common Stock, $0.05 Par Value Per Share HD NYSE Yes No Yes Yes Large Accelerated Filer false false true false $285.6 1,077,069,383 Portions of the registrant's proxy statement for the 2021 Annual Meeting of Shareholders are incorporated by reference in Part III of this Form 10-K to the extent described herein. Amendment Flag Document Fiscal Year Focus Document Fiscal Period Focus Entity Central Index Key false 2020 FY 0000354950