can someone tell me how to do the blue part please thanks:)

can someone please explain how to ans all blue part to me thx:)

THE HOME DEPOT.INC CONSOLIDATED BALANCE SHEETS January 31, 2021 February 2 2020 In millions, except per share data Assets Current assets $75 Cash and cash equivalent Receivables.net Merchandise inventories $2.133 2.992 2.106 16.627 14.531 Other current assets 1,040 Total current 29.477 19.810 Net property and equipment 24.705 22.770 Operating sigh-of-use assets 5962 5.595 Goodwin 7.126 2,254 Others 807 Total assets 570 581 $51238 Liabilitles and Stockholders' Equity Current Short-term debt $ 3974 Accounts payable 11.606 7,787 2.463 1.494 Accrued salaries and related expenses Sales taxes payable 774 605 Deferred revenue 2.323 2.116 55 Income tax payable Current installments of long-term debe Current operating lease abilities 199 1416 828 1.839 828 Other accedere 3.063 2.677 Total current 23.166 18.375 Long-term debt, excluding current installments 35822 28,670 Long-term operating lease abilities 5.356 5.066 Deferred income tas 706 BOT 1.535 Other long-term labies Totslas 67280 54,352 Common stock, per value 50.05 authorized 10.000 shares 69 11.001 1,789 shares at January 31, 2021 and 1,785 shares February 2 2020 outstanding: 1.077 shares at January 31, 2021 and February 2.2020 89 Paid in capital 11.540 Retained earings sa 134 Accumulated other comprehensive less 671 Treasury stock, at cost, 712 shares at January 31, 2021 and 709 shares at February 2, 2020 65.73 Total stockholders' equity deficit) 3.290 51729 -739 65.196 3116 Tots and stockholderseguit 570 Ses $51.236 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Fiscal Fiscal in millions, except per share data Net als 2020 2019 2018 $ 132,110 5110 225 $ 108,209 87.257 72,653 71,043 44,853 37.572 37.160 Cost of sales Gross profit Operating expenses Selling general and administrative 19,740 19.513 24,447 2,128 1,989 1,870 Depreciation and amortization Impairmentos 247 Total operating expenses 26,575 21,729 21,630 Operating income 18.278 15.843 15,530 Interest and other income) expense: Interest and investment income -47 -73 Interest expense 1,347 1,201 1,051 Other 15 Interest and other, net 1,300 1,128 974 16,978 14,715 14,556 Earings before provision for income taxes Income tax expense 3,473 3,435 4,112 $11.242 Net earings $ 12.866 $ 11,121 Basic weighted average common shares 1,074 1,093 1.137 Die weighted average commentares 1,078 1,097 1.143 THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS January 31, 2021 February 2 2020 Increase (Decrease) Amount Percentage in millions, Assets $ Current assets Cash and cash equivalents Receivables, net Merchandise inventores Other current assets Total current assets 7.895 $ 2.992 16,627 963 28,477 2,133 2,106 14,531 1,040 19,810 Net property and equipment Operating lease night-of-use assets Goodwill 22.770 5,595 24.705 5,962 7,126 4,311 70,581 $ 2.254 807 Other assets Total assets $ 51,236 $ $ 974 + 7,787 1,494 605 Llabilities and Stockholders' Equity 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 11,606 2,463 774 2,823 193 1,416 828 3,063 23,166 2,116 55 1,839 828 2,677 18,375 Long-term debt, excluding current installments Long-term operating lease liabilities Deferred income taxes Other long-term liabilities Total liabilities 35,822 5,356 1,131 1,807 67.282 28,670 5,066 706 1.535 54,352 D E F C ZEUS 1999 774 605 2,116 B ALIULUS SU TWmses Sales taxes payable Deferred revenue Income taxes payable Current installments of long-term debt Current operating lease liabilities Other accrued expenses Total current liabilities 2,823 193 55 1.416 828 1,839 828 2,677 18,375 3,063 23,166 Long-term debt, excluding current installments Long-term operating lease liabilities Deferred Income taxes Other long-term liabilities Total liabilities 35,822 5,356 1,131 1,807 67.282 28,670 5,066 706 1,535 54,352 89 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, 2020 Paid-in capital Retained eamings Accumulated other comprehensive loss Treasury stock, at cost, 712 shares at January 31, 2021 and 709 shares at February 2, 2020 Total stockholders' equity (deficit) 89 11,540 58,134 (671) 11,001 51,729 (739) (65,793) 3,299 (65,196) (3,116) $ 70,581 $ 51,236 Total liabilities and stockholders' equity INTS For cell references, begin the formula with an equals sign (-), use the balance in this worksheet for your calculations, and press the enter key. C E F D 999 ZUN 774 605 B HUUUU SISETIU TERU UPOTSES Sales taxes payable Deferred revenue Income taxes payable Current installments of long-term debt Current operating lease liabilities Other accrued expenses Total current liabilities 2,116 55 2,823 193 1,416 828 1.839 828 2,677 18,375 3.063 23.166 Long-term debt, excluding current installments Long-term operating lease liabilities Deferred Income taxes Other long-term liabilities Total liabilities 35,822 5,356 1,131 1,807 67,282 28,670 5,066 706 1,535 54,352 89 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, 2020 Paid-in capital Retained eamings Accumulated other comprehensive loss Treasury stock, at cost, 712 shares at January 31, 2021 and 709 shares at February 2, 2020 Total stockholders' equity (deficit) 89 11,540 58,134 (671) 11,001 51,729 (739) (65,793) 3,299 (65,196) (3,116) $ 70,581 $ 51,236 Total liabilities and stockholders' equity INTS For cell references, begin the formula with an equals sign (-), use the balance in this worksheet for your calculations, and press the enter key, D THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS In millions, except per share data January 31, 2021 February 2, 2020 Assets $ Current assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets 7,896 $ 2,992 16.627 2,133 2,106 14,531 1.040 19,810 883 28,477 1 Net property and equipment Operating lease right-of-use assets Goodwill Other assets Total assets 24,705 5.252 7.126 4.311 70,581 5 22.770 5,595 2,254 1 807 1 $ 51.236 $ $ 974 7.787 1.494 805 Liabilities and Stockholders' Equity 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 11.606 2,463 774 2.823 193 1.410 829 3,083 23.168 2.110 55 1.839 328 2,877 18,375 Long-term debt, excluding current installments Long-term operating lase abilities 35 822 5.356 1.131 28.670 5.066 706 675 22 perang lease Tignous assets Goodwill 23 24 Other assets Total assets 25 5590 D BOX 7,126 4.311 70,581 $ 26 2.254 27 $ B07 51.236 28 29 30 $ 31 $ 32 Liabilities and Stockholders' Equity 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 labilities Other accrued expenses Total current liabilities 11,608 2.463 33 774 974 7.787 1494 605 2.116 55 1,839 34 2.823 35 36 37 193 1.416 828 3,043 23,166 828 38 2,877 18,375 39 40 35,822 41 Long-term debt, excluding current installments Long-term operating lease liabilities Deferred income taxes Other long-term liabilities Total liabilities 28,670 5,088 42 706 5,356 1,131 1,807 67.282 43 1,505 44 54 357 45 46 47 48 89 49 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, 2020 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 (defici) 89 11,001 51.729 (739) 11,540 58.134 (671) 50 51 52 (65,793) 53 (65190) 175) 2.299 54 1 55 70,581 5 51.238 56 Total liabilities and stockholders' equity 57 oft off? TUSHURIW quy WIR Total liabilities and stockholders' equity D E $ 70,581 $ 51 238 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS In millions, except per share data Net sales Cost of sales Gross profit Fiscal Fiscal 2019 $ 2018 Fiscal 2020 132.110 $ 87 257 44 853 110.255 72653 37 572 TOA 203 71.000 37.160 Operating expenses Seling, general and administrative Depreciation and amortization Impairment loss Total operating expenses 24,447 2.128 19,740 1.989 19,513 870 247 2160 26,575 21.729 Operating income 18.278 15.840 15,630 Interest and other (income) expense: Interest and investment income Interest expense (47) 1.347 (73) 1,201 (3) 1.051 16 Other 1300 1.120 Interest and other net 1 16.978 Earnings before provision for income taxes Income tax expense Net earnings 4,112 12 868 5 14.715 2,473 11225 14.550 2455 11,121 $ LORO 1,074 1,078 1.137 1,143 1097 Basic weighted average common shares Diluted weighted average common shares 3 D Perform a horizontal analysis on the balance sheets for 2021 and 2020. 4 Always use cell references and formulas where appropriate to receive full credit) E F G 5 6 7 THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS 8 9 10 11 in millions, 12 January 31, 2021 February 2 2020 13 Assets Increase Decrease) Amount Percentage 14 15 Current assets: Cash and cash equivalents Receivables, net Merchandise Inventones Other current assets Total current assets $ 16 27 7,895 $ 2,992 16,627 963 28,477 2,133 2,108 14,531 1,040 19,810 18 19 20 21 22 Net property and equipment Operating lease right-of-use assets Goodwill Other assets Total assets 23 24.705 5,962 7,126 4,311 70,581 $ 22.770 5,595 2,254 807 51.236 24 $ 25 26 27 28 $ $ 974 29 30 31 Liabilities and Stockholders' Equity 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 32 33 11,606 2,463 774 2,823 193 1,416 82B 3,063 23,188 7,787 1.494 605 2,116 55 1.839 828 2,077 18,375 34 35 36 37 38 28.870 39 5,056 40 Long-term debt, excluding current installments Long-term operating lase labilities Deferred income taxes Other Inform liabilities 35,822 5,356 1.131 1.007 AT 22 700 1,535 54,352 41 89 89 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, 2020 Pald-in capital Retained eamings Accumulated other comprehensive loss Treasury stock, at cost, 712 shares at January 31, 2021 and 709 shares at February 2, 2020 Total stockholders' equity (deficit) 11,540 58,134 (671) 11,001 51,729 (739) (65.793) 3,299 (65,196) (3.116) $ 70,581 S 51,238 Total liabilities and stockholders' equity