How would I determine IRR if this is the only information gi
How would I determine IRR if this is the only information given ? Please show your work
Holding Period
Year
Geico Earnings Per Share
P/E Ratio
0
1995
3.66
19
1
1996
3.66
19
2
1997
4.51
19
3
1998
5.01
19
4
1999
5.56
19
5
2000
6.17
19
6
2001
6.85
19
7
2002
7.60
19
8
2003
8.43
19
9
2004
9.36
19
10
2005
10.39
19
Average earning growth rate : EPS in year 10(2005) : 3.66(1+.11)^10= 10.39
CGY = (( 51.25 / 1.334 ) ^ ( 1/10 ) - 1 ) =44.03%
Dividend Yield = 25.104% - 22.4700489% = 2.6339511%
Total Yield (IRR) =
| Holding Period | Year | Geico Earnings Per Share | P/E Ratio |
| 0 | 1995 | 3.66 | 19 |
| 1 | 1996 | 3.66 | 19 |
| 2 | 1997 | 4.51 | 19 |
| 3 | 1998 | 5.01 | 19 |
| 4 | 1999 | 5.56 | 19 |
| 5 | 2000 | 6.17 | 19 |
| 6 | 2001 | 6.85 | 19 |
| 7 | 2002 | 7.60 | 19 |
| 8 | 2003 | 8.43 | 19 |
| 9 | 2004 | 9.36 | 19 |
| 10 | 2005 | 10.39 | 19 |
Solution
19*3.66+3.66/(1+IRR)+4.51/(1+IRR)^2+5.01/(1+IRR)^3+5.56/(1+IRR)^4+6.17/(1+IRR)^5+6.85/(1+IRR)^6+7.6/(1+IRR)^7+8.43/(1+IRR)^8+9.36/(1+IRR)^9+10.39*19/(1+IRR)^10=0
=>IRR=16.30%
