[ QUOTE ]
[ QUOTE ]
I can post the total return % for the S&P going back x number of years
[/ QUOTE ]
This could also be calculated (only back to 1990) using
this spreadsheet.
[/ QUOTE ]
Can you go over the calculation once?
Never mind... Looks like this works....
=(1+K19)*(1+K18)*(1+K17)*(1+K16)*(1+K15)*(1+K14)*( 1+K13)*(1+K12)*(1+K11)*(1+K10)*(1+K9)*(1+K8)-1
Basically a formula for as many months as you need. It's not in the 2005 12 month total return column but can be found lower down.
Krishan