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 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 THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS 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, 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 (deficit) Total liabilities and stockholders' equity See accompanying notes to consolidated financial statements. January 31, 2021 February 2, 2020 7,895 $ 2,133 2,992 2,106 16,627 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 $ 974 11,606 7,787 2,463 1,494 774 2,823 605 2,116 193 55 1,416 1,839 828 828 3,063 2,677 23,166 18,375 35,822 28,670 5,356 5,066 1,131 706 1,807 1,535 67,282 54,352 89 89 11,540 11,001 58,134 51,729 (671) (739) (65,793) (65,196) 3,299 (3.116) 70,581 $ 51,236 Refer to the 10-K for The Home Depot. Required: 1. What does the company report for the following accounts for the most current fiscal year: Enter your answer in millions. If an amount is zero, enter "0". a. Cash b. Short-term investments (or marketable securities) c. Accounts receivable d. Inventory e. Other current assets f. Accounts payable g. Other current liabilities h. Cash flow from operations 00000000 2. The company projects the following to occur in the next fiscal year: . Accounts payable will increase by 3%. Other current liabilities are expected to grow by 2%. Cash flow from operations is expected to increase by 7%. Assume all other items remain unchanged from the prior year. Provide the next year's forecasted balances for the following accounts and cash flow from operations. Round your answer to the nearest million. If an amount is zero, enter "0". a. Cash b. Short-term investments (or marketable securities) c. Accounts receivable d. Inventory e. Other current assets f. Accounts payable g. Other current liabilities h. Cash flow from operations 3. Compute the forecasted current ratio for the next fiscal year. Round your answer to two decimal places. 4. Compute the forecasted quick ratio for the next fiscal year. Round your answer to two decimal places. 5. Compute the forecasted cash ratio for the next fiscal year. Round your answer to two decimal places. 6. Compute the forecasted operating cash flow ratio for the next fiscal year. Round your answer to two decimal places. in millions, 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 Basic weighted average common shares THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Fiscal Fiscal 2020 2019 2018 132,110 $ 110,225 $ 108,203 87,257 72,653 71,043 44,853 37,572 37,160 24,447 19,740 19,513 2,128 1,989 1,870 247 26,575 21,729 21,630 18,278 15,843 15,530 (47) (73) (93) 1,347 1,201 1,051 16 1,300 1,128 974 16,978 14,715 14,556 4,112 3,473 3,435 12,866 $ 11,242 $ 11,121 1,074 1,093 1,137 Basic eamings per share 11.98 $ 10.29 $ 9.78 Diluted weighted average common shares 1,078 1,097 1,143 Diluted earnings per share $ 11.94 $ 10.25 $ 9.73 Fiscal 2020 and fiscal 2019 include 52 weeks. Fiscal 2018 includes 53 weeks See accompanying notes to consolidated financial statements millions Common Stock: THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY Balance at beginning of year Shares issued under employee stock plans Balance at end of year Paid-in Capital: Balance at beginning of year Shares issued under employee stock plans Stock-based compensation expense Balance at end of year Retained Earnings: Balance at beginning of year Cumulative effect of accounting changes Net eamings Cash dividends Other Balance at end of year Accumulated Other Comprehensive Income (Loss): Fiscal 2020 $ 89 $ 89 Fiscal 2019 Fiscal 2018 89 $ 89 89 89 11,001 10,578 10,192 229 172 104 310 251 282 11,540 11,001 10,578 51,729 46,423 39,935 26 75 12,866 11,242 11,121 (6,451) (5,958) (4.704) (10) (4) (4) 58,134 51,729 46,423 Balance at beginning of year (739) (772) (566) Cumulative effect of accounting changes (31) Foreign currency translation adjustments, net of tax 60 53 (267) Cash flow hedges, net of tax 8 8 53 Other, net of tax Balance at end of year Treasury Stock: Balance at beginning of year 3 8 (671) (739) (772) (65,196) (58,196) (48,196) Repurchases of common stock (597) (7,000) (10,000) Balance at end of year (65,793) (65,196) (58.196) Total stockholders' equity (deficit) $ 3,299 $ (3.116) $ (1,878) Fiscal 2020 and fiscal 2019 include 52 weeks Fiscal 2018 includes 53 weeks. See accompanying notes to consolidated financial statements THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS in millions Cash Flows from Operating Activities: Net eamings 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 Changes in other current assets Changes in accounts payable and accrued expenses Changes in deferred revenue Changes in income taxes payable Changes in deferred income taxes Other operating activities Fiscal 2020 Fiscal 2019 Fiscal 2018 12,866 $ 11,242 $ 11,121 2,519 2,296 2,152 310 251 282 247 (465) (170) 33 (1,657) (593) (1,244) 43 (135) (257) 5,118 32 870 702 334 80 (149) 44 (42) (569) 202 26 121 184 (103) 18,839 13,687 13,165 Net cash provided by operating activities Cash Flows from Investing Activities: Capital expenditures Payments for businesses acquired, net Other investing activities Net cash used in investing activities (2,463) (2,678) (7,780) (2,442) (21) 73 25 47 (10,170) (2,653) (2,416) Cash Flows from Financing Activities: Repayments of short-term debt, net (974) (365) (220) Proceeds from long-term debt, net of discounts and premiums 7,933 3,420 3,466 Repayments of long-term debt (2.872) (1,070) (1,209) Repurchases of common stock (791) (6,965) (0.963) Proceeds from sales of common stock 326 280 236 Cash dividends (6,451) (5.958) (4.704) Other financing activities (154) (140) (153) Net cash used in financing activities (2,983) (10.798) (12.547) Change in cash and cash equivalents 5,686 236 (1,798) Effect of exchange rate changes on cash and cash equivalents 76 119 (19) Cash and cash equivalents at beginning of year 2,133 1,778 3,595 Cash and cash equivalents at end of year Supplemental Disclosures: Cash paid for income taxes Cash paid for interest, net of interest capitalized Non-cash capital expenditures 7,895 $ 2,133 $ 1,778 4.654 $ 1,241 3.220 $ 1,112 3.774 1,035 274 136 248