The Motley Fool Discussion Boards
Investing/Strategies / Retirement Investing
|Subject: Re: Strategy comparison S&P500 vs. IUL [rev 1]||Date: 4/7/2013 6:48 PM|
|Author: Rayvt||Number: 71782 of 78166|
Time to do a back-of-envelope sanity check on my spreadsheet. Those numbers I recently posted seem too good to be true.
S&P500 spreadsheet growth calculations sanity check
S&P500 actual values.
Open 1/3/1950: 16.66
Close 12/31/2012: 1426.19
16.66 growing at 7.32% compounded annually for 66 years = 1427.44
Therefore the approximate CAGR was 7.32%
$10,000 growing at 7.32% compounded annually for 66 years = $856,805
My backtest spreadsheet says:
B&H of S&P500 without dividends, no expenses
Initial value $10,000, $0/mo additions
Final value on 1/1/2013 = $836,475
The values are very close, only 2.3% difference.
Therefore, the spreadsheet calculations & formulas are correct.
We know that the historical average dividend yield of the S&P500 is around 3%, sometimes higher, sometimes lower.
Let's make a guess. Let's guess that the