Using information attached Calculate the following Ratios for 2018 and 2019

Current Ratio, Quick Ratio, Return on Total Asset, Gross Profit Margin, Inventory Turnover, Profit Margin, Cash Flow to Sales Ratio, Return on Common Stockholders Equity (exclude treasury stock),Cash Debt Coverage, Times Interest Earned

3/18/2021 Inline XBRL Viewer THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 2 2020 February 3 2019 S in millions, except per share data Assets 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 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 2.252 847 44,003 S S $ 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 Long-term debt, excluding current instalments Long-term operating lease liabilities Deferred income taxes Other long-term liabilities Total liabilities 1.339 7.755 1,506 656 1.782 11 1,056 974 7.787 1,494 605 2,116 55 1.839 828 2.677 18375 28.670 5.066 706 1.535 54,352 2,611 16.716 26,807 491 1,867 45.881 Common stock, par value 50.05, authorized: 10,000 shares. Issued: 1,786 shares at February 2, 2020 and 1,782 shares at February 3, 2019: Outstanding: 1.077 shares at February 2, 2020 and 1,105 shares at February 3, 2019 Pald-in capital Retained earnings Accumulated other comprehensive loss Treasury stock. at cost 709 shares at February 2. 2020 and 677 shares at February 3, 2019 Total stockholders (deficit) equity Total liabilities and stockholders' equity ' 85 11.001 51.729 (739) (65.196) (3.116) 51.236 89 10,578 46,423 1772 (58,196) (1,878) 44,003 S $ Coxsaca facendo 32 https://www.sec.gov/x?doc=/Archives/edgar/data/0000354950/000035495020000015d10k02022020.htm#sC17026BDF5D15E2590BC9397F7905583 1/2 3/18/2021 Inline XBRL Viewer Table of Contents THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Fiscal 2019 Flacal 2017 2018 $ $ S 110.225 72,653 37,572 108,203 71,043 37,160 100,904 66.548 34.356 19.740 1.989 17.864 1.811 in millons, except per share data 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 eamings 19,513 1,870 247 21,630 15,530 21.729 15.843 19.675 14.681 (73) 1.201 (74) 1.057 1.128 14.715 3.473 11.242 (93) 1,051 16 974 14.556 3,435 11,121 583 13,698 5.068 8,630 $ $ S Basic weighted average common shares Basic earnings per share 1.093 10.29 $ 1,137 978 1.178 7.33 $ S Diluted weighted average common shares Diluted earnings per share 1,097 10.25 1,143 9.73 1.184 7.29 $ $ S https://www.sec.govix?doc=/Archives/edgar/data/0000354950/000035495020000015d10k0202 2020.htm#sC17026BDF5D15E2590BC9397F7905583 2/2