HOME DEPOT (HD) 5 Year - Consolidated Financial Statements (all values in millions) 1/31/17 1/31/18 1/31/19 1/31/20 1/31/21 $ 2,538.0 $ 3,595.0 $ 1,778.0 $ 2,133.0 $ 7,895.0 Balance Sheet Assets Cash Short-Term Investments Accounts Receivable Inventory Other Current Assets Current Assets Net Property Plant & Equipment Intangibles Other Long-Term Assets Total Long-Term Assets Total Assets 2,029.0 995.0 980.0 1,070.0 12,549.0 12,748.0 13,925.0 14,531,0 608.0 1,595.0 1,846.0 2,076.0 17,724.0 18,933.0 18,529.0 19,810.0 21,914.0 22,075.0 22,375.0 28,365.0 2,093.0 2,275.0 2,252.0 2,254.0 1,235.0 1,246.0 847.0 807.0 25.242.0 25,596.0 25,474.0 31,426.0 $ 42,966.0 $ 44,529.0 $ 44,003.0 $ 51,236.0 1,563.0 16,627.0 2,392.0 28,477.0 30,667.0 10,738.0 699.0 42,104.0 $ 70,581.0 $ Liabilities Accounts Payable Accrued Expenses Notes Payable Current Portion of Long-Term Debt Other Current Liabilities Current Liabilities Long-Term Debt Other Long-Term Liabilities Total Liabilities 7,000.0 $ 3,679.0 710.0 542.0 2,202.0 14,133.0 22,349.0 2,151.0 38,633.0 7,244.0 $ 3,810.0 1,559.0 1,202.0 2,379.0 16,194.0 24,267.0 2,614.0 43,075.0 7,755.0 $ 4,1170 1,339.0 1,056.0 2,449.0 16,716.0 26,807.0 2,358.0 45,881.0 7,787,0 $ 11,606.0 4,171.0 5,526.0 974.0 2,667.0 2.244.0 2,776.0 3,790.0 18,375.0 23,166.0 33,736.0 41,178.0 2,241.0 2,938.0 54,352.0 67,282.0 Equity Minority interest Preferred Stock Common Stock Retained Earnings Total Common Equity Total Stockholders' Equity (30,319.0) 34,652.0 4,333.0 4,333.0 (37,915.0) 39,369.0 1,454.0 1,454.0 (47,529.0) 45,651.0 (1,878.0) (1,878.0) (54,106.0) 50,990.0 (3,116.0) (3,116.0) (54,164.0) 57,463.0 3,299.0 3,299.0 Total Liab. & Equity $ 42,966.0 $ 44,529.0 $ 44,003.0 $ 51,236.0 $ 70,581.0 Common Shares Outstanding Stock Price (per share) 1,203.000 137.58 1,158.000 200.90 1,105.000 183.53 1,077.000 228.10 $ 1,077.000 270.82 $ $ $ $ Income Statement Sales Costs of Goods Sold Depreciation and Amortization Selling, General & Administrative Expense Earnings Before Interest and Taxes (EBIT) Interest EBT (Before Unusual Items) Unusual Expenses (Profits) Earnings Before Taxes (EBT) Taxes Net Income Common Dividends Other Dividends & Distributions Addition to Retained Earnings $ 94,595.0 $ 100,904.0 $ 108,203.0 $ 110,225.0 $ 132,110.0 62,282.0 66,548.0 70,837.0 72,419.0 86,960.0 1,754.0 1,811.0 2,076.0 2,223.0 2,425.0 17,095.0 17,694.0 19,513.0 19,740.0 22,099.0 13,464.0 14,851.0 15,777.0 15,843.0 20,626.0 973.0 1,057.0 1,051.0 1,201.0 1,347.0 12,491.0 13,794.0 14,726.0 14,642.0 19,279.0 96.0 170.0 (73.0) 2,301.0 12,491.0 13,698.0 14,556.0 14,715.0 16,978.0 4,534.0 5,068.0 3,435.0 3,473.0 4,112.0 $ 7,957.0 $ 8,630,0 $ 11,121,0 $ 11,242.0 $ 12,866.0 3,4040 4,212,0 4,704.0 5,958.0 6,4510 (24.0) (299.0) 135.0 (55.0) (58.0) $ 4,577.0 $ 4,717,0 $ 6,282.0 $ 5,339.0 $ 6,473.0 QUESTION 16 Using the outcomes for 1/31/2021, what is HD's market debt ratio? [NOTE: Provide your answer in percentage format with no percentage sign and one decimal place, e.g. 13.4 for 13.4%. Negative values should be expressed with a negative sign in front of the value, e.g.-13.4] QUESTION 17 Using the outcomes for 1/31/2020, what is HD's liabilities to asset ratio? [NOTE: Provide your answer percentage format with no percentage sign and one decimal place, e.g. 13,4 for 13.4%. Negative values should be expressed with a negative sign in front of the value, e.g.-13.4] QUESTION 18 Using the outcomes for 1/31/2019, what is HD's time interest earned ratio? [NOTE: Provide your answer number format with one decimal place, e.g. 13.4. Negative values should be expressed with a negative sign in front of the value, e.g.-13.4] QUESTION 19 Using the outcomes for 1/31/2018, what is HD's price/earnings (PE) ratio? [NOTE: Provide your answer in number format with one decimal place, e.g. 13.4. Negative values should be expressed with a negative sign in front of the value, e.g.-13.4] QUESTION 20 Using the outcomes for the 1/31/2017, what is HD's market/book ratio? [NOTE: Provide your answer in number format with one decimal place, eg. 13.4. Negative values should be expressed with a negative sign in front of the value, e.g.-13.4] QUESTION 21 Using the outcomes for 1/31/2021, what is HD's price/sales ratio? [NOTE: Provide your answer in number format with one decimal place, e.g. 13.4. Negative values should be expressed with a negative sign in front of the value, e.g.-13.4]
