Question
Mike is trying to value the Tools Limited. To easily see how a change in one or more of his assumptions affects the estimated value
Mike is trying to value the Tools Limited. To easily see how a change in one or more of his assumptions affects the estimated value of the stock, he is using a spreadsheet model. The model has projections for the next four years based on the following assumptions.
- Sales will be $300 million in Year 1.
- Sales will grow at 15 percent in Years 2 and 3 and 10 percent in Year 4.
- Operating profits (EBIT) will be 17 percent of sales in each year.
- Interest expense will be $10 million per year.
- Income tax rate is 30 percent.
- Earnings retention ratio would stay at 0.60.
- The per-share dividend growth rate will be constant from Year 4 forward, and this final growth rate will be 200 basis points less than the growth rate from Year 3 to Year 4.
The company has 10 million shares outstanding. Trey has estimated the required return on Resources stock to be 13 percent.
A. Estimate the value of the stock at the end of Year 4 based on the above assumptions.
B. Estimate the current value of the stock using the above assumptions.
C. Mike is wondering how a change in the projected sales growth rate would affect the estimated value. Estimate the current value of the stock if the sales growth rate in Year 3 is 10 percent instead of 15 percent.
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