Please answer the following questions in Excel: - Sully Corp. currently has earn
ID: 2790534 • Letter: P
Question
Please answer the following questions in Excel:
- Sully Corp. currently has earnings per share (EPS) of $2.53, and the benchmark PE multiple for appropriately-chosen comps is 19. Analysts expect Sully’s EPS to grow by 6 percent in the coming year.
a) What is your estimate of the current value of each share of Sully’s stock?
b) Assuming no multiple expansion (i.e., the benchmark multiple stays constant), what should the analysts’ target stock price be for one year from now?
c) Assuming that Sully does not pay a dividend, what is the rate of return on Sully’s stock that is implied by the estimates in the two questions above? What does this tell you about the relation between stock returns and EPS growth in multiples valuation models?
Explanation / Answer
a. PE multiple= Market Price per share /Earnings per share= 19 ie. MPS/2.53=19 So, current market price=19*2.53=48.07 b. 1 year from now, EPS=2.53*1.06=2.68 PE multiple remaining constant, MPS/2.68=19 So,Target Stock price ,1 year from now must be =2.68*19=50.92 or 50.92 c. Rate of return =(Increase in EPS+ Appreciation in stock price)% to original stock price ie. (2.68-2.53)+(50.92-48.07)= 3 $ 3. as a % of original stock price= 3/48.07= 6.24% is the holding period rate of return on the stock Rate of return on Sully’s stock that is implied by the estimates in the two questions above= 6.24% % inc. Inc.in EPS 2.68-2.53= 0.15 6% Inc.in stock price 50.92-48.07= 2.85 6% Rate of return on stock 6.24% Relation between stock returns and EPS growth in P/E multiples valuation model: As EPS increases,market price of the stock also increases,&stock return increases at almost same proportion, given constant P/E multiple