Investor Analysis of Index Annuities

Discuss all general (i.e. non-personal) investing questions and issues, investing news, and theory.
Post Reply
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Investor Analysis of Index Annuities

Post by ThePrune »

SUMMARY OF THE POSTING: I've taken a first stab at creating a general purpose Monte Carlo modeler for comparing Fixed Index Annuities to combinations of stock and bond mutual funds.

WHAT I'M SEEKING:
A few folks willing to Beta test the program. Must be knowledgeable with Excel programming.
A few folks willing to improve the approach I've taken to to generate random monthly returns on the S&P 500 and the Dow Jones Industrials price indices.
A few folks willing to check to see if there are Fixed Index Annuity schemes that I haven't yet incorporated in the modeler.

IF THESE DON'T DESCRIBE YOU? Nothing more to read here. Move along to the next posting!
________________________________________________________________________________________

As Bogleheads we take great pride in being "data driven" in our analysis of financial investments. Reading this forum over the last several years I have been exposed to numerous excellent studies substantiating the long term superiority of low-cost index mutual funds. This has supplied me with great "ammunition" for discussions with brokerage sales agents.

As many of you are aware, the primary financial product being sold today by Insurance Producers is the Fixed Index Annuity (aka Equity Indexed Annuity). It has always struck me, though, that whenever posting streams on Fixed Index Annuities appear here, the argument comes down to something like, "smart people have analyzed them, they're complicated, and they're a bad investment."

But can't we do something more :confused What if we could produce a program that would allow a Boglehead with reasonable financial and Excel skills to quickly analyse an arbitrary Fixed Index Annuity, quantitatively compare it to a combination of stock and bond index mutual funds, and allow them to show friends the financial drawbacks of the index annuity?
We should have done this years ago :oops: (And maybe someone has! Please let me know, if so!)

So I've taken a stab at this problem. After my most recent request to consider purchasing a fixed index annuity (the Bonus Gold from American Equity Investment Life Insurance Company), I created a general purpose Monte Carlo modeling program (in Excel) for index annuites. It has these features:
- Handles the S&P 500 and the Dow Jones Industrial price indices
-Contract terms from 5 to 20 years
-Can incorporate "premium bonuses"
-Can simulate "Annual Monthly Average", "Anual Point to Point" and "Monthly Point to Point" crediting schemes
-Can handle either cap rate or participation rate limits on the price index increases
-Can apply additional Asset Rate Fees either before or after the cap/participation rate limits

For investment comparisons, it allows a combination of stock and bond mutual funds:
-Percentages of funds in stocks from 100% to 0%
-Set your preferred dividend yield and expense ratio for the stock fund
-Set your preferred bond yield and expense ratio for the bond fund
-Or model a single fund investment with both stocks and bonds
-Annual rebalancing is allowed, but can be turned off

For comparison in taxable brokerage account, you can enter your marginal tax rate, qualified dividend rate, and long term capital gains rate. Or you can ignore taxes.

If you've read this far, you already know what I want: VOLUNTEERS! :D (But not too many.) You can either PM me to get a copy of the program (Excel 2003 with VBA macros), or add to this posting stream with questions, comments or suggestions.
Last edited by ThePrune on Fri May 30, 2014 8:02 pm, edited 1 time in total.
Investment skill is often just luck in sheep's clothing.
MN Finance
Posts: 1926
Joined: Sat Dec 22, 2012 9:46 am

Re: Investor Analysis of Index Annuities

Post by MN Finance »

Just a comment, not a volunteer. But I will find this very helpful. Obviously we rail against annuity products, but in today's interest environment, it could very easily be the case that fixed index annuities could provide a better total return than other fixed income options, with similar or lower risk (one being surrender fees). If we can get a CD or bond at 2% and an indexed annuity without riders (as pure an investment as possible) the over/under for the product to come out ahead is very low (2%).
kpoole
Posts: 1
Joined: Tue May 21, 2013 8:38 pm

Re: Investor Analysis of Index Annuities

Post by kpoole »

I wouldn't be much help on the programming side, but I analyze over a hundred annuities per year (from various companies), so I might be abble to identify schemes that are not included in your model. Please let me know if I can help.
bberris
Posts: 2420
Joined: Sun Feb 20, 2011 8:44 am

Re: Investor Analysis of Index Annuities

Post by bberris »

MN Finance wrote:Just a comment, not a volunteer. But I will find this very helpful. Obviously we rail against annuity products, but in today's interest environment, it could very easily be the case that fixed index annuities could provide a better total return than other fixed income options, with similar or lower risk (one being surrender fees). If we can get a CD or bond at 2% and an indexed annuity without riders (as pure an investment as possible) the over/under for the product to come out ahead is very low (2%).
What magic does an insurance company perform to provide you with superior risk-adjusted returns, give a 10 % comish to the salesman, and a comfortable profit margin to themselves?
dhodson
Posts: 4117
Joined: Mon May 24, 2010 3:03 pm

Re: Investor Analysis of Index Annuities

Post by dhodson »

As im sure you know (at least i guess it based on the wording of your post), there is no magic.

In a simplistic form, what the insurance company does is invest the majority of the money invested like 96% in their typical portfolio which is high in bonds/treasuries. They invest the rest in options. If the stock market goes down then the options are worthless and they likely can meet the minimum guarantee via their bonds/treasuries. If the stock market goes up then they credit your acount based on the crediting method chosen beyond the minimum guarantees. If the stock market isnt behaving as they predicted then they can unilaterally change the caps and/or participation rates. The surrender fees/period also make sure they cant get burned. Frankly if they didnt have methods to make sure they didnt get burned then they might have trouble making their guarantees.

Bottom line for me is that there is no magic in this world and that is why a strategy such as index annuities wont work. Costs matter.
MN Finance
Posts: 1926
Joined: Sat Dec 22, 2012 9:46 am

Re: Investor Analysis of Index Annuities

Post by MN Finance »

This thread wasn't started to debate the merits or lack thereof of an indexed annuity.

I am no annuity sympathizer - far from it. But first, costs don't matter in an indexed annuity. In fact there are no explicit costs. It's not any different than asking your bank what the costs of their CDs are. The only thing that matters are the terms of the contract. When compared to a traditional portfolio (as they are often sold,) they are totally inadequate (which is prune's thesis). My interest is in their possible use as a replacement for other traditional fixed income investments because of the rate environment we're in. The expectation is that in a normal world they would be inferior to conventional bonds (historically they have mirrored EE bond returns closely, both of which very much underperformed the bond market over time). I can buy a 10 year treasury and get 2% over the next 10 years. Alternatively, I could buy a fixed index annuity and get a return between maybe 0% and 10% per year. This is not an unreasonable tradeoff with similar risks, but one that I don't have a firm grasp on - hence my interest in the work prune is doing. (Of course the downside would be the need to surrender the annuity early and pay a penalty.)

Any "magic" is that my return is not solely based on the performance of the specific asset underlying my investment (like any conventional fund). My return is based on the promise of the insurance company to pay the terms of the contract, thus transferring risk, which only shows up if the company becomes insolvent and isn't bailed out.
dhodson
Posts: 4117
Joined: Mon May 24, 2010 3:03 pm

Re: Investor Analysis of Index Annuities

Post by dhodson »

unfortunately my previous post commending him for doing the work was deleted with the recent forum problems and that is why i was only responding to the other post.

however you are wrong about the cost issue. The costs just arent transparent. This is why the company is legally allowed to change unilaterally the caps/participation rates which at the moment are primarily reducing the upper caps if im not mistaken. As you mentioned the interest rate environment right now is low and the majority of the investments the insurance company is making with their general fund will be impacted by this. To say well currently a cd gets x% but historically an index annuity has gotten up to 10% isnt being realistic bc the underlying investements are still bond/treasuries primarily and thus those factors will still impact the return. They cant produce returns higher than what they are investing in minus costs and their costs are high.
MN Finance
Posts: 1926
Joined: Sat Dec 22, 2012 9:46 am

Re: Investor Analysis of Index Annuities

Post by MN Finance »

The ONLY thing "costs" impact is the solvency of the insurer. If the contract says I have a monthly cap of 2.5% and an annual floor of 0%, neither the 0% or 2.5% are impacted by any costs (stated or otherwise). How is my return impacted by anything other than the 0% and 2.5% numbers? It's not. I don't care if the general account returns any particular return and if it's return is enough to produce my contractual return or vastly more than my contractual return. In aggregate the insurer isn't going to lose money; and they will adjust new contract terms to ensure that doesn't happen, but there's nothing that says I can't evaluate the stated terms of a contract in comparison to other fixed income alternatives. That's a totally valid comparison. I can take a treasury or CD with a known future return and compare that to a monte carlo of potential index annuity returns and make a judgment. If a known future CD return is 2% and the data shows the indexed annuity has a dispersion of outcomes between 1% and 12% with a 95% confidence interval over the same term with an average return of 5% and a standard deviation of 6%, now an informed decision can be made. (Made up numbers, until there's data to look at).
ndchamp
Posts: 272
Joined: Mon May 14, 2007 8:30 am

Re: Investor Analysis of Index Annuities

Post by ndchamp »

First see what you're REALLY getting in a fixed income option.
Probably no need to go any further.
Moshe A Milevsky offers a way to do that.
http://www.advisorone.com/2009/08/01/an ... ate-really
dhodson
Posts: 4117
Joined: Mon May 24, 2010 3:03 pm

Re: Investor Analysis of Index Annuities

Post by dhodson »

MN Finance wrote:The ONLY thing "costs" impact is the solvency of the insurer. If the contract says I have a monthly cap of 2.5% and an annual floor of 0%, neither the 0% or 2.5% are impacted by any costs (stated or otherwise). How is my return impacted by anything other than the 0% and 2.5% numbers? It's not. I don't care if the general account returns any particular return and if it's return is enough to produce my contractual return or vastly more than my contractual return. In aggregate the insurer isn't going to lose money; and they will adjust new contract terms to ensure that doesn't happen, but there's nothing that says I can't evaluate the stated terms of a contract in comparison to other fixed income alternatives. That's a totally valid comparison. I can take a treasury or CD with a known future return and compare that to a monte carlo of potential index annuity returns and make a judgment. If a known future CD return is 2% and the data shows the indexed annuity has a dispersion of outcomes between 1% and 12% with a 95% confidence interval over the same term with an average return of 5% and a standard deviation of 6%, now an informed decision can be made. (Made up numbers, until there's data to look at).

Very easily the contract says they can reduce the 2.5. They will if there is no profit/losing money. That's part of the problem that the 2.5 isn't guaranteed.

Additionally we dont have data with these types of products in a long period of low interest rate as far as i know. That is another reason why the underlying investments and costs are important. You would be making a determination based on data that sounds scientific but isnt practical.

If you look at other insurance products, the companies do make these sort of changes. For instance with LTCi, they have raised rates bc rates arent guaranteed. Recently there was a thread that some states are concerned about the investments that some companies are now looking to make since they are having a hard time meeting their guarantees. This of course is more in line with your concern about just insolvency. They cant just change new contracts to make up the losses since nobody would buy them.
MN Finance
Posts: 1926
Joined: Sat Dec 22, 2012 9:46 am

Re: Investor Analysis of Index Annuities

Post by MN Finance »

ndchamp wrote:First see what you're REALLY getting in a fixed income option.
Probably no need to go any further.
Moshe A Milevsky offers a way to do that.
http://www.advisorone.com/2009/08/01/an ... ate-really
This is not the product being discussed.
dhodson wrote:Very easily the contract says they can reduce the 2.5. They will if there is no profit/losing money. That's part of the problem that the 2.5 isn't guaranteed.
They can't change the terms of a contract. If the contracts states the terms accurately, then a judgment can be made.

I'm not trying to make a case for myself or anyone else to by an indexed annuity, but any knowledgeable investor should be interested in understanding what options exist. There is very little data on the performance of indexed annuities, which is exactly why this is a valid exercise. That's my only point in commenting at all.
dhodson
Posts: 4117
Joined: Mon May 24, 2010 3:03 pm

Re: Investor Analysis of Index Annuities

Post by dhodson »

MN Finance wrote:
ndchamp wrote:First see what you're REALLY getting in a fixed income option.
Probably no need to go any further.
Moshe A Milevsky offers a way to do that.
http://www.advisorone.com/2009/08/01/an ... ate-really
This is not the product being discussed.
dhodson wrote:Very easily the contract says they can reduce the 2.5. They will if there is no profit/losing money. That's part of the problem that the 2.5 isn't guaranteed.
They can't change the terms of a contract. If the contracts states the terms accurately, then a judgment can be made.

I'm not trying to make a case for myself or anyone else to by an indexed annuity, but any knowledgeable investor should be interested in understanding what options exist. There is very little data on the performance of indexed annuities, which is exactly why this is a valid exercise. That's my only point in commenting at all.
The terms of all these contracts say they CAN change those things. Is that something that you are unaware of? Ive already mentioned that i commended him for the work. I think doing work on this or other investment strategies is always beneficial but one needs to understand the limits of the study being performed. I can only hope that the additional posts will draw more people in to consider working with the OP (since he wasnt getting any traction earlier).
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

dhodson wrote:Very easily the contract says they can reduce the 2.5. They will if there is no profit/losing money. That's part of the problem that the 2.5 isn't guaranteed.
This is indeed correct.

For example, the contract terms of the Bonus Gold index annuity that I modeled with my program stated that American Equity had the right each year on the anniversary of the contract date to change the index cap or the participation rate, but that those rates could never be less that rates stated in the contract. For May 2013 here are actual numbers for this 16 year :shock: contract index annuity:

Monthly Index Average or Annual Point-to-Point with cap.
Current cap = 2.75%
Minimum cap = 1.00%

Monthly Index Average or Annual Point-to-Point with participation rate.
Current participation rate = 20.0%
Minimum particiaption rate = 10.0%

Monthly Point-to-Point with cap.
Current cap = 1.70%
Minimum cap = 1.00%

One of the difficutlies with modeling an index annuity is deciding how to deal with the freedom the issuing insurance company has to annually change (OK, drop!) the caps and partitipation rates. In my initial comparisons I took a "Best Case" approach and left the caps / participation rates at their starting levels. Even here the combination of index mutual funds can out as a superior investment.

I have also incorporated into the program the ability to make annual adjusments to the caps and participation rates. I'm trying to get my head wrapped around the rules that the insurance company would follow in dropping these caps / rates.
Investment skill is often just luck in sheep's clothing.
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

MN Finance wrote:Just a comment, not a volunteer. But I will find this very helpful. Obviously we rail against annuity products, but in today's interest environment, it could very easily be the case that fixed index annuities could provide a better total return than other fixed income options, with similar or lower risk (one being surrender fees). If we can get a CD or bond at 2% and an indexed annuity without riders (as pure an investment as possible) the over/under for the product to come out ahead is very low (2%).
I don't know about "easily", but it could happen.

It's like the old joke about an economics professor and one of his students who are walking along a sidewalk. The student spots a $20 bill and stoops to pick it up. The professor tells him not to bother: if it really were a $20 bill, someone would have already picked it up!

Bogleheads know that, in general, they aren't going to find numerous index annuities having competitive value as they walk along the investment world's sidewalk. But if they had a handy tool, they could be in a position to quickly decide if they had run across one of those rare "$20 bills".

The above points are interesting, but my main motivation for this program is to be able to produce real numbers to back up my recommendations not to invest in a specific index annuity. Because I teach retirement planning and investing classes in my community, I get asked such things. I'd like to get beyond, "They're just bad" to being able to say, "Here's how much worse this particular index annuity is in dollars."
Last edited by ThePrune on Fri May 30, 2014 8:05 pm, edited 1 time in total.
Investment skill is often just luck in sheep's clothing.
User avatar
Frugal Al
Posts: 1736
Joined: Fri May 28, 2010 10:09 am

Re: Investor Analysis of Index Annuities

Post by Frugal Al »

I understand some people just love to crunch numbers to quantitatively prove a point, but this product becomes a non starter when it combines illiquidity along with the insurance company's controlling the expenses (via the cap/participation rates) at their own discretion. If we then throw in the fact that they don't include dividends in the "returns" they use, and the gains are all taxable as ordinary income, this proves to be a product only an insurance marketing team could endorse. Once again, beware the high cost of guarantees.
dhodson
Posts: 4117
Joined: Mon May 24, 2010 3:03 pm

Re: Investor Analysis of Index Annuities

Post by dhodson »

I hear you OP but as you can probably guess from my posts, im not sure you can really do what you want to do and have serious validity since you dont have enough data points to really know what they will do with the caps/part. These products havent existed in a longer low interest rate environment to produce data.

There really arent any rules about when they change caps/part rates besides what you mentioned which is typically they can do it yearly. It is at their leisure and for any reason they want. Lets take the product you mentioned with a 16 year contract/surrender period. Those 16 years given them a huge advantage since if it isnt working out as desired for them then they can really hit you on the caps/surrender until you have a product that is definitely below inflation and it gets pretty unlikely that they lose money. Now dont get me wrong, i dont think their intent is to definitely screw people down to the bare minimum. If for some reason we are in an environment where the bonds/treasuries from their general funds are doing great and the options are doing great then i think they will pass some of that along. In the end if you arent willing to live with a mainly bond/treasury investment with a small play on options including an additional fairly high commission then it isnt likely that this is the ticket for you.

Again i wish you the best with your research and i look forward to seeing what answers you feel you find.
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

I've done some more Internet research using Google and have discovered that EIA sales and marketing groups are WAY ahead us us. They have already developed Monte Carlo based "sales demonstration tools" to help Insurance Producers "close the sale" for index annuity products.

An example: MCP Suite Basic: EIA Software.
As an agent or financial advisor, your job is to present products you believe will improve or protect your client's financial situation. Put away that yellow notepad and instead impress them with simple historical charts that
demonstrate how an EIA might have performed versus the stock market or their CD over any time period you choose. Then, drive the point home by illustrating their possible future earnings with a concise, colorful Monte Carlo simulation. With minimal effort on your part you successfully gain their respect, earn their trust, and close the sale. As we like to say, "Work smarter, not Harder!"
By using Monte Carlo software, the sales agent brings the "aura of quantitative objectivity". Of course these programs focus on the risks of loss when investing in 100% equities, and then compare that to the guarantee of no loss with an EIA product. I doubt there is any effort to compare the EIA to the best combination of low-cost stock and bond index funds.

It's one thing to simply state, "Index anuities are a bad investment." It's an entirely different situation when the person seeking our advice comes with a fancy printout from a Monte Carlo sales tool and says, "This advanced mathematical analysis shows that the EIA is a better investment. Why should I believe what you're saying?"
Investment skill is often just luck in sheep's clothing.
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

kpoole wrote:I wouldn't be much help on the programming side, but I analyze over a hundred annuities per year (from various companies), so I might be abble to identify schemes that are not included in your model. Please let me know if I can help.
kpoole, thanks for your offer, and my apologies for being slow to respond.

Here are the cediting schemes I thought were most common and therefore incorporated first into the MC program:
  • Annual Monthly Average with cap
    Annual Monthly Average with participation rate
    Annual Point to Point with cap
    Annual Point to Point with participation rate
    Monthly Point to Point with cap
Here are some crediting schemes I've since read about but haven't incorporated yet:
  • Monthly Point to Point with participation rate
    Annual Point to Point with monthly Look Back and cap
    Annual Point to point with monthly Look Back and participation rate
    Contract Term Point to Point with cap
    Contract Term Point to Point with participation rate
    Contract Term Point to Point with annual Look Back and cap
    Contract Term Point to Point with annual Look Back and participation rate
    Contract Term Point to Point with monthy Look Back and cap
    Contract Term Point to Point with monthly Look Back and participation rate
Can you suggest which of these additional types of crediting schemes would be most important to add? In fact, I could add all of them without too much trouble. (Note: I don't want to get into modeling daily lookbacks!)

Another feature that FIA contract have is variously refered to as a "Spread" or a "Asset Fee Rate". My program can incorporate these either before or after the caps/participation rates are applied. (But I think these are typically applied afterwards.)

Currently I have only incorporated the S&P 500 and the Dow Jones Industrial Average for index crediting. I am aware that some companies offer other indexes: NASDAQ 100, EuroStox 600, etc. Are any of these alternatives really chosen very often by individual purchasers?

Any other features you'd suggest adding?
Investment skill is often just luck in sheep's clothing.
User avatar
Oicuryy
Posts: 1959
Joined: Thu Feb 22, 2007 9:29 pm

Re: Investor Analysis of Index Annuities

Post by Oicuryy »

How would your software analyze this index-linked CD?
http://PROSPECTUS.BONDTRADERPRO.COM/$48124JZU5.PDF

Ron
Money is fungible | Abbreviations and Acronyms
gerrym51
Posts: 1679
Joined: Sat Apr 27, 2013 1:44 pm

Re: Investor Analysis of Index Annuities

Post by gerrym51 »

Oicuryy wrote:How would your software analyze this index-linked CD?
http://PROSPECTUS.BONDTRADERPRO.COM/$48124JZU5.PDF

Ron

i have looked at these(fidelity also sells them). the efficiente index is relatively complicated although i've read its brochure. the problem i have with it is say the index keeps going up for 5 years then on the day before you figure out its final interest and it crashes back to original price you get nothing. its the price on day 1 subtracted from price on last day.

the efficiente index has a big GOLD component. in the fine print of efficiente index it cautions on gold.
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

Oicuryy wrote:How would your software analyze this index-linked CD?
http://PROSPECTUS.BONDTRADERPRO.COM/$48124JZU5.PDF
Ron
Ron, thanks for writing with the challange. I had always wondered how these Index linked CD's sold by JPMorganChase were structured.

Executive Summary: JPMorganChase will give you the original invested principle back at the end of 5 years. If you are really nice to them, they might give you a little bit more back.

Details: to use the Monte Carlo model, it is necessary to be able to describe the crediting index with a stationary statisitcal distribution. But when you look at the crediting index being used by JPMorganChase, the JPMorgan ETF Efficiente 5 Index, the index is not stationary. Rather, JPMorgan has the right to change the percentages of each ETF in the index monthly according to their internal opinion about what Modern Portfolio Theory would predict to be the most efficient mix of stocks, bonds, alternative investments and cash over the next month. Basically, there is no way of knowing how they will adjust the mix in advance. Just modeling their index alone would be tougher than modeling an entire FIA which uses a more traditionally defined index.

I really like this JPMorganChase statement
POTENTIAL CONFLICTS wrote:We and our affiliates play a variety of roles in connection with the issuance of the CDs, including acting as CD calculation agent and index calculation agent and hedging our obligations under the CDs. In performing these duties, the economic interests of the CD calculation agent and other affiliates of ours are potentially adverse to your interests as an investor in the CDs. It is possible that such hedging or trading activities could result in substantial returns for us or our affiliates while the value of the CDs declines.
They should just drop the word "potentially" out of the sentence I highlighted in red :annoyed
Investment skill is often just luck in sheep's clothing.
gerrym51
Posts: 1679
Joined: Sat Apr 27, 2013 1:44 pm

Re: Investor Analysis of Index Annuities

Post by gerrym51 »

i wonder why your moniker is ThePrune as opposed to Prune. just wondering :mrgreen:
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

gerrym51 wrote:i wonder why your moniker is ThePrune as opposed to Prune. just wondering :mrgreen:
Gee, no particular reason. When I had to create a username, that's what came to mind. It's a play on words of sorts, since my last name is French and means plum tree. But I'm well past 50, and no longer a young plum :mrgreen:
Investment skill is often just luck in sheep's clothing.
gerrym51
Posts: 1679
Joined: Sat Apr 27, 2013 1:44 pm

Re: Investor Analysis of Index Annuities

Post by gerrym51 »

ThePrune wrote:
gerrym51 wrote:i wonder why your moniker is ThePrune as opposed to Prune. just wondering :mrgreen:
Gee, no particular reason. When I had to create a username, that's what came to mind. It's a play on words of sorts, since my last name is French and means plum tree. But I'm well past 50, and no longer a young plum :mrgreen:

my grandparents were from canada and mine is a grain :mrgreen:
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

I've finished updating the Excel modeler for Fixed Index Annuities (aka Equity Indexed Annuities). I decided to use the terminology from and to include all the contract options explained in the NAIC Buyer's Guide to Fixed Deferred Annuities, which has an Appendix devoted to Equity Indexed Annuities. Final result: 10 index crediting schemes, each of which can be combined with caps, participation rates, floors and margins/spreads.

I found it very useful to review the NAIC Buyer's Guide. I had forgotten that FIA's sometimes use a Simple Interest approach for crediting, rather than the Compound Interest approach. One more variable to add into the modeler! But the consumer warnings seemed too weak :annoyed Consider this statement:
As with any other insurance product, you must carefully consider your own personal situation and how you feel about the choices available. No single annuity design may have all the features you want. It is important to understand the features and trade-offs available so you can choose the annuity that is right for you.
Can't really understand those features and trade-offs without a modeler!

On the Monte Carlo side, I've added Historical Returns Sequence and Historical Returns Distribution as new approaches to generating the simulated monthly index returns:
  • Historical Returns Sequence: randomly pick a starting month in the range 1927-2012. Simulate monthly returns in the model as following the observed historical sequence of returns starting from that point. Repeat 1000's of times. If the sequence gets to March 2013 before the end of the contract term, loop back to the beginning and follow the historical returns from there.

    Historical Returns Distribution: this is the classic "Bootstrap" approach to mimicing an empirical distribution. Each monthly return in the simulation is derived by randomly selecting an observed monthly return from historical period 1927-2012, with replacement. This approach leads to a larger variance in contract term outcomes, since it lacks the "reversion to the mean" inherent in Historical Returns Sequence approach.
I'm still interested in getting some others to check over the modeler for Excel coding errors.
Investment skill is often just luck in sheep's clothing.
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

I've finished updating the Excel-based, Fixed Index Annuity - Monte Carlo modeler with stock index returns through April 2017. This modeler allows investment returns simulation for FIA contracts using any of the following price indexes:

S&P Composite (1926+) - Robert Shiller's data
S&P 500 (1957+)
S&P Mid-Cap 400 (1991+)
Dow Jones Industrials (1927+)
Dow Jones Industrials (1957+)
Russell 2000 (1987+)
Nasdaq-100 (1985+)
MSCI EAFE (1970+)
STOXX 50 (1987+)
FTSE 100 (1984+)
Dow Jones Real Estate (1992+)
Bloomberg Commodity (1991+)
London Spot Gold (1968+)

(Note: the years in parentheses are the starting years for the monthly returns data used in the modeler).

There is also very detailed user documentation if you are interested in using this software.

Please PM with your direct email if you'd like me to send you software and documentation.

Art "ThePrune"
Investment skill is often just luck in sheep's clothing.
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

Yet another update for the Fixed Index Annuity - Monte Carlo Modeler: This time I've added the capability to analyze two types of FIA-like Hybrid Annuities: Buffer Design and Floor Design.

Such Hybrid Annuities are legally a type of Variable Annuity and must be registered and sold as securities. If you encounter a registered rep promoting an investment in these types of annuities, you now have a tool to quantitatively compare them (1) against a combination of a fixed income investment plus an index fund investment, or (2) against a stand-alone Deferred Fixed Annuity / Multi Year Guaranteed Annuity.

The following material is a brief "Primer" on the differences between these types of annuity contracts.

A typical FIA has a relationship between a price index and its credited gain as shown in the following plot:
Image Even when the price index return is negative (the blue line extending to the left of the vertical axis), no loss is attributed to the FIA cash account (the blue line never drops below the horizontal axis). When the price index return is positive, the FIA contract typically applies a cap to the possible cash account gain (the blue line extending to the right can only rise above the horizontal axis by a limited amount).

A Buffer Design Hybrid Annuity has a relationship between a price index and its credited gain as shown in the following plot:
Image For small losses in the price index no loss is attributed to the FIA cash account. But beyond a certain loss percentage, the FIA cash account will begin to drop in value (the blue line extending to the left drops below the horizontal axis). In the worst case, the potential loss can be very, very large! When the price index shows gains (blue line extending to the right), the cap placed by the annuity contract on the cash account gain is not as severe / potential gains are much larger.

A Floor Design Hybrid Annuity has a relationship between a price index and its credited gain as shown in the follow plot:
Image Small losses in the price index will lead to immediate losses being attributed to the FIA cash account. But there is a maximum amount of loss (a floor) that will be attributed to the cash account. When the price index shows gains, the cap placed by the annuity contract on the cash account gain is once again not as severe / potential gains are much larger.
Investment skill is often just luck in sheep's clothing.
itstoomuch
Posts: 5343
Joined: Mon Dec 15, 2014 11:17 am
Location: midValley OR

Re: Investor Analysis of Index Annuities

Post by itstoomuch »

I will ask for the download if I can remember my other email. :oops:

I cringe when you say "Investor analysis..."
I never viewed our FIa as investing but as Market insurance and a future income stream.
We are coming up on the 5th anniversary on one of the GLWB FIa. Initial purchase at $100,000. Guess on Acct Value is ~$108,000 on 5th anniv. GLWB Income Acct value will be 127,628$ @5% compounding. We no longer need future income from the FIa and I am doing an evaluation on the alternatives.
Thanks.
Later. :beer
Rev012718; 4 Incm stream buckets: SS+pension; dfr'd GLWB VA & FI anntys, by time & $$ laddered; Discretionary; Rentals. LTCi. Own, not asset. Tax TBT%. Early SS. FundRatio (FR) >1.1 67/70yo
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

itstoomuch wrote:I never viewed our FIa as investing but as Market insurance and a future income stream.
We are coming up on the 5th anniversary on one of the GLWB FIa. Initial purchase at $100,000. Guess on Acct Value is ~$108,000 on 5th anniv. GLWB Income Acct value will be 127,628$ @5% compounding. We no longer need future income from the FIa and I am doing an evaluation on the alternatives.
Yes, you are right that a FIA such as the one you have needs to be thought of as a combination of an INSURANCE component (the GLWB) and an INVESTMENT component.

The Monte Carlo modeler only gives you insight into the Investment Component of the FIA contract.

My preferred method for analyzing the Insurance component (preferred because it's so easy!) is to use the calculation proposed by Prof. Moshe Milevsky in the article Annuity Analytics: What is a Guaranteed Rate Really Worth? As Prof. Milevsky points out in the article, the annual percentage gain ("roll-up") in a GLWB rider is NOT equivalent to a bank interest rate or an annual return for a bond or stock fund. What his article's methodology did was allow you to convert the GLWB rider's annual % gain into a "cash-equivalent yield".

As Prof. Milevsky discusses in his 2009 article, cash-equivalent yields were running at about 1/2 of the GLWB roll-up percentage. I've used his method to analyze large numbers of GWLB & GMIB riders since 2009 and continue to find that his observation of " 1/2 " for the cash-equivalent yield is about right.

If you utilize the analysis method in his article, I expect that you will discover that the cash-equivalent yield for your GLWB rider is actually about 2.5% annually (i.e. 1/2 of 5%).

Art
Investment skill is often just luck in sheep's clothing.
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

As mentioned in the previous posting, more and more FIAs are being to be sold with attached Guaranteed Living Benefit (GLB) riders. Such riders will almost always have an associated annual fee; I've typically seen fees from 70 to 125 basis points annually.

To incorporate the "performance drag" created by GLB rider annual fees, I've added a cell into the Fixed Index Annuity - Monte Carlo Modeler for entering this fee (as well as updating the VBA logic that handles all the calculations). This should allow for a more accurate evaluation of the INVESTMENT and INSURANCE components of the FIA contract.

Other New Additions:
(1) Added a second commodity index: the S&P GSCI Excess Return commodity index. I've seen a few FIA's that reference this index. This complements the Bloomberg Commodity Index that was already present.

(2) Added the capability to model Inverse Step Rate (aka Inverse Trigger) crediting schemes. In this type of scheme, if the reference index either remains flat or has a loss over the crediting time period, the FIA contract is credited with a pre-set gain. Otherwise there is no gain credited for the time period.

(The modeler was already able to evaluate Normal Step Rate crediting schemes, where any amount of gain in the reference index leads to a pre-set gain in the FIA contract.)

(3) Not exactly a new capability, but a new realization: the Fixed Index Annuity - Monte Carlo Modeler can be used to model many of the Structured Notes / Structured CD's that utilize a price index crediting scheme to calculate their returns.

As usual, if you'd like a copy of this Excel-based modeler along with its extensive documentation, send me a Private Message that includes a direct email address.

Art "ThePrune"
Investment skill is often just luck in sheep's clothing.
itstoomuch
Posts: 5343
Joined: Mon Dec 15, 2014 11:17 am
Location: midValley OR

Re: Investor Analysis of Index Annuities

Post by itstoomuch »

Never viewed it as an investment or a savings plan but as 1) Equity Market insurance, 2)Income.

Our GLWB Variable annuity are 1 ) equity market insurance; 2) investment; 3)Income.

The Discretionary is for 1) opportunist buy_sells 2) Inflation protection (long Market falls); 3) Discretionary plays.

People should just read Vanguard's presentation to see if they would want this type of program as part of their retirement.
Thanks for the reminder to check this out. :happy

Oddly my brother whose then bank position was banking risk managent didn't believe in annuities/market insurance. Of course he had a pension of 25 yrs and if the gov didn't save them. :confused :oops: I don't have a pension and spouse only a small pension :|
Rev012718; 4 Incm stream buckets: SS+pension; dfr'd GLWB VA & FI anntys, by time & $$ laddered; Discretionary; Rentals. LTCi. Own, not asset. Tax TBT%. Early SS. FundRatio (FR) >1.1 67/70yo
itstoomuch
Posts: 5343
Joined: Mon Dec 15, 2014 11:17 am
Location: midValley OR

Re: Investor Analysis of Index Annuities

Post by itstoomuch »

So if I kill the fia, I would have to run new income and risk scenarios. :oops: :annoyed :annoyed :annoyed
Rev012718; 4 Incm stream buckets: SS+pension; dfr'd GLWB VA & FI anntys, by time & $$ laddered; Discretionary; Rentals. LTCi. Own, not asset. Tax TBT%. Early SS. FundRatio (FR) >1.1 67/70yo
Blissrob
Posts: 1
Joined: Wed Oct 25, 2017 9:45 pm

Re: Investor Analysis of Index Annuities

Post by Blissrob »

ThePrune,
I'm very interested in seeing more of your Excel modeling tool for FIAs. Most advisors are pushing annuities hard and I'd like to run a few examples.
Can you message me the information?
User avatar
Topic Author
ThePrune
Posts: 960
Joined: Wed Nov 10, 2010 8:38 am
Location: Midland, MI

Re: Investor Analysis of Index Annuities

Post by ThePrune »

I've made a major addition to the Monte Carlo Modeler for Fixed Index Annuities.

The modeler now has the capability to perform a detailed analysis of three of the most popular types of Guaranteed Benefit riders that are sold along with Fixed Index Annuities:
  • Guaranteed Minimum Accumulation Benefit (GMAB) riders
    Guaranteed Minimum Income Benefit (GMIB) riders
    Guaranteed Lifetime Withdrawal Benefit (GLWB) riders
Instructions for analyzing all three types of riders are contained in the updated version of the PDF document, "Usage Tips for the FIA Modeler v3.0.0".

If you want a copy of the updated (version 3.0.0) modeler and associated documentation, please send me a Private Message (PM) that also contains your direct email address. I'll email you the modeler and associated documentation.

Art ThePrune
Investment skill is often just luck in sheep's clothing.
Post Reply