UnThreaded | Threaded | Whole Thread (147) | Ignore Thread Prev | Next
Author: Rayvt Big gold star, 5000 posts Top Favorite Fools Top Recommended Fools Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 75540  
Subject: Re: Strategy comparison S&P500 vs. IUL [rev 1] Date: 4/7/2013 8:11 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
How then can Rayvt's calculations [excerpted from his post] be accurate?

~ Starting 1/1/1965, accumulate until 1/1/2013
~ Initial $10,000 and add $1000/mo
~ S&P final balance: $12,003,000
~ S&P B&H start $5000/mo withdrawal on 1/1/1970 [just five years later] with a starting balance of $12,003,000.
~ Final value 20 years later, 1/1/1990: $95,615,000

Do we even need a spreadsheet to ask, "What's wrong with this picture?"


That's where back-of-envelope sanity checks become useful.

Not sure what exactly you are questioning.
The difference between MSN's $1M and my figure? When you do compounding, the numbers explode rapidly as the rate goes up.
The " 1970 [just five years later]" balance of $12M?

This was a darn hard thing to try to model reasonably. The explanation is also maybe difficult to get across clearly.

It's really two different modelling runs.
Run 1) 48 year Accumulation phase from 1/65 to 1/13, starting value $10K and adding $1K/mo. The final value of that: $12,003,000

Run 2) 20 year Deccumulation phase, starting value $12,003,000 (the final value of the accum phase), withdrawing $5000/mo.

Now, what time period do we use for the deccum phase? Can't use 2013-2033 because that's the unknown future.
So pick *any* 20 year time span that we have actual historical data for. I picked 1970 at random, and because that excluded the dot-com boom which would arguably give over-optimistic results.
You could reasonably use any 20 year period you want, anywhere from 1950-1970 to 1993-2013.

Just change the dates in the spreadsheet. It's a bit of a pain, because I have to reset several parameters and then pick out the ending line from the middle of the spreadsheet, 20 years later.

But here goes: for 1960-1980 period:
S&P: $40,698,219

IUL: $4,922,518 - -$2,310,204 (loan) = $2,612,313

They are both lower than 1970-90.

-----------
Here, for 1980-2000 period:
S&P: $297,359,265

IUL: $7,867,082 -$2,310,204 (loan) = $5,556,877

They are both higher than 1970-90.

S&P went from 107.94 to 1469.25 (no dividends). That's 13.6 times.
$12M * 13.6 = $163M, so with dividends $297M sounds reasonable.
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (147) | Ignore Thread Prev | Next

Announcements

The Retire Early Home Page
Discussion on accelerating retirement day.
Post of the Day:
Value Hounds

Kate Spade's Wild Ride
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and "#1 Media Company to Work For" (BusinessInsider 2011)! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.
Advertisement