Jun 13, 2011

Actuary Garfield

There's not a lot of 'Actuary Humor' on the Internet. Here's one...

Actuary Garfield explains how actuaries think...


Great and lots of humor, those Garfield cartoon strips, (especially those about actuaries....).

Original Sources:
- Garfield Snow
- Garfield Snowman

Jun 5, 2011

Short Term Longevity Risk

As well-born actuaries we all know the long term risks of longevity:


Lots of actuaries keep expending their energy on calculations of 50 years ahead mortality probabilities....  And indeed..., this is challenging....

Some research reports predict a decline in life expectation, others and more serious recent reports show a steady increase of life expectation.

Mission Impossible
Fact of actuarial life is that - although long term research is useful and educational - we are no Actuarial Magicians.

We should never suggest that we're able to value a bunch of complex and systemic risks  (liabilities, assets,mortality, costs, demographics, etc) into a reliable consistent model that predicts reality.

It's a farce!

What CAN we do?
Instead trying to compress a complex of long term risky cash flows into one representing unique value, we need to:
  1. Analyze and model the short term risks
  2. Develop a method (system) that enables boards of directors to manage and control their risky cash flows (profit share systems, experience rating, etc.).

Example: Short Term Longevity Risk
As a 2011 report of the National Research Council clearly shows:  The previous 50 years we've seen a 3 months yearly increase of lifespan every calendar year.


Instead of recalculating, checking and pondering this trend, let's take a look at the short term effects of this longevity increase trend.

Effect of 'one year life expectancy' increase 
First we take a look at the cost effect of the increase of 'one year of life expectancy' on a single-premium of a (deferred) life annuity (paid-up pensions)...
( Life table total population: United States, 2003 )


Depending on the discounting interest rate, a one year improvement of longevity for a 65 old person demands a 2,3% to 4,0% increase of the liabilities.

Of course the increase of the liabilities of a portfolio (of a pension fund) depends on the (liability weighted) age distrubution of the corresponding portfolio.

Here's a simple example:


This comes close to the rule of thumb as mentioned by AEGON:

10% mortality improvement adds one year to life expectancy, and one year of life expectancy adds 4% to the required value of a pension fund’s reserves

Conclusion
From the above presented visual sensitivity analysis we may conclude that for general (distributed) portfolio's a 'one year lifetime increase' will demand approximately 4-5% of the actual liabilities.

A three to four months yearly longevity-increase - as is still the actual trend - will therefore demand roughly a substantial 1,5% (yearly) of the liabilities.
This implies that in case your contribution is calculated at 4% and your average portfolio return is 7%, there's 3% left for financing longevity and indexation (=method). As 'longevity growth' in the near future will probably cost about 1,5%, there's  only 1,5% left for indexation on the long run.


Case closed


Related links:
Spreadsheet (xls) with data used in this blog
- Forecasting longevity of Dutch pension scheme members using postcodes
- Increasing life expectancy at pension funds (uvt;2011)
- Life Tables for the United States Social Security Area 1900-2100
- Valuing Pension Fund Liabilities on the Balance Sheet
- No limits to life expectancy?
- Broken Limits to Life Expectancy
- NRC: Explaining divergent levels of longevity (pdf;2011)
- Wolfram Alpha: Longevity U.S.
- AEGON: Longevity Rule of thumb

May 25, 2011

Google Hits on Actuary

Google can be a great help for actuaries. Especially 'Google Insights' and 'Google Trends' are two useful applications for retrieving relative Google Search Hits data from the Internet.

Google Insights Example
Let's dive a little deeper into Google Insights and start with researching the relative development of the number of hits on the word 'Actuary'.
Here is the result (period 2004-2011-May, extracted csv-file, Excel-Graph):


Explanation
The numbers on the graph reflect how many searches have been done for a particular term (e.g. 'Actuary'), relative to the total number of searches done on Google over time. They don't represent absolute search volume numbers, because the data is normalized and presented on a scale from 0-100. Each point on the graph is divided by the highest point, or 100.

Conclusion
Clear is that the search for (the word) actuary is relatively declining from 2004 to May 2011.

To keep the actuarial profession virtually alive we'll need to make more noise as actuaries on the Internet.

Step outside, spread the (acturial) word, make yourself visible in the outer world and let people wonder:  'who's that?',  'what a professional', 'what's his job?', 'Actuary?', 'I will google it!'.

So let's Twitter and Blog to get more actuarial exposure...


Actual Data
Apart from generating these kind of relative time-data, Google Insights can generate actual data anywhere on any web-application or presentation.

This way your data will always be up to date!
Moreover Google Insights is easy to handle without any code knowledge.....


Some examples....

(1) Actual relative development of the number of hits on the word 'Actuary'


(2) Top searches and rising searches on Google for the word 'Actuary'

More applications
The next example shows how you may use Google Highlights as a market crash predictor.  


It turns out that in advance of the 2008 market crash, Google searches on "Stock market crash" increased...

Make you own discoveries, highlights or trends (e.g 'Solvency II') and enjoy!


Related Links:
- Actuaries on Twitter
- Google Insights 
- S&P 500 Data 
- How Google Trends and Internet Searches Correlate with Asset Prices
- Google trends: 21 May 2011: End of the world, predicted by Harold Camping