Year 1: 100% gain Year 2: 50% loss
The arithmetic average here is 50%, which the geometric average is 0%. The CAGR listed is going the correct metric to use but that is not 9% after inflation using the date range you provided. I get 7.42% for 1/1/95 - 12/31/14 after inflation and dividends are factored in. Not bad by any stretch of the imagination, though!
And its return since the 50s is 7% in real terms. And there were decades at a time (including the 2000-2010 period, where real return was -3.4%) that significantly underperformed that), so it's not even a reliable 7% a year, which you'd need for these calculations to work out.
For additional information: www.firecalc.com
On an inflation-adjusted basis, the S&P 500 has not grown at all for the past 15 years:
http://www.multpl.com/inflation-adjusted-s-p-500
The average rate of return for the past 50 years is pretty small. You can make almost any rate of return look reasonable if you cherry-pick the right timeframe, but the long-term average doesn't look good at all.
SO, while you were claiming the above poster was using bad numbers by using "the last 6 years," you are similarly using biased data by looking at the past 15 years because that's the eve of the dot com bust.
Edit: looks like without inflation, if this calculator is to be believed:
http://dqydj.net/sp-500-return-calculator/
The annualized return for the past 15 years with both dividends and inflation is under 2%.
I know that I'm cherry-picking by using a 15 year period. That was my entire point: that you can cherry-pick to find almost any rate of return.
However, that particular period is still pretty relevant. If your plan is to spend 10% of your savings per year, then a 15-year period of zero (or just small) returns will wipe you out. Even if it bounces back afterwards, you're still screwed.