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% = $1090Or 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.
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Ra