No. of 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.
Print the post  


The Retirement Investing Board
This is the board for all discussions related to Investing for and during retirement. To keep the board relevant and Foolish to everyone, please avoid making any posts pertaining to political partisanship. Fool on and Retire on!
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.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! 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.