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: High price Low price EPS Year 1 Year 2 $88.51 $101.69 70.23 84.05 6.568 .98 Year 3 $123.35 78.93 8.64 Year 4 $134.98 111.26 10.23 Earnings are projected to grow at 6.5 percent over the next year. What are the high and low PE ratios for each year? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) High PE Low PE Year 1 Year 2 Year 3 Year 4 What are the average high and low PE ratios over this period? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) High PE Low PE Average What is the high target stock price over the next year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) High target price $ What is the low target stock price over the next year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Low target price $

Answer 1

A 1 2 Year 1 3 Year 2 High PE 13.49 11.32 14.30 13.19 Low PE 10.71 9.36 9.14 10.88 4 Year 3 5 Year 4 6 13.08 10.02 7 Average 8 $142.51 9 High target price Benchmark PE ratio x EPS1 10 11 Low target price Benchmark PE ratio EPS1 $109.17

A 2 1 2 Year 1 3 Year 2 High PE =88.51/6.56 =101.69/8.98 =123.55/8.64 |=134.98/10.23 C Low PE =70.23/6.56 =84.05/8.98 =78.93/8.64 =111.26/10.23 4 Year 3 5 Year 4 7 Average =AVERAGE(B2:B5) =AVERAGE(C2:C5) 8 =(13.08*(10.23*(1+6.5%))) 9 High target price Benchmark PE ratio ~ EPS1 10 | 11 Low target price Benchmark PE ratio ~ EPS1 =(10.02*(10.23*(1+6.5%)))

*Please rate thumbs up