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 11 Using the outcomes for 1 31 2020, what is HD's quick 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 1 1 QUESTION 12 Using the outcomes for 1 31 2020, what is HD's inventory turnover 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 5 1 QUESTION 13 Using the outcomes for 1 31 2019, how many days does HD hold its inventory, on average (days sales in inventory) 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 14 Using the outcomes for 1 31 2018, what is HD's 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 1 0 QUESTION 15 Using the outcomes for 1 31 2017, what is HD's debt to equity 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

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 11 Using the outcomes for 1 31 2020, what is HD's quick 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  1 1 QUESTION 12 Using the outcomes for 1 31 2020, what is HD's inventory turnover   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  5 1 QUESTION 13 Using the outcomes for 1 31 2019, how many days does HD hold its inventory, on average (days sales in inventory)   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 14 Using the outcomes for 1 31 2018, what is HD's 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  1 0 QUESTION 15 Using the outcomes for 1 31 2017, what is HD's debt to equity 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

Accepted Answer

The Answer is in the image, click to view ...

Question

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 $

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Intermediate Financial Management