Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Equity Asset Valuation

Authors: Jerald E. Pinto, Elaine Henry, Thomas R. Robinson, John D. Stowe, Abby Cohen

2nd Edition

470571439, 470571438, 9781118364123 , 978-0470571439

More Books

Students also viewed these Finance questions

Question

Decompose into partial fractions: (3x - 11) / (x2 + 2x - 3) .

Answered: 1 week ago