Brazilimpr2001

Brazilimpr2001 - 6.66(Go under Tools and choose Solver See...

Info iconThis preview shows page 1. 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 = 16417 Enter current dividend yield = 4.40% Enter expected growth rate in earnings fo 13.50% Enter current long term bond rate = 4.50% Enter risk premium = 5.50% Enter expected growth rate in the long te 4.50% Intrinsic Value Estimate 1 2 3 4 5 Expected Dividends = $819.86 $930.55 $1,056.17 $1,198.75 $1,360.59 Expected Terminal Value = $25,851.12 Present Value = $745.33 $769.05 $793.52 $818.76 $16,896.33 Intrinsic Value of Index $20,022.99 Implied Risk Premium Implied Risk Premium in current level of
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6.66% (Go under Tools and choose Solver: See below) 1 2 3 4 5 Expected Dividends = $819.86 $930.55 $1,056.17 $1,198.75 $1,360.59 $1,449.02 Expected Terminal Value = $21,338.85 Present Value = $737.53 $753.04 $768.87 $785.03 $13,372.52 Intrinsic Value of Index $16,417.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....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online