UnThreaded | Threaded | Whole Thread (147) | Ignore Thread Prev Thread | Prev | Next | Next Thread
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 75828  
Subject: Re: Strategy comparison S&P500 vs. IUL [rev 1] Date: 4/7/2013 11:43 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
see how an IUL performs - both during accumulation, and distribution assuming the tax free loan status and continual crediting of the loan amount
Um .... forgot about this. Plain vanilla simple method is final value $29,800.

Need to figure accumulation of running balance minus outstanding loan minus 6% interest.
Let's assume we don't reduce the value by the draws, but keep track of the draw amount and the interest owed in a side account.
We'll let it grow, then at the end offset by subtracting the balance of this side account.

So play a game with the spreadsheet. Accumulation phase as before, to 1/1/2003, but then set withdrawal of $0 (this stops the deposits). See what final value is reported, and then subtract out the total amount of the side account.

SWAG on the loan interest. Avg balance of $100,850 (half of the total draw) at 6% per year = $6051/yr. Over 10 years that's $60,510.

Final SWAG'ed value: $286,500 - $201,700 - $60,510 = $24,300.
(Final value - total withdrawal - accumulated interest).

Oh, duh!! No need to SWAG -- excel is good at this kind of thing.
Ending balance of loan side account at 6% interest, computed monthly is $272,000. ($270,600 if computed annually.)

Final net value: $286,500 - $272,000 = $14,500.

Same ballpark as the plain Jane method, so all the fancy footwork with loans, etc. is just fancy-dancing with minimal real-world effect.


----------------------------------------
CC:
Also, we're not using a "single investment" of $1,000 but an agreed ongoing investment of X.
CC, what he did was a quick & dirty back-of-envelope smell test. Engineers & physicists do this all the time.
All you are trying to do is to see what ballpark the numbers are in. "Smell test" is like sniffing that lunchmeat in the refigerator --- you're not trying to get an exact freshness level -- you are just trying to see if it smells bad.

The value of this technique is that it is simple -- so simple that any methodology errors will be clearly obvious -- but that it will still give you a decent approximation to the results that have all the complexity. If the back-of-envelope number is way off from what you need it to be -- it smells and you know your idea is garbage, yo don't need to waste any more time & effort to be more exact.


Like he said, you can do this in 5 minutes. It's so simple that it would take as much time find it again after you've saved it as it would to just re-do it from scratch.
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (147) | Ignore Thread Prev Thread | Prev | Next | Next Thread

Announcements

The Retire Early Home Page
Discussion on accelerating retirement day.
Pencils of Promise - Back to School Drive
"Pencils of Promise works with communities across the globe to build schools and create programs that provide education opportunities for children."
Managing Your Wealth
Our own TMFHockeypop from Rule Your Retirement fame on the TV show Managing Your Wealth.
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.
Post of the Day:
Apple

The Saddest Place on iPhone Day
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
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