Details of this Paper

I have attached a copy of an excel spreadsheet and...

Description

Solution


Question

I have attached a copy of an excel spreadsheet and would like assistance on figuring out the 2 questions. For the first part of the question I came up with the following: 1) Dividend Growth Rate Year 0 $1.45 Year 1 $1.86 28% Year 2 $2.06 11% Year 3 $2.18 6% Required Return 11% Terminal Value $43.68 Year 0 1 2 3 Growth Rate 28% 11% 6% Dividend $1.45 $1.86 $2.06 $2.18 Terminal Value $43.68 Total cash Flow $- $1.86 $45.74 PV of Cash Flows $- $1.67 $37.12 Stock price $38.79 I am not sure if this is correct so would like some assistance with the calculations.

 

Paper#4200 | Written in 18-Jul-2015

Price : $25
SiteLock