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
