UnThreaded | Threaded | Whole Thread (85) | 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 75402  
Subject: Re: 7702 Private Plans (indexed universal life) Date: 3/30/2013 7:08 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
Okay, annual 0% floor, 12% cap.
Index is S&P500 including constant dividend yield of 2.75%, Jan 1975 thru Dec 2012.
One time initial deposit of $10,000. (Doesn't matter, just scale up to whatever you want.)

Annual fees are fixed at 1%. I'm not sure how to apply the fee, though. Google didn't come up with anything the explained the details.

Is it subtracted from the return? That would mean the true floor is -1% and the true cap is 11%.
So if the prior account value was $1,000 and the index gained 10%, the new value would be $1,000 at a gain of 9% = $1090

Or do you subtract the fee from the previous account value and then apply the credit?
That would be $1000 - 1% = $990 and then a gain of 10% to get $1089.
It's only a small difference, but might as well be as accurate as possible.

I can't really do a stepped fee, where the fee is X% for some number of years and then Y% thereafter. What I found with google indicated that the mortality charges increase as you get older, so that would mean that the fee goes UP as the years go by. Makes me dizzy.
So what figure should I use that is constant for the entire 37 year period? 1.00? 0.75%?

Periodic deposits are a bit harder to do, but not impossible. I assume the gains & fees apply to the prior balance, and then the new deposit is added in, right? $10,000 initial and then $1200/yr.
Oh, heck, I just thought --- it's actually real easy to do, I've just never done it because I don't normally model that way.

I'm setting up the spreadsheet so that all these things are parameters so they'll be easy to change.
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (85) | Ignore Thread Prev | Next

Announcements

The Retire Early Home Page
Discussion on accelerating retirement day.
Post of the Day:
TMFDeej's CAPS Blog

Name of the Game: Tax Avoidance
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