Nov 10, 2011

How to catch Risk?

Desperate attempts to catch Risk in new regulatory standards like Basel (II/III) for banks and Solvency (II) for insurers seem a dead end street....

What is happening?

That's the question we're about to answer in this blog!

Here are some observations:
  • Risk Weighting
    All new risk valuating standards are based on Risk Weighting. Some assets (or liabilities) are assumed to be more risky than others. In practice, every asset class that has been identified as more or less 'safe', has turned out to be risky after all. E.G., government bonds  where - until the 2011 crisis  in Greece - assumed to be risk free. Unfortunately, nothing could be further from the truth...

    Nothing in life is risk free
  • Tier Ratio's
    Instead of simple 'Equity to Asset Ratios', Tier 1 & 2 ratios where developed. These Tier ratios only take a fraction of the total assets into account. This leads to 'Equity to Risk-Weighted Assets Ratios' that insinuate adequate, substantial and reassuring 10-15% Capital ratios, while - in fact - they're not! These kind of ratios are misleading and create a false sense of safety....

    Tier Ratios lead people up the garden path

  • Tail Hide and Seek
    As more and more risks are valued, regulated and urge for extra capital requirements, financial institutions will try to create extra return on risks that are formally not or only 'light weighted' measured. This way substantial risks are 'pushed' into the tail, fat risk tails are created and the sight on the real risks in the company becomes misty.

    Overregulation decreases the effect of good risk management

Illustration: Comparison 'Deutsche Bank' - 'Bank of America'
To illustrate what is happening, let's compare a giant like "Deutsche Bank" (DB) with the number one on the banking list, the "Bank of America" (BOA).


Financial RatiosDeutsche BankBank of America
(x 1 bn $)              Year:2010200920102009
Assets (A)1906150122652230
Liabilities (L)1855146320371999
Shareholder Equity (SE)4937228231
SE / A - Ratio2.6%2.4%10.1%10.4%
---------------------------------
Risk-Weighted Assets (RWA)34627314561543
Assets (A)1906150122652230
RWA / A - Ratio18%18%64%69%
---------------------------------
Regulatory Capital (RC)4938230226
Risk-Weighted Assets (RWA)34627314561543
Total Capital Ratio 14.1%13.9%15.8%14.7%
---------------------------------
Tier 1 capital4334164160
Risk-Weighted Assets (RWA)34627314561543
Tier 1 Capital Ratio12.3%12.6%11.2%10.4%




















Although both banks have more or less the same 'Tier 1' and 'Total Capital Ratio', their individual risk profile is completely different. 

In the case of DB only 18% of the assets are assumed (marked) risky, while in the case of BOA around 64% is assumed risky and taken into account for a risk weighted solvency approach.

Notice that the simple gross 'Equity to Asset' Ratio (E/A-Ratio, or in short 'EAR')  of DB is only 2.6%, while the similar ratio of BOA is around 10.1%. If DB would be hit by an 5% impact loss, it would be in deep trouble.


Reflections
Our risk models have become too sophisticated and don't cover the area of 'Unkown Risk' enough. Unintentionally rand controversially, risk regulations and models make us implicitly sweep our real risks under the carpet. In principle Risks can be categorized as:

  1. Known Risk Measured
  2. Known Risk Unmeasured
  3. Unknown Risk
  4. Hidden Risk (knowingly or unknowingly)

It's time to admit that no asset or liability is completely free of risk and there's an overall substantial probability that risk - by definition - will hit eventually from an unexpected corner. To put things in perspective: In the 19th century, banks funded their assets with around 40-50% equity.

Conclusion
Including 'Unkown Risk', a simple gross E/A-Ratio (EAR) of a magnitude of 15-25% (across the total assets) would probably be the best kind of guarantee to accomplish a more sustainable financial system in the world. The new EAR could be best defined as the sum of an actuarial underpinned percentage on basis of the underlaying calculable covered risks and a TBD overall 10% 'add up' for unknown risks:

E/A-Ratio = EAR =  EAR[ calculable risk ] + EAR[ unknown risk ]

Until we've included Unkown Risk fully in our risk models, we'll stay in deep trouble.

Aftermath: 'Avatar Ratios'
To rate a company (bank), often it's not enough to look at just the traditional financial ratios. An interesting way to additionally rate a company in a more sophisticated way, is with the help of so - by me - called 'Avatar Ratios'.


Additional to financial ratios, 'Avatar Ratios' tell you more about what the intentions, (real) important issues and the 'drive' of a company and its employees are.

An 'Avatar Ratio Analysis' gives you more or less 'the embodiment' of all what drives a company. It can be constructed by making a word analysis of a crucial document or annual report of a company. In short: You simply download the annual report (or any other company characteristic document) and analyze it with a  'Word Frequency Counter' like WriteWords.

IAA Demo
As a demo, let's analyze the IAA's Strategic Plan




FrequencyWord
21actuarial
10strategic
10develop
8associations
6standards
6priorities
6plans
6objective
6action
5promote
5profession
5member
5international
5iaa
5association
4practice
4maintain
4key
4global
4encourage
4education
3worldwide
3statement
3relationships
3plan
3including
3identify
3establish
3common
3discussion
2world
2values
2supranational
2support
2services
2risk
2relevant
2provide
2program
2professionalism
2professional
2prioritize
2principles
2organizations
2organization
2mission
2march
2management
2links
2issues
2internationale
2help
2fields
2facilitate
2countries
2contact
2conduct
2areas
2area
2approved
2among
2actuaries
2actuarielle
1voluntary
1vision
1understanding
1transparency
1traditional
1stakeholders
1soundness
1society
1social
1skills
1sections
1scope
1scientific
1role
1review
1research
1reputation
1relationship
1regional
1recommended
1recognized
1recognition
1quality
1public
1protection
1promotion
1process
1procedures
1presidents
1offered
1objectivity
1objectives
1needs
1model
1members
1knowledge
1jurisdictions
1involvement
1integrity
1improve
1guidelines
1forums
1forum
1financial
1feasibility
1experiences
1expansion
1examine
1ensure
1enhance
1disciplinary
1developing
1developed
1designation
1decisions
1decision
1credential
1create
1cooperation
1convergence
1contributing
1continuing
1constructing
1code
1changing
1availability
1audiences
1active
1achieve
1accountability
1access

With the help of WriteWords we first create (on line) a frequency table. Next we cut out irrelevant words like 'and', 'the', etc. 

Here are the results:
(1) a  scrollable frequency table of all relevant words
(2) a 'Top 22 words' frequency table



In most cases - like this one - the result of simply putting the first 10 to 15 words in the top of the frequency table behind each other, is astonishing: It creates a kind of 'Identity Statement'. Here's the result for IAA's strategic plan, where even more than 20 words give a beautiful comprised identity statement:

IAA's Strategic Plan (Identity Statement comprised with WriteWords)
Actuarial strategic develop associations. Standards, priorities plans objective action. Promote profession member international. IAA association practice maintain key. Global encourage education worldwide.

Avatar Analysis: Comparison 'Deutsche Bank' - 'Bank of America' 
Let's now go back to our banking case and compare 'Deutsche Bank' (DB) and the 'Bank of America' (BOA) with the help of a simple Avatar Ratio Analysis.

The Avatar Ratio Analys presents the word frequency (absolute numbers) and their relative frequency (= word frequency / total number of word in document). Here is the result:


Avatar RatiosDeutsche BankBank of America
Freq.Perc.
Freq.Perc.
Governance1090.06%250.02%
Risk14580.79%8520.53%
Control2730.15%1560.10%
Total G+R+C18401.00%10330.64%
------------------
Client/Customer3590.20%2500.15%
Shareholder1690.09%1620.10%
------------------
Transparent150.01%20.00%
------------------
Employee1530.08%630.04%
Director400.02%230.01%
------------------
Profit, Income10010.54%8350.52%
------------------
Tot. nr. of words161579100%184048100%


Although I'll leave the final conclusions up to you, here are some remarkable observations:
  • Total number of words
    Both companies (DB and BOA) need an enormous amount of words to explain their environment (clients, shareholders, rating agencies, etc) the essentials about what's going on in their company in a modest calendar year.

    To read an annual report of about 170,000 words, it would take an average reader (reading speed 200 to 250 words per minute) about 10-12 hours.

    Perhaps you, as an actuary, can read faster ( test it!: speed reading test ), but even at a speed of 500 wpm it would be an enormous task (5-6 hours) to fulfill.

  • Governance, Risk & Control
    It's clear that DB puts much more energy (+60%) in communicating about themes as Governance Risk and Control than BOA. Also is clear that DB is far more transparent in its communication than BOA. This does (of course) not imply that BOA's risk and control frame is inferior to DB's. It could even be the opposite. It just shows that (and how) BOA handles and communicates differently (less open) from DB.

  • Profit, Income, Shareholders + Clients and Employees
    DB and BOA weight Profit, Income and shareholders on more or less the same level. Both rank client/customer above shareholders. DB gives 'clients/customers' as well as employees double the attention of BOA!

At last
Next time you report to your board, include an Avatar Analysis of your report in your presentation!

Related Links, Sources:
- The biggest weakness of Basel III (2010)
- The Banker top 1000 list (2011) 
- Word Frequency Counter : WriteWords
- IAA's Strategic Plan  
- Bank of America: Annual Report 2010
- Deutsche Bank: Annual report 2010
- On line speed reading test 
- Spreadsheet containing this blog's DB and BOA analysis

Nov 1, 2011

Sustainable Discount Rates

Steering pension funds on a 'one point' Coverage Ratio is like trying to proof global warming on a hot summer day...... It's useless.

Why?

First of all the complete pension fund balance sheet is based on market value.

As there is no substantial market for pension liabilities, this implies that pension liabilities have to be valued on basis of some kind of arbitrary (artificial) method.

In the U.S. this has led to the (irresponsible) high discount rate of 8% for state pension funds based on the 'expected' long term return without a kind of correction (subtraction) for 'risk'.

In de Dutch market, pension funds have to rate their liabilities on basis of a maturity dependable risk free interest rate, the ‘Nominal interest Rate Term Structure’ (RTS), as ordered by DNB (the Dutch Regulator).

Here's the outcome of this risk free interest rate (RTS) over the past 10 years, including the 10-y average RTS...


Ever since DNB ordered this 'artificial discounting method', pension fund board members didn't get a good night sleep. As the RTS juggles on a daily basis, every morning pension members wake up with the latest 'RTS news surprise of the day'.

You can play the RTS juggle (worm) here:


As coverage ratios are based on the RTS, they shuttle hither and thither as well and executing a long term pension fund strategy becomes more or less like riding the famous (market) bull in a rodeo show.

On a Dutch IPE congress, Angelien Kemna - chief investment officer of the €270bn asset manager APG - warned that the current swap-curve discount criterion forces pension funds to take unwise "significant long-term measures".

Kemna favors an average yield curve or a more straightened version of the current one for discounting liabilities.

The new Dutch Pensions Agreement foresees that pension funds can choose their own discount rate, as pensions are no longer guaranteed!

Indeed, it's time to stop this complex discount circus. But it's also time to stop 'one point estimate' Coverage Ratio steering.

A new look
Let's take a look at a characteristic discount rate dependence of a traditional pension fund like ABP.



Valuing ABP at an (derived average) RTS of 2.69%  (September 2011), ABP's discounted assets fail to meet the discounted liabilities, leading to a coverage ratio of around 90%.

However this kind of risk free valuing is - for sure - too conservative, as ABP's aims at an underpinned strategic expected return of 6,1% on the long term and has a convincing track record of  5 and 10-year moving average returns:

Returns (%) Pension Fund ABP 2993-2010
Year199319941995199619971998199920002001200220032004200520062007200820092010
Yearly Return16.5-1.016.411.811.912.910.03.2-0.7-7.211.011.512.89.53.8-20.220.213.5

5Y MA Return
10.910.212.69.97.33.43.03.35.27.29.72.74.24.4

10Y MA Return
7.16.67.87.57.36.52.93.84.8

Or in Graphics:

As long as a pension fund (like ABP) continues to perform (on 5 or 10-years moving average) rates that outperform the (derived average) risk free discount rate, it's seems ridiculous to force such a pension fund to discount at a 'risk free rate', as this obliges the fund to change his strategic asset mix to a less risky mix and an suboptimal return.
In turn, these suboptimal returns will lead to an asset shortage. With a vicious cycle of decreasing risk as a fatal result in the end.

Sustainable Discount Rates
In an excellent discussion paper (2006) Jürg Tobler-Oswald proves that the optimal discount rate lies between the risk free rate (RFR) and the investment strategy’s expected return (ER) depending on how good the hedge against the fund’s cash  flow  provided by its investments  is:

Discount Rate1 = RFR + FCash Flow(RFR-ER)

Another - more simple and practible - discount rate could be defined as the average between the free discount rate and the X-year (e.g. X=5, or 10) Moving Average Return of the last X-Years (MAR(X)).

Discount Rate2 = [ RFR + MAR(X) ] /2

As long as MAR(10), MAR(5) and ER stay larger than the interest rate that matches a coverage ratio of 100%, discounting by means of one of the new sustainable discount methods seems sound and safe......

Whats left is that the average (geometric) risk premiums during the last 10 years have turned out negative:

Historical Equity Risk Premiums (ERP)
ERP: Stocks minus T.BillsERP: Stocks minus T.Bonds
PeriodArithmetic Geometric Arithmetic Geometric
1928-20107.62%5.67%6.03%4.31%
1960-20105.83%4.44%4.13%3.09%
2000-20101.37%-0.79%-2.26%-4.11%

This implies (moreover) that it is important that the discounting rate of a pension fund should be based on a sustainable sound weighted mix of:
(1) proven historical performance
(2) a 'save' risk free rate
(3) realistic future return assumptions


Related Links/ Sources
- Kemna IPE article (2011)
- An investment based valuation approach for pension fund cash flows (2006)
- Ignoring the risk in risk premium in State Pensions(2011)
- DB: What went wrong? (2011)
- Actuary.org: Pension Fund Valuation and Market Values (2000)
- Aswath Damodaran: Equity-risk-premiums-2011-edition
- Dutch: ABP coverage ratio

Oct 23, 2011

What's a Greek Tragedy?

As actuaries we do not believe in miracles, or do we?

According to a 'strictly confidential' document from the Troika (= EC, IMF & ECB), Greek's Debt/GDP ratio suddenly raised from 149% to 186% in 2013!

This new insight causes a 'potential need for additional official financing' ranging up to €440 billion!! (are you still with me?)

Let's take a look at how Debt/GDP ratio developed in the past and the new optimistic Troika forecast (red line).


Just to help the Troika, I've added a non-miracle 'Maggid' forecast based on simple and more realistic economic principles.

Not a word in the Troika report about the drivers and cultural changes that are necessary to achieve a long term decrease of the Debt/GDP ratio. Everything is based on  suggestive mathematical art.

Continue throwing good money after bad, is not the way forward. Greece will first have to show that it is not only willing, but also achieving debt reduction. Current measures are insufficient. Start for example to raise retirement age to 65 as a beginning...



Let's pray European leaders give up Keynesian miracle thinking and take the right decision:

Stop helping Greece to finance their debt, unless Greece shows strong progress in reducing debt itself every month .

If not.., the line 'A Greek Tragedy' will get a new meaning....

Sources/Links:
- Troika report
- Zerohedge: Greece
- Retirement around the globe blog

Oct 14, 2011

Humor: Actuary Scrooge

Today's Brainer:What's the difference between a pension fund and an investment fund?

Actuary $crooge shows...



source

Oct 9, 2011

On Line DIY European Stress Test

Thomson Reuters' Breakingviews now presents an on line DIY stress test. Change the Tier 1 ratio and haircuts of the PIIGS countries and find out the capital shortfall of Europe and the shortfal of individual European banks.

An explanation can be found here and there is also an Excel spreadsheet.


Enjoy stress testing!

Oct 8, 2011

What's a world without Jobs?

On Wednesday night 5th October, Apple co-founder, former CEO and chairman Steve Jobs, passed away..



Steve Jobs' life is an example to all of us. In an excellent and catching speech, Steve urged graduates to pursue their dreams and pick up the opportunities in life's setbacks at the university's 114th Commencement on June 12, 2005.



What - besides Steve's phenomenal contributions to computer technology and marketing - did Steve contribute to the profession of Risk Management?

Steve Jobs' Risk Management Lessons
Here are (derived from his 2005 Stanford speech) some inspiring lessons from Steve. Lessons we can apply 'one to one' on Risk Management (my comments in Italic):


  • Connect 'the dots' in life
    It's impossible to connect the dots looking forward,you can only connect them looking backwards, later in life.  Do so!

    To turn Risk Management into an opportunity, we can't look in a crystal ball. We'll have to explore and have to allow ourselves some experiments and non-conventional ideas to finally see the bigger picture that turns marginal new business developments into one new final integral success!

    Try to develop 'Risk Oversight' (connecting the dots) as Risk Oversight is negatively related to risk and positively related to shareholder value (Research Stanford University).


  • Trust
    You have to trust that the dots will somehow connect in your future.
    Believe in something and follow your heart, even if it leads you of the well-worn path..

    Make Risk management supportive and not dominant to what you want to achieve in life or business. It's positive when  companies Ideas and Vision sometimes conflict with inner and outer notions.

    To grow a plant (company)  in soil (society) is takes opposite 'nutrients' (and circumstances) like water and sun that feed your seed (idea).



    Accept that your heart, gut feeling and helicopter view are sometimes more leading than the rationale of your Risk management (what your brain thinks). The more and the longer you are able to manage this paradox, the more likely success will come your way eventually. 

    Keep all the above decision elements in ('a paradoxical') place. Remember  Shareholder Value and Sustainability are a function of Risk, so don't pull the plug too soon!


  • Love and Loss
    Making mistakes is an inherent part of life and doing business.

    If you (or something you started) fails, start over!

    The effect of less sureness by 'starting over', inspires for exploring new directions and becoming creative again.

    'Love what you do' is the most important leading statement to proceed in life and business.

    'Sometimes life hits you with a brick'. Don’t lose faith.Your time is limited, so don’t waste it living someone else’s life.

    Risk Management exists by the grace of losses that occur. Accept that as a fact. Therefore, if no losses occur anymore, your Risk Management program is actually dead without a clue. It will certainly fail eventually.

    Getting knocked down by a 'brick' like in the current financial crisis, is a sign that we have to redesign our Risk Management programs instead of intensifying existing programs like Basel II /III and Solvency II. Get out!

    New Risk Management will have to focus on how to prevent and to DEAL with risk, instead of sophisticated capitalizing risk as Dead Risk Capital. Rather than focus on reducing risk, risk-transformation — that is, capitalizing risk in such a way that its value creation potential is maximized - seems the right way forward.


  • Death
    If you live each day as if it was your last, someday you'll most certainly be right. Remembering you'll die is the most important tool to help you make the big choices in life. Because almost everything — all external expectations, all pride, all fear of embarrassment or failure - these things just fall away in the face of death, leaving only what is truly important.

    Remembering that you are going to die is the best way to avoid the trap of thinking you have something to lose.


    Risk Management is about making choices and giving up less important issues for more important.
    It's about generating focus on what really matters for sustainability or results, instead of trying to manage everything.

    Good Risk management therefore urges for CEO and Board rewards that reflect the downside risk of a company's default instead of just rewarding upward and short term profit.

    Company bonuses should therefore be positive as well as negative performance related.  

 Remember, just like Steve Jobs, Risk Management is about 'failing better than anyone else' .....


Related/Sources:
- Steve Jobs: He Thinks Different (2004)
- Was Steve Jobs Practicing Proactive Risk Management? (2010)
- The Role of the Board in Corporate Risk Oversight (Stanford University 2010)
- Dead Risk Capital

Sep 29, 2011

Pension Gamification

For years you deny it, then you doubt it, then you know for sure:



This blog is specially written for (1) those who are still in the denial phase and (2) 'actuarial life gamers' who just want to enjoy actuarial gaming....

Pension Game
Games are an excellent way to involve people (employees) in a complex and (two fold)  'low interest product' like pension.


Pension games stimulate clear communication and understanding of pensions (The Nest Phrasebook:Clear communication about pensions Version 1.1).

Games, like the above pension game, conquer the world more and more.

Gamification
It looks like everything that has to be sold or communicated, succeeds better with the help of a game. Gamification gets people more engaged, helps change behaviors and stimulates innovation. In other words:

Gamification rules our life

As an example of gamification, Gartner cited the U.K.’s Department for Work and Pensions, which created an innovation game called Idea Street to decentralize innovation and generate ideas from its 120,000 people across the organization. Idea Street is a social collaboration platform with the addition of game mechanics, including points, leaderboards and a “buzz index.”

The employees went wild for it. Within 18 months, Idea Street had approximately 4,500 users and had generated 1,400 ideas, 63 of which had gone forward to implementation.

Other gamification examples are the U.S. military’s “America’s Army” video-game recruiting tool, and the World Bank-sponsored Evoke game, which crowdsources ideas from players globally to solve social challenges.

All and more of this in the 2011 report of  Gartner that states that by 2015, more than 50% of organizations tat manage innovation processes will gamify those processes.

Consequences
Mainly as a consequence of the overdose of gamification in our society, people get confused and lose sight on the difference between reality and illusion. 

This confusion is exacerbated by the fact that negative effects of the current financial crisis have been 'managed away' in stead of letting people and organizations 'perceive' and 'experience' the (negative) financial consequences of their handling.



The 'Hocus Pocus Society'
This way, we gradually created a 'Hocus Pocus Society' where all our (actuarial) models and convictions are doomed to fail as the 'game of life' seems to be to:
  • challenge the established (good governance) rules to raise profit and returns to an unrealistic level, by introducing uncontrolled and uncontrollable mechanisms and financial instruments like 'market value', 'derivatives', 'sub-prime mortgages', 'High Frequency Trading', etc.
  • try - at the same time - to capture and control these volatile 'unwanted' effects of these mechanisms and instruments by an overdose of hypocritical additional regulation (Solvency (II), Governance, etc.)
  • transfer and lay back fundamental complex risk to consumers and communicating this in such a (so called) 'transparent' but oversimplified 'way', that consumers for sure lose their trust in financial institutions as a whole.
  • end up in new, for the financial institutions, 99,9% risk free financial products and offerings on the marketplace with a non corresponding stock holders dividend level.



This illusory way of communication about pensions is well demonstrated in the next 'Pension game' video: The myth of your (401K) pension





Way out
To get out of this down spiral cycle in the fiancial industry, we'll have to learn from other industries.

Just like in the case of introducing new medicines , new financial products will have to meet a number of tests and need explicit approval by in and external regulators before they are allowed to be  introduced on the market place.

Anyhow: Don't end up like a 'Hocus Pocus Actuary' and game up your actuarial life!



Related and additional links:
- Idea Street
- Gartner: Over 50% firms may gamify processes 
- Youtube: The Pension Game
- The Annuity Game - Heads Government Wins Tails Pensioner's Lose
- 5 Cent "Old Age Pension" Dice Game 


Calculators:
- life expectancy calculator
- Retirement Withdrawal Calculator






Sep 26, 2011

Small Population Compliance Samples

My last post, Compliance Sample Size, demonstrated the set up of an efficient sample method for compliance tests in case of large populations.

What if population size is relatively small ?, some actuaries asked me....

In this case you can ( instead of the beta distribution) make use of the hypergeometric distribution for calculating confidence levels.

Here's the same example as I used in my blog 'Compliance Sample Size', but now for a population of 100 .


'Compliance Check' Example (N=100)
As you probably know, pension advisors have to be compliant and  meet strict federal, state and local regulations.

On behave of the employee, the sponsoring employer as well as the insurer or pension fund, all have a strong interest that the involved 'Pension Advisor' actually is, acts and remains compliant.

PensionAdvice
A professional local Pension Advisor firm, 'PensionAdvice' (fictitious name), wants 'compliance' to become a 'calling card' for  their company. Target is that 'compliance' will become a competitive advantage over its rivals.

You, as an actuary, are asked to advise on the issue of how to verify PensionAdvice's compliance....... What to do?

  • Step 1 : Compliance Definition
    First you ask the board of PensionAdvice  what compliance means.
    After several discussions compliance is in short defined as:

    1. Compliance Quality
      Meeting the regulator's (12 step)  legal compliance requirements
      ('Quality Advice Second Pillar Pension')

    2. Compliance Quantity
      A 100% compliance target of PensionAdvice's portfolio, with a 5% non-compliance rate (error rate) as a maximum on basis of a 95% confidence level.
    .
  • Step 2: Check on the prior believes of management
    On basis of earlier experiences, management estimates the actual NonCompliance rate at 8% with 90% confidence that the actual NonCompliance rate is 8% or less:

    If management would have no idea at all, or if you would not (like to) include management opinion, simply estimate both (NonCompliance rate and confidence) at 50% (= indifferent) in your model.

  • Step 3: Define Management Objectives
    After some discussion, management defines the (target) Maximum acceptable NonCompliance rate at 5% with a 95% confidence level (=CL).

  • Step 4: Define population size
    In this case it's simple. PensionAdvice management knows for sure the portfolio they want to check for compliance, consists of 100 files: N=100.

    This is how step 2 to 4 look in your spreadsheet...



  • Step 5 : Define Sample Size
    Now we get to the testing part....

    Before you start sampling, please notice how prior believes of management are rendered into a fictitious sample (test number = 0) in the model:
  • In this case prior believes match a fictitious sample of size 25 with zero noncompliance observations. 
  • This fictitious sample corresponds to a confidence level of 77% on basis of a maximum (population) noncompliance rate of 5%.
[ If you think the rendering is to optimistic, you can change the fictitious number of noncompliance observations from zero into 1, 2 or another number (examine in the spreadsheet what happens and play around).]


To lift the 77% confidence level to 95%, it would take an additional sample size of 20 - with zero noncompliance outcomes (you can check this in the spreadsheet).
As sampling is expensive, your employee Jos runs a first test (test 1) with a sample size of 10 with zero noncompliance outcomes. This looks promising!
The cumulative confidence level has risen from 76% to over 89%.


You decide to take another limited sample with a sample size of 10. Unfortunately this sample contains one noncompliant outcome. As a result, the cumulative confidence level drops to almost 75% and another sample of size 20 with zero noncompliant outcomes is necessary to reach the desired 95% confidence level.

You decide to go on and after a few other tests you finally arrive at the intended 95%cumulative confidence level. Mission succeeded!

Evaluation
The interesting aspects of this method are:

  1. Prior (weak or small) samples or beliefs about the true error rate and confidence levels, can be added in the model in the form of an (artificial) additional (pre)sample.

  2. As the sample size increases, it becomes clear whether  the defined confidence level will be met or not and if adding more samples is appropriate and/or cost effective.
This way unnecessary samples are avoided, sampling becomes as cost effective as possible and auditor and client can dynamically develop a grip on the distribution. Enough talk, let's demonstrate how this works.

Another great advantage of this incremental sampling method is that if noncompliance shows up in an early stage, you can
  • stop sampling, without having made major sampling cost
  • Improve compliance of the population by means of additional measures on basis of the learnings from the noncompliant outcomes
  • start sampling again (from the start) 

If - for example -  test 1 would have had 3 noncompliant outcomes instead of zero, it would take an additional test of size 57 with zero noncompliant outcomes tot achieve a 95% confidence level.  It's clear that in this case it's better to first learn from the 3 noncompliant outomes, what's wrong or needs improvement, than to go on with expensive sampling against your better judgment.


D. Conclusions
On basis of a prior believe that - with 90% confidence - the population is  8% noncompliant, we can now conclude that after an additional total sample of size 40, PensionAdvice's noncompliance rate is 5% or less with a 95% confidence level.

If we want to be 95% sure without 'prior believe', we'll have to take an additional sample of size 25 with zero noncompliant outcomes as a result.

E. Check out: DOWNLOAD EXCEL

You can download the next Excel spreadsheets to check the Demo or tot set up your own compliance test:

- Small population Compliance test DEMO
- Small population Compliance test BLANK
- Large population Compliance test

Enjoy!

Sep 25, 2011

Compliance: Sample Size

How to set an adequate sample size in case of a compliance check?

This simple question has ultimately a simple answer, but can become a "mer à boire" (nightmare) in case of a 'classic' sample size approach.....

In my last-but-one blog called 'Pisa or Actuarial Compliant?', I already stressed the importance of checking compliance in the actuarial work field.

Not only from a actuarial perspective compliance is important, but also from a core business viewpoint:

Compliance is the main key driver for sustainable business

Minimizing Total Cost by Compliance
A short illustration: We all know that compliance cost are a part of Quality Control Cost (QC Cost) and that the cost of NonCompliance (NC Cost) increase with the noncompliance rate. 

Mainly 'NC cost' relate to:
  • Penalties or administrative fines of the (legal) regulators
  • Extra  cost of complaint handling
  • Client claims
  • Extra administrative cost 
  • Cost of legal procedures

Sampling costs - on their turn -  are a (substantial) part of QC cost.

More in general now it's the art of  good practice compliance management, to determine that level of maximal noncompliance rate, that minimizes the total cost of a company.



Although this approach is more or less standard, in practice companies revenues depend strongly on the level of compliance. In other words: If compliance increases, revenues increase and variable costs decrease.

This implies that introducing 'cost driven compliance management' - in general - will (1) reduce  the total cost and (2) mostly make room for additional investments in 'QC Cost' to improve compliance and to lower variable and total cost.

In practice you'll probably have to calibrate (together with other QC investment costs) to find the optimal cost (investment) level that minimizes the total cost as a percentage of the revenues.


As is clear, modeling this kind of stuff is no work for amateurs. It's real risk management crafts-work. After all, the effect of cost investments is not sure and depends on all kind o probabilities and circumstances that need to be carefully modeled and calibrated.

From this more meta perspective view, let's descend to the next down to earth 'real life example'.

'Compliance Check' Example
As you probably know, pension advisors have to be compliant and  meet strict federal, state and local regulations.

On behave of the employee, the sponsoring employer as well as the insurer or pension fund, all have a strong interest that the involved 'Pension Advisor' actually is, acts and remains compliant.

PensionAdvice
A professional local Pension Advisor firm, 'PensionAdvice' (fictitious name), wants 'compliance' to become a 'calling card' for  their company. Target is that 'compliance' will become a competitive advantage over its rivals.

You, as an actuary, are asked to advise on the issue of how to verify PensionAdvice's compliance....... What to do?


  • Step 1 : Compliance Definition
    First you ask the board of PensionAdvice  what compliance means.
    After several discussions compliance is in short defined as:

    1. Compliance Quality
      Meeting the regulator's (12 step)  legal compliance requirements
      ('Quality Advice Second Pillar Pension')

    2. Compliance Quantity
      A 100% compliance target of PensionAdvice's portfolio, with a 5% non-compliance rate (error rate) as a maximum on basis of a 95% confidence level.

    The board has no idea about the (f)actual level of compliance. Compliance was- until now - not addressed on a more detailed employer dossier level.
    Therefore you decide to start with a simple sample approach.

  • Step 2 : Define Sample Size
    In order to define the right sample size, portfolio size is important.
    After a quick call PensionAdvice gives you a rough estimate of their portfolio: around 2.500 employer pension dossiers.

    You pick up your 'sample table spreadsheet' and are confronted with the first serious issue.
    An adequate sample (95% confidence level) would urge a minimum of 334 samples. With around 10-20 hours research per dossiers, the costs of this size of this sampling project would get way out of hand and become unacceptable as they would raise the total cost of  PensionAdvice (check this, before you conclude so!).

    Lowering confidence level doesn't solve the problem either. Sample sizes of 100 and more are still too costly and confidence levels of less than 95% are of no value in relation to the clients ambition (compliance= calling card).
    The same goes for higher - more than 5% - 'Error Tolerance' .....

    By the way, in case of samples for small populations things will not turn out better. To achieve relevant confidence levels (>95%) and error tolerances (<5%), samples must have a substantial size in relation to the population size.


    You can check all this out 'live', on the next spreadsheet to modify sampling conditions to your own needs. If you don't know the variability of the population, use a 'safe' variability of 50%. Click 'Sample Size II' for modeling the sample size of PensionAdvice.



  • Step 3: Use Bayesian Sample Model
    The above standard approach of sampling could deliver smaller samples if we would be sure of a low variability.

    Unfortunately we (often) do not know the variability upfront.

    Here comes the help of a method based on efficient sampling and Bayesian statistics, as clearly described by Matthew Leitch.

    A more simplified version of Leitch's approach is based on the Laplace's famous  'Rule of succession', a classic application of the beta distribution ( Technical explanation (click) ).

    The interesting aspects of this method are:
    1. Prior (weak or small) samples or beliefs about the true error rate and confidence levels, can be added in the model in the form of an (artificial) additional (pre)sample.

    2. As the sample size increases, it becomes clear whether  the defined confidence level will be met or not and if adding more samples is appropriate and/or cost effective.
  • This way unnecessary samples are avoided, sampling becomes as cost effective as possible and auditor and client can dynamically develop a grip on the distribution. Enough talk, let's demonstrate how this works.

Sample Demonstration
The next sample is contained in an Excel spreadsheet that you can download and that is presented in a simplified  spreadsheet at the end of this blog. You can modify this spreadsheet (on line !) to your own needs and use it for real life compliance sampling. Use it with care in case of small populations (n<100).

A. Check on the prior believes of management
Management estimates the actual NonCompliance rate at 8% with 90% confidence that the actual NonCompliance rate is 8% or less:



If management would have no idea at all, or if you would not (like to) include management opinion, simply estimate both (NonCompliance rate and confidence) at 50% (= indifferent) in your model.

B. Define Management Objectives
After some discussion, management defines the (target) Maximum acceptable NonCompliance rate at 5% with a 95% confidence level (=CL)



C. Start ampling
Before you start sampling, please notice how prior believes of management are rendered into a fictitious sample (test number = 0) in the model:
  • In this case prior believes match a fictitious sample of size 27 with zero noncompliance observations. 
  • This fictitious sample corresponds to a confidence level of 76% on basis of a maximum (population) noncompliance rate of 5%.
[ If you think the rendering is to optimistic, you can change the fictitious number of noncompliance observations from zero into 1, 2 or another number (examine in the spreadsheet what happens and play around).]

To lift the 76% confidence level to 95%, it would take an additional sample size of 31 with zero noncompliance outcomes (you can check this in the spreadsheet).
As sampling is expensive, your employee Jos runs a first test (test 1) with a sample size of 10 with zero noncompliance outcomes. This looks promising!
The cumulative confidence level has risen from 76% to over 85%.



You decide to take another limited sample with a sample size of 10. Unfortunately this sample contains one noncompliant outcome. As a result, the cumulative confidence level drops to almost 70% and another sample of size 45 with zero noncompliant outcomes is necessary to reach the desired 95% confidence level.

You decide to go on and after a few other tests you finally arrive at the intended 95%cumulative confidence level. Mission succeeded!



The great advantage of this incremental sampling method is that if noncompliance shows up in an early stage, you can
  • stop sampling, without having made major sampling cost
  • Improve compliance of the population by means of additional measures on basis of the learnings from the noncompliant outcomes
  • start sampling again (from the start) 

If - for example -  test 1 would have had 3 noncompliant outcomes instead of zero, it would take an additional test of size 115 with zero noncompliant outcomes tot achieve a 95% confidence level.  It's clear that in this case it's better to first learn from the 3 noncompliant outomes, what's wrong or needs improvement, than to go on with expensive sampling against your better judgment.



D. Conclusions
On basis of a prior believe that - with 90% confidence - the population is  8% noncompliant, we can now conclude that after an additional total sample of size 65, PensionAdvice's noncompliance rate is 5% or less with a 95% confidence level.

If we want to be 95% sure without 'prior believe', we'll have to take an additional sample of size 27 with zero noncompliant outcomes as a result.

E. Check out

Check out, download the next spreadsheet. Modify sampling conditions to your own needs and download the Excel spreadsheet.


Finally
Excuses for this much too long blog. I hope I've succeeded in keeping your attention....


Related links / Resources

I. Download official Maggid Excel spreadsheets:
- Dynamic Compliance Sampling (2011)
- Small Sample Size Calculator

II. Related links/ Sources:
- 'Efficient Sampling' spreadsheet by Matthew Leitch
- What Is The Right Sample Size For A Survey?
- Sample Size
- Epidemiology
- Probability of adverse events that have not yet occurred
- Progressive Sampling (Pdf)
- The True Cost of Compliance
- Bayesian modeling (ppt)

Sep 12, 2011

Pisa or Actuarial Compliant?

When we talk about actuarial compliance, we usually limit this to our strict actuarial work field.
In a broader sense as 'risk managers', we (actuaries) have a more general responsibility for the sustainability of the company we work for.

Compliance is not just about security, checks, controls, protection, preventing fraud, ethical behavior. Moreover  compliance is the basis of adequate risk management and delivering high standard service and products to your companies clients.

Pisa Compliant
No matter how brilliant and professional our calculations, if the data - on which these calculations are based on -  are 'limited', 'of insufficient quality' or 'too uncertain', we as actuaries will finally fail.

Therefore , building actuarial sandcastles is great art, however completely useless. Matthew 7:26 tells us :  it's a foolish man who builds his actuarial house on the sand....

And so, let's take a look if we have indeed become 'Pisa Compliant' by checking if our actuarial compliance is build on sand or on solid ground. In other words: let's check if actuarial compliance itself is compliant...nd.

Actuarial Data Governance
To open discussion, let's start with some challenging Data Governance questions:

  • Data quality compliance
    How is 'data quality compliance' integrated in your actuarial daily work? Have you addressed this issue? And if so, do you just rely on statements and reports of others (auditors, etc), can you agree upon the data quality standards (if there are any). In other words: are the data, processes and reports you base you calculations on, 100%  reliable and guaranteed? If not, what's the actual confidence level of your data en do you report about this confidence level to the board?

  • Data quality Conformation
    Have you checked your calculation data  set on bases of samples or second opinions?

    And if so, do you approve with the methods used, the confidence level and the outcome of the data audit? 

    Or do you just 'trust' on the blue eyes of the accountant or auditor and formally state you're "paper compliant"?

    Did you check if  client information, e.g. pension benefit statement, are not only in line with the administrative data, but also in line with insurance policy conditions or pension scheme rules?

  • Up to date, In good time
    To what quantitative level is the administrative data  'up to date' and is it transparent?

    Do you receive administrative backlog and delays reporting and tracking and if so, how do you translate these findings in your calculations?

  • Outsourcing
    From a risk management perspective, have you formulated quantitative and qualitative demands (standards) in outsourced contracts, like 'asset management', 'underwriting'  and 'administration' contracts?

    Do you agree on these contracts, do 'outsourcing partners' report on these standards and do you check these reports regularly on a detail level (samples)? 

And some more questions you have to deal with as an actuary:
  • Distribution Compliance
    Is the intermediary and are the employers and customers your company deals with, compliant? What's the confidence level of this compliance and in  case of partially noncompliance, what could be the financial consequences? (Claims)

  • Communication Compliance
    Is communication with employees, customers, regulators, supervisors and shareholders compliant? Has your board (and you!) defined what compliance actually means in quantitative terms?

    Is 'communication compliance' based on information (delivery and check) or on communication?

    In this case, have you've also checked if  (e.g.) customers understood what you tried to tell them?

    Not by asking if your message was understood, but by quantitative methods (tests, polls, surveys, etc) that undisputed 'prove' the customer really understood the message.

    Effective Communication Practice
    Never ask if someone has understood what you've said or explained. Never take for granted someone tells you he or she 'got the picture'.

    Instead act as follows: At the end of every (board) presentation, ask that final and unique question of which the answer  assures you, your audience has really understood what your tried to bring across.

Checking Compliance
Now we get to the quantitative 'hard part' of compliance:

How to check compliance?

This interesting topic will be considered in my next blog.... ;-)

To lift a little corner of the veil, just a short practical tip to conclude this blog:

Compliance Sample Test
From a large portfolio you've taken a sample of 30 dossiers to check on data quality. All of them are found compliant. What's the upper limit of the noncompliance rate in case of a 95% confidence level?

This type of question is a typical case of:

“If nothing goes wrong, is everything alright?”

Answer.
The upper limit can be roughly estimated by a simple rule of thumb, called 'Rule of three'....



'Rule of three for compliance tests'
If no noncompliant events occurred in a compliance test sample of n cases, one may conclude with 95% confidence that the rate of  noncompliance will be less than  3/n.

In this case one can be roughly 95% sure the noncompliance rate is less than 10% (= 3/30). Interesting, but slightly disappointing, as we want to chase noncompliance rates in the order of 1%.

Working backwards on the rule of three, a 1% noncompliance rate would urge for samples of 300 or more. Despite the fact that research for 46 international organizations showed that on average, noncompliance cost is 2.65 times the cost of compliance, this size of samples is often (perceived as) too cost inefficient and not practicable.

Read my next blog to find out how to solve this issue....

Related Links:
- Actuarial Compliance Guidelines
- What Is The Right Sample Size For A Survey?
- Epidemiology
- Probability of adverse events that have not yet occurred
- The True Cost of Compliance (2011)
- 'Rule of three'
- Compliance testing: Sampling Plans (accounting standards) or Worddoc

Sep 9, 2011

Humor: Merkozy, It's too late

Comparing 5 year exchange rates USD/EUR (decline : 17%) and USD/CNY (decline 21%) clearly shows the negative outlook of the US Dollar.

Both U.S. and Europe, are facing severe debt problems they can not solve with more debt.

Desperate actions
President Obama tries to stimulate economy by creating 1.5 mln new jobs with a $ 450 billion investment (American Job Act).

In Europe president Merkel (Germany) and Sarkozy (France) have joint their strengths and totally different characters into 'one personality', to create not only a strong financial but also economic European union.

This new economic union is necessary to establish a firm grip on the measures that weak financial European countries like, Greece, Italy, Ireland, Spain and Portugal have to take to recover from their debt.

It's too late
Unfortunately there's no support for such an initiative. Unluckily, no Merkozy will be able to prevent Europe from a financial meltdown.
The  only way out seems a European split in relative strong and weak countries.

Make up your mind on the geographic spread of the assets of your company. Get out before it's too late....



Sep 7, 2011

Irrational Risk

Actuarial work is demanding..., so you're arriving late at your hotel that night. The hotel manager has only two rooms left. These two rooms are exactly the same, except for one aspect: The fire alarm.....


The manager tells you that in the event of a nighttime fire due to the usual causes, guests in Room 1, equipped with Alarm 1, have an actuarial calculated  2% chance of dying. Guests in Room 2, equipped with Alarm 2, have only a 1% chance of dying.

However - things in life are always complicated -  there's a slight problem.....

According to the manager...... The wiring of Alarm 2 is such that it sometimes causes electrical fires that increase the risk of dying in a nighttime fire by an additional 0.01%.

In other words, Alarm 1 is associated with a 2% risk of death and Alarm 2 is associated with a 1% + 0.01% (betrayal) risk of death.

What room do you choose as a professional actuary?

Outcome
According to a study by Gershoff and Koehler, most participants choose the room with Alarm 1. This,  even though this room 1 has double the increased risk of fire death, according the researchers. Reason: most participants found the tiny risk of "betrayal" (product malfunction) much more frightening than the much larger risk of actually dying.  When people get upset by a tiny risk, they often paradoxically choose the much larger risk.

Personally I think a more imaginable risk 'weighs' stronger than a non-specific abstract risk and in general people are unaware of conditional probability effects......

Conclusion
This simple example proofs that emotion has a strong influence on risk decisions.

Just like in our actuarial profession, risk decisions are often irrational.

It is our duty as actuaries to demystify and to rationalize risk. However, sometimes we're victim of the same emotional bias....




Read more about this interesting subject on:

- Vaccination and betrayal aversion (2011)
- Safety First? The Role of Emotion in Safety Product Betrayal Aversion (2011)