kospiimplprem08

kospiimplprem08 - $91.40 $98.25 $104.64 Expected Terminal...

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 = 1825 Enter current dividend yield = 3.75% Enter expected growth rate in earnings fo 7.50% Enter current long term bond rate = 5.00% 0.0690607735 Enter risk premium = 5.20% Enter expected growth rate in the long te 5.00% Intrinsic Value Estimate 1 2 3 4 5 68.4375 Expected Dividends = $73.57 $79.09 $85.02 $91.40 $98.25 Expected Terminal Value = $1,983.91 Present Value = $66.76 $65.13 $63.53 $61.97 $1,281.17 Intrinsic Value of Index $1,538.56 Implied Risk Premium Implied Risk Premium in current level o 4.39% (Go under Tools and choose Solver: See below) 1 2 3 4 5 Expected Dividends = $73.57 $79.09 $85.02
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: $91.40 $98.25 $104.64 Expected Terminal Value = $2,349.79 Present Value = $67.25 $66.09 $64.95 $63.83 $1,562.87 Intrinsic Value of Index $1,825.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

kospiimplprem08 - $91.40 $98.25 $104.64 Expected Terminal...

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