use chart and show calculations for all ratios(for example, a number/ another number, a number-another number)
Debt to Assets Ratio (Debt Ratio): Total Liabilities Total Assets Debt to Equity Ratio: Total Liabilities Total Shareholders' Equity Number of times interest is earned (Interest Coverage): Earnings before interest and taxes expense Interest Expense Plant Assets to Long-term liabilities: Net Plant Assets (PP&E) Long-Term Liabilities Operating Cash Flows/Total Liabilities: Cash from Operations Total Liabilities Home Depot 2021 Annual Report reference page # and/or calculation comment Input Ratio Output #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Home Depot 2020 Annaar heport reference page # Input and/or calculation comment Ratio Output #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 11. Debt to Assets: 12. Debt to Equity Ratio*: Long-Term Debt (Solvency) Ratios Total Liabilities Total Assets Note: often Debt is used instead of Total Liabilities *Also calculated as Total Debt/Total Equity Total Liabilities Total Shareholders' Equity 13. Number of times interest is earned (Interest Coverage): Earnings before interest and taxes expense* Interest Expense *Must remove nonrecurring items (if any); often use Income from Continuing Operations. 14. Plant Assets to Long-term liabilities: 15. Operating Cash Flows/Total Liabilities: Net Plant Assets Long-term Liabilities Cash from Operations Total Liabilities 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, INC. CONSOLIDATED BALANCE SHEETS 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 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,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 Paid-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 See accompanying notes to consolidated financial statements. $ $ $ February 2, 2020 2,133 $ 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 51,236 $ 974 $ 7,787 1,494 605 2,116 55 1,839 828 2,677 18,375 28,670 5,066 706 1,535 54,352 89 11,001 51,729 (739) February 3, 2019 1,778 1,936 13,925 890 18,529 22,375 2,252 847 44,003 1,339 7,755 1,506 656 1,782 11 1,056 2,611 16,716 26,807 491 1,867 45,881 89 10,578 46,423 (772) (65,196) (58,196) (3,116) (1,878) 51,236 $ 44,003 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: THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS 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 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 $ 7,895 $ 2,992 16,627 963 28,477 24,705 5,962 7,126 4,311 $ 70,581 $ 11,606 2,463 774 2,823 193 1,416 828 3,063 23,166 35,822 5,356 1,131 1,807 67,282 89 11,540 58,134 (671) (65,793) 3,299 70,581 $ February 2, 2020 2,133 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 51,236 974 7,787 1,494 605 2,116 55 1,839 828 2,677 18,375 28,670 5,066 706 1,535 54,352 89 11,001 51,729 (739) (65,196) (3,116) 51,236 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, INC. CONSOLIDATED BALANCE SHEETS 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 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,792 shares at January 30, 2022 and 1,789 shares at January 31, 2021; outstanding: 1,035 shares at January 30, 2022 and 1,077 shares at January 31, 2021 Paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost, 757 shares at January 30, 2022 and 712 shares at January 31, 2021 Total stockholders' (deficit) equity Total liabilities and stockholders' equity See accompanying notes to consolidated financial statements. $ January 30, 2022 $ 2,343 $ 3,426 22,068 1,218 29,055 25,199 5,968 7,449 4,205 $ 71,876 $ 1,035 $ 13,462 2,426 848 3,596 158 2,447 830 3,891 28,693 36,604 5,353 909 2,013 73,572 90 12,132 67,580 (704) (80,794) (1,696) 71,876 $ January 31, 2021 7,895 2,992 16,627 963 28,477 24,705 62 7,126 4,311 70,581 11,606 2,463 774 2,823 193 1,416 828 3,063 23,166 35,822 5,356 1,131 1,807 67,282 89 11,540 58,134 (671) (65,793) 3,299 70,581 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS in millions 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 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 Net cash provided by operating activities Cash Flows from Investing Activities: Capital expenditures Payments for businesses acquired, net Proceeds from sales of property and equipment Other investing activities Net cash used in investing activities Cash Flows from Financing Activities: (Repayments of) proceeds from short-term debt, net Proceeds from long-term debt, net of discounts and premiums Repayments of long-term debt Repurchases of common stock Proceeds from sales of common stock Cash dividends 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 Supplemental Disclosures: Cash paid for income taxes Cash paid for interest, net of interest capitalized Non-cash capital expenditures Fiscal 2019 and fiscal 2017 include 52 weeks. Fiscal 2018 includes 53 weeks. See accompanying notes to consolidated financial statements. 37 $ $ $ Fiscal 2019 11,242 $ 2,296 251 (170) (593) (135) 68 334 44 202 184 13,723 (2,678) 37 (12) (2,653) (365) 3,420 (1,070) (6,965) 280 (5,958) (176) (10,834) 236 119 1,778 2,133 $ 3,220 $ 1,112 136 Fiscal 2018 11,121 $ 2,152 282 247 33 (1,244) (257) 743 80 (42) 26 (103) 13,038 (2,442) (21) 33 14 (2,416) (220) 3,466 (1,209) (9,963) 236 (4,704) (26) (12,420) (1,798) (19) 3,595 1,778 $ 3,774 $ 1,035 248 Fiscal 2017 8,630 2,062 273 139 (84) (10) 352 128 29 92 420 12,031 (1,897) (374) 47 (2,228) 850 2,991 (543) (8,000) 255 (4,212) (211) (8,870) 933 124 2,538 3,595 4,732 991 150 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS in millions 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 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 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 Cash Flows from Financing Activities: Repayments of short-term debt, net Proceeds from long-term debt, net of discounts and premiums Repayments of long-term debt Repurchases of common stock Proceeds from sales of common stock Cash dividends 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 Supplemental Disclosures: Cash paid for income taxes Cash paid for interest, net of interest capitalized Non-cash capital expenditures Fiscal 2020 and fiscal 2019 include 52 weeks. Fiscal 2018 includes 53 weeks. $ $ $ Fiscal 2020 12,866 $ 11,242 $ 2,519 310 (465) (1,657) 43 5,118 702 (149) (569) 121 18,839 (2,463) (7,780) 73 (10,170) (974) 7,933 (2,872) (791) 326 (6,451) (154) (2,983) 5,686 76 2,133 7,895 $ Fiscal 2019 4,654 $ 1,241 274 2,296 251 (170) (593) (135) 32 334 44 202 184 13,687 (2,678) 25 (2,653) (365) 3,420 (1,070) (6,965) 280 (5,958) (140) (10,798) 236 119 1,778 2,133 3,220 $ 1,112 136 Fiscal 2018 11,121 2,152 282 247 33 (1,244) (257) 870 80 (42) 26 (103) 13,165 (2,442) (21) 47 (2,416) (220) 3,466 (1,209) (9,963) 236 (4,704) (153) (12,547) (1,798) (19) 3,595 1,778 3,774 1,035 248 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS in millions 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 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 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 Cash Flows from Financing Activities: Proceeds from (repayments of) short-term debt, net Proceeds from long-term debt, net of discounts and premiums Repayments of long-term debt Repurchases of common stock Proceeds from sales of common stock Cash dividends 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 Supplemental Disclosures: Cash paid for income taxes Cash paid for interest, net of interest capitalized Non-cash capital expenditures See accompanying notes to consolidated financial statements. $ $ Fiscal 2021 16,433 $ 2,862 399 (435) (5,403) (330) 2,401 775 (51) (276) 196 16,571 (2,566) (421) 18 (2,969) 1,035 2,979 (1,532) (14,809) 337 (6,985) (145) (19,120) (5,518) (34) 7,895 2,343 $ 5,504 $ 1,269 421 Fiscal 2020 12,866 $ 2,519 310 (465) (1,657) 43 5,118 702 (149) (569) 121 18,839 (2,463) (7,780) 73 (10,170) (974) 7,933 (2,872) (791) 326 (6,451) (154) (2,983) 5,686 76 2,133 7,895 $ 4,654 $ 1,241 274 Fiscal 2019 11,242 2,296 251 (170) (593) (135) 32 334 44 202 184 13,687 (2,678) 25 (2,653) (365) 3,420 (1,070) (6,965) 280 (5,958) (140) (10,798) 236 119 1,778 2,133 3,220 1,112 136
