Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started