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 1 Using the outcomes for 1/31/2018, what is HD's net profit margin? [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 2 Using the outcomes for 1/31/2017, what is HD's operating profit margin? [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 3 Using the outcomes for 1/31/2021, what is HD's basic earning power? [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 4 Using the outcomes for 1/31/2020, what is HD's return on total assets (ROA)? [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 5 Using the outcomes for 1/31/2019, what is HD's return on common equity (ROE)? [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]
