The Motley Fool Discussion Boards

Previous Page

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

66 years.
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