Question

If you look at stock prices over any year, you will find a high and low stock price for the year. Instead of a single benchmark PE ratio, we now have a high and low PE ratio for each year. We can use these ratios to calculate a high and a low stock price for the next year. Suppose we have the following information on a particular company: Year 1 Year 2 Year 3 Year 4 High price $ 27.43 $ 26.32 $ 30.42 $ 37.01 Low price 19.86 20.18 25.65 26.41 EPS 1.35 1.58 1.51 1.85 Earnings are projected to grow at 9 percent over the next year. a. What is your high target stock price over the next year

Answer 1

Answer:

High target price 38.8821

Low target price 29.6153

Explanation:

Calculation to determine your high and low target stock price over the next year

First step is to calculate the seperate yearly PE ratio for High and low price using this formula

PE ratio = Market price / EPS

EPS = B

Low = C

High = D

Let plug in the formula

Year 1

PE(High) C/B = $ 27.43/1.35

PE(High) C/B = 20.3185

PE(Low) D/B = 19.86/1.35

PE(Low) D/B = $14.7111

Year 2

PE(High) C/B = $ 26.32/1.58

PE(High) C/B = 16.6582

PE(Low) D/B = 20.18/1.58

PE(Low) D/B = 12.7722

Year 3

PE(High) C/B = $ 30.42/1.51

PE(High) C/B = 20.1457

PE(Low) D/B = 25.65/1.51

PE(Low) D/B = 16.9868

Year 4

PE(High) C/B = $ 37.01/1.85

PE(High) C/B = 20.0054

PE(Low) D/B = 26.41/1.85

PE(Low) D/B = 14.2757

Second step is to calculate the seperate Average PE for high and low price

Average PE

HIGH(20.3185+16.6582+20.1457+20.0054 / 4)

HIGH = 77.1278/4

HIGH=19.28195

LOW=($14.7111+12.7722+16.9868+14.2757/4)

LOW=58.7458/4

LOW=14.6865

(a) Now let calculate the high target stock price over the next year

Using this formula

High target price = Average PE(high) x EPS for next year

Let plug in the formula

High target price = 19.28195 x[(1+.09)×1.85]

High target price = 19.28195 x(1.09*1.85)

High target price = 19.28195*2.0165

High target price=38.8821

Therefore the high target stock price over the next year is 38.8821

(b) Calculation for the low target stock price over the next year

Using this formula

Low target price = Average PE(low) x EPS for next year

Let plug in the formula

Low target price = 14.6865 x [(1+.09)×1.85]

Low target price = 14.6865x(1.09*1.85)

Low target price = 14.6865×2.0165

Low target price = 29.6153

Therefore the low target stock price over the next year is 29.6153