Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The 2016 and 2017 balance sheets for Home Depot are provided below. The companys sales for 2017 were $1.20billion, and EBITDA was 22% of sales.

The 2016 and 2017 balance sheets for Home Depot are provided below. The companys sales for 2017 were $1.20billion, and EBITDA was 22% of sales. Furthermore, depreciation amounted to 10% of net fixed assets of 2017, interest expense was $50 million, the corporate tax rate was 40%. Home Depot had 10 million shares outstanding in 2017, the 12/31/17 stock price was $75 per share, and its after-tax weighted average cost of capital was 10%. Based upon this information, answer the following questions. [25 points] Home Depot December 31 Balance Sheets (in thousands of dollars) 2017 2016 Assets Cash and cash equivalents $30,300 $24,212 Excess cash $3,360 $3,888 Accounts receivable $78,320 $65,328 Inventories $97,000 $90,132 Total current assets $208,980 $183,560 Net fixed assets $339,600 $300,000 Total assets $548,580 $483,560 Liabilities and equity Accounts payable $31,470 $27,000 Accruals $13,410 $10,526 Notes payable $40,200 $36,240 Total current liabilities $85,080 $73,766 Long-term debt $150,900 $126,150 Total liabilities $235,980 $199,916 Common stock $192,000 $180,000 Retained Earnings $120,600 $103,644 Total common equity $312,600 $283,644 Total liabilities and equity $548,580 $483,560 A.What was the companys 2017 net income? [5 points] B. How much cash was provided by operating activities in 2017? [5 points] C. What was the companys 2017 free cash flow? [5 points] D.What were the companys 2017 MVA and EVA? [5 points]. What was the companys 2017 days sales outstanding (DSO)? Use a 365-day year in your calculation. [5 points]

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

More Books

Students also viewed these Finance questions

Question

What is Ramayana, who is its creator, why was Ramayana written?

Answered: 1 week ago

Question

To solve by the graphical methods 2x +3y = 9 9x - 8y = 10

Answered: 1 week ago

Question

Why does sin 2x + cos2x =1 ?

Answered: 1 week ago

Question

Describe the patterns of business communication.

Answered: 1 week ago

Question

3. Provide two explanations for the effects of mass media

Answered: 1 week ago