The Motley Fool Discussion Boards

Previous Page  
Investing/Strategies / Retirement Investing 

URL:
http://boards.fool.com/herestheactualmathanalysisinanotherthread30609900.aspx


Subject: Re: 7702 Private Plans (indexed universal life)  Date: 3/27/2013 5:27 PM  
Author: Rayvt  Number: 71512 of 75340  
Here's the actual math analysis. In another thread on another (but related) topic, we did an analysis on the actual historical monthly returns, to see how often the return was greater than an X% cap. We were all assuming that the number of months with a gain of 2% or more was small. The actual count was surprisingly large. That thread was concerned with monthly returns, but for IULs it is more appropriate to do quarterly. When they say "12% cap" they mean 1% a month or 3% a quarter, not 12% a year. The longer the period, the better it is for you. The following figures are for a 3% quarterly cap, based on rolling quarters from 1993 to present. Here's the breakdown. The count on a row is the number of rolling quarters which had a return between the gain on that row and the next row. IOW, 11 quarters had gain more than 0.00% and less than 1.00%. There were 20 (11+9) periods with a gain of up to 2%. There were 30 periods (10+20) with a loss of less than 2%. So by just counting good vs. bad periods, you'd be inclined do a little happydance. You got a small gain 20 times and avoided a similarly small loss 30 times.
The highest quarterly return was 20%. The worst was 39% loss. 57% of the quarters had a gain of less than 3%. Which means that 43% of the time you ran into the cap. This data also shows that you got protected by the floor 60% of the time, and that's a Good Thing. But the numbers of floored and capped periods aren't the main thing. What matters is the amounts of the dollars that are protected and foregone. If you duck 1 loss of 7% but forego 7 gains of 7% (gain of 10% capped at 3%), that's not a good tradeoff. That's the statistics on the distributions of the returns. Now let's look at the actual outcome, applying the 0% (no losses) floor and the 3% caps on each rolling quarter, 1993 to present  20 years. This period encompasses two large bear markets, the 2001 dotcom bust and the 2008 financial meltdown. The maximum return is indeed 3% and the minimum is indeed 0%. That's compared to the unfloored and uncapped figures of 20% and 39%. The overall CAGR (compound annual growth rate) was 6.8%, which means that $10,000 would have grown to $37,619. Compared to the return of the actual S&P500 including dividends, with no loss floor and no maximum cap, which had CAGR of 10.2%, and $10,000 would have grown to $70,323. The graph of the equity curves is interesting. http://i1131.photobucket.com/albums/m543/rayvt/EquitycurvesS... The S&P500 (including dividends) equity swings up and down, while the IUL marches sedately upward. But the S&P equity is always quite a bit higher than the IUL equity, except for one short period in the 20082009 bear market. But ... $70K vs. $37K. $33,000 You pay a very hefty price for the comfort of a neverfalling value. 

Copyright 19962014 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us 