Answer:
Current share price = $116.04
Explanation:
Note: See the attached file for the calculation of present values (PV) for year 1 to 3 dividends.
From the attached excel file, we have:
Previous year dividend in year 1 = Dividend just paid = $5
Total of dividends from year 1 to year 3 = $14.97289157241870
Year 3 dividend = $6.746163125
Therefore, we have:
Year 4 dividend = Year 3 dividend * (100% + Dividend growth rate in year 4) = $6.746163125 * (100% + 5.4%) = $7.11045593375
Share price at year 3 = Year 4 dividend / (Rate of return - Perpetual dividend growth rate) = $7.11045593375 / (10.6% - 5.4%) = $136.7395371875
PV of share price at year 3 = Price at year 3 / (100% + Required return)^Number of years = $136.7395371875 / (100% + 10.6%)^3 = $101.07150317234
Therefore, we have:
Current share price = Total of dividends from year 1 to year 3 + PV of share price at year 3 = $14.97289157241870 + $101.07150317234 = $116.04