UnThreaded | Threaded | Whole Thread (2) | Ignore Thread Prev | Next
Author: Rayvt Big gold star, 5000 posts Top Favorite Fools Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 75339  
Subject: Rerun of Dave's IUL scenario Date: 4/9/2013 12:54 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 8
Now that the spreadsheet has gotten quite sophisticated, it is worthwhile to revisit Dave's original scenario.
This is a backtest of investing directly in the S&P500 vs. investing in the S&P500 index the way that an IUL (Indexed Universal Life) policy does.

IUL parameters (all annual):
Floor: 0%
Cap: 12%
Fees: 0.75%
Policy loan interest rate: 6.0%
S&P methods pay 15% tax on dividends. No other taxes considered.

Note:
Starting dates are beginning of that month.
Ending dates are end of that month.

Accumulate and grow for 28 years, then withdraw for 10 years.
--------------------------------------------
Initial $10,000 deposit. Adding $100/mo
Start Jan-1975
Begin withdrawals Jan-2003
Withdraw $1,500/mo,

Final values (strategy, Net final value, ending date):
B&H w/div	$844,962	Dec 2012
10mSMA $599,997 Dec 2012
IUL (loan) $41,003 Dec 2012
IUL (withdraw) $48,506 Dec 2012

TTL withdraw -$180,000

--------------------------------------------
This run begins withdrawals at about the peak of a boom, so it
has money being withdrawn while the portfolio is being crushed.
You are taking money out of an ever-dwindling portfolio.
Start Mar-1971
Begin withdrawals Mar-1999 (just before the peak before the dot-com boom)
ending Mar-2009 (at the bottom of the financial crash)

Final values (strategy, Net final value, ending date):
B&H w/div	$436,936	Feb 2009
10mSMA $624,457 Feb 2009
IUL (loan) $28,576 Feb 2009
IUL (withdraw) $48,571 Feb 2009

TTL withdraw -$180,000

You can see the operation of the IUL's floor and cap. And how the policy loan effectively shifts them downward by the amount of the interest rate. You can also see the operation of the SMA.

--------------------------------------------
This run begins withdrawals right at the bottom of a crash.
Start Oct-1974
Begin withdrawals Oct-2002 (at the bottom the dot-com bust)

Final values (strategy, Net final value, ending date):
B&H w/div	$918,952	Sep 2012
10mSMA $611,161 Sep 2012
IUL (loan) $35,784 Sep 2012
IUL (withdraw) $45,355 Sep 2012

TTL withdraw -$180,000

Interesting .... The IUL (withdraw) rode out the crash quite well.

--------------------------------------------
A completely different time period.
Start Jan-1960
Begin withdrawals Jan-1988

Final values (strategy, Net final value, ending date):
B&H w/div	$966,505	Dec 1997
10mSMA $595,172 Dec 1997
IUL (loan) $17,752 Dec 1997
IUL (withdraw) -$1,446 Dec 1997

TTL withdraw -$180,000
Note that the IUL (withdraw) ran out of money.

---------------
Continuing this onward for another 10 years:
B&H w/div	$1,446,913	Dec 2007
10mSMA $939,059 Dec 2007
IUL (loan) -$203,566 Dec 2007
IUL (withdraw) -$244,881 Dec 2007

TTL withdraw -$360,000
Note that both the IUL methods ran out of money.

---------------
Continuing this onward to the present:
B&H w/div	$1,445,502	Dec 2012
10mSMA $995,827 Dec 2012
IUL (loan) -$417,559 Dec 2012
IUL (withdraw) -$413,353 Dec 2012

TTL withdraw -$450,000


-------------------------------------------------
-------------------------------------------------
Like the first scenario, but increasing the deposits and withdrawals with inflation.
Initial $10,000
Start Jan-1975
Adding $100/mo, increasing deposit by 3%/yr
Begin withdrawals Jan-2003
Withdraw $1,500/mo, increasing draw by 2.5%/yr

Final values (strategy, Net final value, ending date-end-of-month):
B&H w/div	$923,625	Dec 2012
10mSMA $683,729 Dec 2012
IUL (loan) $77,215 Dec 2012
IUL (withdraw) $85,407 Dec 2012

TTL withdraw -$201,661

-----------------------------------------------
A completely different time period, increasing the deposits and withdrawals with inflation.
Start Jan-1960
Begin withdrawals Jan-1988

Final values (strategy, Net final value, ending date):
B&H w/div	$1,215,480	Dec 1997
10mSMA $760,535 Dec 1997
IUL (loan) $58,654 Dec 1997
IUL (withdraw) $38,157 Dec 1997

TTL withdraw -$201,661



Final values (strategy, Net final value, ending date):
B&H w/div	$1,720,391	Dec 2012
10mSMA $1,184,102 Dec 2012
IUL (loan) -$536,942 Dec 2012
IUL (withdraw) -$522,760 Dec 2012

TTL withdraw -$614,840
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (2) | Ignore Thread Prev | Next

Announcements

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

Medallion Financial: TAXI!
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