Using the financial information presented in Exhibit 13.1; calculate the following ratios for fiscal 2020 for The Home Depot: Note: Do not round your intermediate calculations and round your answers to 2 decimal places. Round your percentage answers to 2 decimal places. (i.e., 0.1234 should be entered as 12.34). For the Return on equity ratio use the ending stockholders' equity balance for fiscal year 2020, not an average balance, due to negative stockholders' equity for fiscal year 2019. Return on equity ratio Return on assets ratio Total asset turnover ratio Inventory turnover ratio Current ratio Quick ratio Cash coverage ratio Debt-to-equity ratio % % THE HOME DEPOT, INCORPORATED CONSOLIDATED STATEMENTS OF EARNINGS in millions, except per share data Fiscal 2020 Fiscal 2019 Fiscal 2018 Operating Expenses: Net sales Cost of sales Gross profit Selling, general and administrative $ 132,110 $ 110,225 $ 108,203 87,257 72,653 71,043 44,853 37,572 37,160 24,447 19,740 19,513 Depreciation and amortization 2,128 1,989 1,870 Impairment loss 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) (93) Interest expense 1,347 1,201 1,051 Other 16 Interest and other, net Earnings before provision for income taxes Provision for income taxes Net Earnings Basic weighted average common shares Basic earnings per share Diluted weighted average common shares Diluted earnings per share 1,300 1,128 974 16,978 14,715 14,556 4,112 3,473 3,435 $ 12,866 1,074 $ 11.98 1,078 $ 11.94 $ 11,242 1,093 $ 10.29 1,097 $ 10.25 $ 11,121 1,137 $ 9.78 1,143 $ 9.73 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 THE HOME DEPOT, INCORPORATED CONSOLIDATED BALANCE SHEETS End of Fiscal 2020 End of Fiscal 2019 $ 7,895 2,992 16,627 $ 2,133 2,106 14,531 963 1,040 28,477 19,810 24,705 22,770 5,962 5,595 7,126 2,254 4,311 807 $ 70,581 $ 51,236 Liabilities and Stockholders' Equity Current liabilities: Short-term debt $ $ 974 Accounts payable 11,606 Accrued salaries and related expenses Sales taxes payable 2,463 7,787 1,494 774 605 Deferred revenue 2,823 2,116 Income taxes payablev 193 55 Current installments of long-term debt 1,416 1,839 Current operating lease liabilities 828 Other accrued expenses 3,063 828 2,677 Total current liabilities 23,166 18,375 Long-term debt, excluding current installments 35,822 28,670 Long-term operating lease liabilities 5,356 5,066 Deferred income taxes 1,131 706 Other long-term liabilities 1,807 1,535 Total liabilities 67,282 54,352 Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,789 shares at end of Fiscal 2020, and 1,786 shares at end of Fiscal 2019; outstanding: 1,077 shares at end of Fiscal 2020 and end of Fiscal 2019 89 89 Paid-in capital 11,540 Retained earnings 58,134 11,001 51,729 Accumulated other comprehensive loss (671) (739) Treasury stock, at cost, 712 shares at end of Fiscal 2020, and 709 shares at end of Fiscal 2019 (65,793) (65,196) Total stockholders' equity (deficit) 3,299 (3,116) Total liabilities and stockholders' equity $ 70,581 $ 51,236 in millions CONSOLIDATED STATEMENTS OF CASH FLOWS Fiscal 2020 Fiscal 2019 Fiscal 2018 $ 12,866 $ 11,242 $ 11,121 Cash Flows from Operating Activities: Net earnings Reconciliation of net earnings to net cash provided by operating activities: Depreciation and amortization Stock-based compensation expense Impairment loss Changes in receivables, net Changes in merchandise inventories 2,519 310 2,296 2,152 251 282 247 (465) (1,657) (170) 33 (593) (1,244) Changes in other current assets 43 (135) (257) Changes in accounts payable and accrued expenses 5,118 32 Changes in deferred revenue 702 334 Changes in income taxes payable (149) 44 870 80 (42) Changes in deferred income taxes (569) 202 26 Other operating activities 121 184 (103) Net cash provided by operating activities 18,839 13,687 13,165 Cash Flows from Investing Activities: Capital expenditures (2,463) (2,678) (2,442) Payments for businesses acquired, net (7,780) (21) Other investing activities 73 25 Net cash used in investing activities (10,170) (2,653) 47 (2,416) Cash Flows from Financing Activities: Repayments of short-term debt, net (974) (365) (220) Proceeds from long-term debt, net of discount and premiums 7,933 3,420 3,466 Repayments of long-term debt (2,872) (1,070) (1,209) Repurchases of common stock Proceeds from sales of common stock Cash dividends (791) 326 (6,451) (6,965) (9,963) 280 236 (5,958) (4,704) Other financing activities Net cash used in financing activities Change in cash and cash equivalents Effect of exchange rate changes on cash and cash equivalents Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year (154) (2,983) (140) (10,798) (153) (12,547) 5,686 236 (1,798) 76 2,133 $ 7,895 1,778 $ 2,133 Supplemental Disclosures: Cash paid for income taxes $ 4,654 Cash paid for interest, net of interest capitalized Non-cash capital expenditures 1,241 274 $ 3,220 1,112 136 (19) 3,595 $ 1,778 $ 3,774 1,035 248 119 Source: The Home Depot, Incorporated