Peruimplprem09

Peruimplprem09 - $1,268.23 $1,369.69 $1,479.27 Expected...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Implied Risk Premium Calculator Enter level of the index = 13317 Enter current dividend yield = 7.56% Enter expected growth rate in earnings fo 8.00% Enter current long term bond rate = 3.50% Enter risk premium = 4.00% Enter expected growth rate in the long te 3.50% Intrinsic Value Estimate 1 2 3 4 5 Expected Dividends = $1,087.31 $1,174.29 $1,268.23 $1,369.69 $1,479.27 Expected Terminal Value = $38,276.07 Present Value = $1,011.45 $1,016.15 $1,020.88 $1,025.63 $27,691.92 Intrinsic Value of Index $31,766.03 Implied Risk Premium Implied Risk Premium in current level of 9.38% (Go under Tools and choose Solver: See below) 1 2 3 4 5 Expected Dividends = $1,087.31 $1,174.29
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $1,268.23 $1,369.69 $1,479.27 Expected Terminal Value = $16,314.37 Present Value = $963.20 $921.52 $881.65 $843.50 $9,707.13 Intrinsic Value of Index $13,317.00 This is a picture of the solver option, with the inputs that I used (Do not try to enter numbers in it). Enter current level of index where you see 759.64. Buyback computation Page 2 Year Dividend Yield uybacks/Inde Yield 2001 1.37% 1.25% 2.62% 2002 1.81% 1.58% 3.39% 2003 1.61% 1.23% 2.84% 2004 1.57% 1.78% 3.35% 2005 1.79% 3.11% 4.90% 2006 1.77% 3.38% 5.15% 2007 1.89% 4.00% 5.89% Average yield between 2001-2007 = 4.02%...
View Full Document

Page1 / 2

Peruimplprem09 - $1,268.23 $1,369.69 $1,479.27 Expected...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online