Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help E-H The Home Depot, Inc. Income Statement For Years Ended December 31 (All numbers in millions) Tax rate in 2020 was 24.2%. The

please help E-H image text in transcribed
image text in transcribed
image text in transcribed
The Home Depot, Inc. Income Statement For Years Ended December 31 (All numbers in millions) Tax rate in 2020 was 24.2%. The Home Depot, Inc. Balance Sheet December 31 (All numbers are in millions) Total stockholders' equity Total debt and stockholders' equity \begin{tabular}{rr} 2,300 & 3,300 \\ \hline$71,900 & $70,600 \\ \hline \end{tabular} Additional Information: 1. Home Depot has 1,030,000,000 shares of common stock outstanding. The market value per share is $285.00. 2. Home Depot's cost of money is 7%. 3. Cash dividends per share were expected to be $7.00. 4. The industry average for the current ratio is 1.60. 5. The industry average for the quick ratio is .91. 6. The industry average for the inventory holding period is 77 days. 7. The industry average for the receivables holding period is 8 days. 8. The industry average for the debt-equity ratio is .61. 9. The industry average for the times interest earned ratio is 10.4. 10. The industry average for the net profit margin is 026 . 11. The industry average for the total asset turnover is .85. 12. The industry average for the equity multiplier is 1.61. 13. The industry average for the return on equity is .036. Required: All calculations need to be in context of figures provided above. (8 pts.) a). Calculate the 2021 DuPont Identity and discuss what the DuPont Identity reveals. (6 pts.) b). Calculate the inventory-holding period and the receivables hoiding period for 2021. Discuss what these two metrics indicate. (6 pts.) c). Calculate the current ratio and the quick ratio for 2021. Discuss what these ratios indicate. (6 pts.) d). Calculate the debt to equity ratio and the times interest earned ratio for 2021. Discuss what these ratios indicate. (9 pts.) e). Calculate the free cash flow for 2021. What is the significance of free cash flow? (5 pts.) f). Calculate MVA for 2021. Explain what MVA indicates. (6 pts.) g). Calculate EVA for 2021. Explain what EVA indicates. (3 pts.) h). Calculate the earnings per share for 2021 . What does the earnings per share indicate? (3 pts.) i). Calculate the price earnings (P/E) ratio for 2021. What does this financial metric indicate? (3 pts.) j). Calculate the dividend yield ratio for 2021. What does this financial metric indicate? (6 pts.) k). Based on the calculations made above, assess the financial health of Home Depot

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Making Of Finance

Authors: Isabelle Chambost, Marc Lenglet, Yamina Tadjeddine

1st Edition

1138498572, 978-1138498570

More Books

Students also viewed these Finance questions

Question

27. Use the matrix in Prob. 22 to illustrate Corollary 11.4.8.3.

Answered: 1 week ago

Question

How does the attribution-value model explain anti-fat prejudice?

Answered: 1 week ago

Question

Example. Evaluate 5n+7 lim 7-00 3n-5

Answered: 1 week ago