Table of Contents THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS Fiscal Fiscal Fiscal in millions 2020 2019 2018 Cash Flows from Operating Activities: Net earnings S 12,866 $ 11,242 $ 11,121 Reconciliation of net earnings to net cash provided by operating activities: Depreciation and amortization Impairment loss 2.519 2.296 2,152 Stock-based compensation expense 310 251 282 - 247 Changes in receivables, net (465) (170) 33 Changes in merchandise inventories (1,657) (593) (1,244) Changes in other current assets 43 (135) (257) Changes in accounts payable and accrued expenses 5,118 32 870 Changes in deferred revenue 702 334 80 Changes in income taxes payable (149) 44 (42) Changes in deferred income taxes (569) 202 26 421 184 (103) 18,839 13,687 13,165 Other operating activities 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) (2,442) (7780) (21) 73 25 47 (10,170) (2.653) (2,416) Cash Flows from Financing Activities: Repayments of short-term debt, nel (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) (9,963) Proceeds from sales of common stock 326 280 Cash dividends (6,451) (5,958) 236 (4,704) Other financing activities Net cash used in financing activities (154) (2,983) (140) (10,798) (153) (12.547) Change in cash and cash equivalents Effect of exchange rate changes on cash and cash equivalents Cash and cash equivalents at beginning of year 5,686 236 (1,798) 76 119 (19) 2,133 1,778 3,595 Cash and cash equivalents at end of year Supplemental Disclosures: Cash paid for income taxes 7,895 $ 2,133 $ 1,778 Cash paid for interest, nel of interest capitalized Non-cash capital expenditures Fiscal 2020 and fiscal 2019 include 52 weeks. Fiscal 2018 includes 53 weeks See accompanying notes to consolidated financial statements 4,654 $ 1.241 3,220 $ 3,774 1,112 1,035 274 136 248 fx Home Depot -- Fiscal 2020 Statement of Cash Flows Indicators Use the information in Home Depot's Fiscal 2020 Consolidated Statements of Cash Flows to calculate the three Statement of Cash Flows Indicators. In the left-hand column enter the names of the items that will be used in the calculation. Enter the financial statement dollar amounts in millions of dollars as shown on the Consolidated Statements of Cash Flows. Round the decimal results to 2 decimal places. xx.xx Pg. 11 Fix xx.xx Cell Formats CAUTION Do NOT do a Cut operation on any cell in the project. (Quality of Income Rio) Cash Flow to Net Income Ratio $XXX.XXX (Cash Flow A 2020 2019 to 1 1.22 XX.XX $100x100x Cells (Quality of Income Ratio) Cash Flow to Net Income Ratio (Cash Flow Adequacy Ratio) Cash Flow to Capital Expenditures Ratio $xxxx.XXXX 2020 2019 to 1 1.22 XX.XX $xxxxxxx $xxxx.xxxXx to 1 5.11 Net Cash Paid to Purchase PP&E XX.XX Sxxxxxxxx Free Cash Flow Sxxxxxxxxx Net Cash Paid to Purchase PP&E 0 Free Cash Flow $5,051 Tip: "Net Cash Paid to Purchase PP&E" is equal to "Capital Expenditures this a positive number)