Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Casey Hyunh is trying to value the stock of Resources Limited. To easily see how a change in one or more of her assumptions
Casey Hyunh is trying to value the stock of Resources Limited. To easily see how a change in one or more of her assumptions affects the estimated value of the stock, she is using a spreadsheet model (Download and use the spreadsheet provided in Canvas). 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. Hyunh has estimated the required return on Resources' stock to be 13 percent. A. Based on the above assumptions, the spreadsheet shows the value of the stock at the end of Year 4 is estimated to be (Enter your answer as a number with two decimal places and no currency symbol. For example, if your answer is $89.1234, enter 89.12) 61.76 dollars. X 42.18 B. Based on the above assumptions, the spreadsheet shows the current value of the stock is estimated to be (Enter your answer as a number with two decimal places and no currency symbol. For example, if your answer is $89.1234, enter 89.12) dollars. C. Hyunh is wondering how a change in the projected sales growth rate would affect the estimated value. If the sales growth rate in Year 3 is 10 percent instead of 15 percent, the 39.73 spreadsheet shows the current value of the stock would be estimated to be dollars. (Enter your answer as a number with two decimal places and no currency symbol. For example, if your answer is $89.1234, enter 89.12)
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