IFRS 17
Full valuation
This page records each step of the running example in the variable fee approach guide. It covers the CSM release schedule and the valuation, closing cash flows and analysis of change for all five years.
Example
CSM release schedule
| Line item | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| aCoverage units this yearFund at the start of the year + 1'000 × policies at the start of the year | 10'750'000 | 10'238'350 | 9'180'672 | 7'492'109 | 6'846'625 |
| bCoverage units in future yearsSame measure for each later year, expected, added up (row l in that year's cash flows on the closing basis) | 38'122'857 | 25'450'789 | 14'338'734 | 6'846'625 | – |
| cShare released this yeara ÷ (a + b) | 22.0% | 28.7% | 39.0% | 52.3% | 100.0% |
| dCSM before releaseAfter all other changes this year | 429'074 | 323'206 | 192'236 | 119'555 | 58'227 |
| eCSM released to profit or lossd × c | 94'378 | 92'720 | 75'038 | 62'468 | 58'227 |
Annual valuations
In each annual valuation table, each step changes one input. The analysis of change takes the difference between two steps. The BEL at step 0 equals the closing BEL of the prior year. The future BEL at step 5 equals the closing BEL.
In each annual analysis of change, the profit or loss on each line is the return on the fund minus the change in the liability.
Year 1: As expected
| Line item | How it is calculated | BEL incl. this year | BEL future years | RA incl. this year | RA future years |
|---|---|---|---|---|---|
| aStep 0: Opening valuation | Prior year-end basis, discounted to the start of the year | 9'323'232 | 8'698'463 | 10'192 | 7'765 |
| bStep 1: Move one year forward | Same cash flows, discounted to the year-end | 9'602'928 | 8'959'416 | 10'498 | 7'998 |
| cStep 2: Actual fund return | Year 1 return 3%, as expected | 9'602'928 | 8'959'416 | 10'498 | 7'998 |
| dStep 3: New interest rate | Rate 3% → 3% for discounting and future returns | 9'602'928 | 8'959'416 | 10'498 | 7'998 |
| eStep 4: Actual deaths and surrenders | Actual decrements this year | 9'602'928 | 8'959'416 | 10'498 | 7'998 |
| fStep 5: New assumptions | New best estimates for future years (no change this year) | 9'602'928 | 8'959'416 | 10'498 | 7'998 |
| Line item | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| aPolicies in force at startActual for this year | 1'000.00 | 940.00 | 883.60 | 830.58 | 780.75 |
| bOpening fundActual for this year | 9'750'000 | 9'298'350 | 8'867'623 | 8'456'849 | 8'065'102 |
| cFund returnb × return | 292'500 | 278'951 | 266'029 | 253'705 | 241'953 |
| dAMC to insurer−(b + c) × 1.5% | −150'638 | −143'660 | −137'005 | −130'658 | −124'606 |
| eDeathsa × mortality | 10.00 | 9.40 | 8.84 | 8.31 | 7.81 |
| fSurrendersa × surrender rate | 50.00 | 47.00 | 44.18 | 41.53 | – |
| gAccount values paidDeath + surrender + maturity | −593'512 | −566'018 | −539'798 | −514'794 | −8'182'449 |
| hDeath extra paide × 1'000 | −10'000 | −9'400 | −8'836 | −8'306 | −7'807 |
| iAdministration costsa × 40 | −40'000 | −37'600 | −35'344 | −33'223 | −31'230 |
| jDiscount factor at the year-end1 ÷ (1 + 3%) ^ years | 1.000000 | 0.970874 | 0.942596 | 0.915142 | 0.888487 |
| kPV of outflows(g + h + i) × j | −643'512 | −595'163 | −550'456 | −509'114 | −7'304'683 |
| lCoverage unitsb + 1'000 × a | 10'750'000 | 10'238'350 | 9'751'223 | 9'287'433 | 8'845'851 |
| Line item | Return on fund | BEL | RA | CSM | Liability | Profit |
|---|---|---|---|---|---|---|
| aOpening balanceInitial measurement: BEL, RA and CSM | 9'323'232 | 10'192 | 416'576 | 9'750'000 | ||
| bTime value at the opening rateFund: opening fund × opening rate. BEL and RA: unwind. CSM: fund − BEL − RA | 292'500 | 279'696 | 306 | 12'498 | 292'500 | – |
| cMarket: fund return differs from expectedFund: actual − expected return. BEL: revalue with actual fund. CSM: fund − BEL | – | – | – | – | – | – |
| dMarket: interest rate changeBEL and RA at the new rate. CSM: −(BEL + RA) | – | – | – | – | – | – |
| eClaims experience this year (death extra)Actual − expected death-extra payments | – | – | – | – | – | – |
| fActual deaths and surrenders: effect on future yearsBEL and RA for future years with the actual policies. The fund and the BEL fall together for the account values paid IFRS 17.B111. CSM: −(BEL + RA) | – | – | – | – | – | – |
| gAssumption change for future yearsBEL and RA on the new assumption. CSM: −(BEL + RA) | – | – | – | – | – | – |
| hRA release for this yearRA on this year's death-extra and costs | – | – | −2'500 | – | −2'500 | 2'500 |
| iCSM release for this yearCSM before release × coverage units this year ÷ all remaining coverage units | – | – | – | −94'378 | −94'378 | 94'378 |
| jCash paid at year-endActual benefits and costs paid. No profit effect | −643'512 | −643'512 | ||||
| kClosing balance and totals for the yearSum of a to j | 292'500 | 8'959'416 | 7'998 | 334'696 | 9'302'110 | 96'878 |
Year 2: Deaths, surrenders and a new assumption
| Line item | How it is calculated | BEL incl. this year | BEL future years | RA incl. this year | RA future years |
|---|---|---|---|---|---|
| aStep 0: Opening valuation | Prior year-end basis, discounted to the start of the year | 8'959'416 | 8'364'253 | 7'998 | 5'717 |
| bStep 1: Move one year forward | Same cash flows, discounted to the year-end | 9'228'201 | 8'615'183 | 8'238 | 5'888 |
| cStep 2: Actual fund return | Year 2 return 3%, as expected | 9'228'201 | 8'615'183 | 8'238 | 5'888 |
| dStep 3: New interest rate | Rate 3% → 3% for discounting and future returns | 9'228'201 | 8'615'183 | 8'238 | 5'888 |
| eStep 4: Actual deaths and surrenders | Actual decrements this year | 9'247'671 | 8'111'102 | 8'129 | 5'544 |
| fStep 5: New assumptions | Updated surrender assumption for future years | 9'254'826 | 8'118'257 | 7'964 | 5'379 |
| Line item | How it is calculated | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| aPolicies in force at start | Actual for this year | 940.00 | 831.90 | 757.03 | 688.90 |
| bOpening fund | Actual for this year | 9'298'350 | 8'348'772 | 7'707'924 | 7'116'268 |
| cFund return | b × return | 278'951 | 250'463 | 231'238 | 213'488 |
| dAMC to insurer | −(b + c) × 1.5% | −143'660 | −128'989 | −119'087 | −109'946 |
| eDeaths | a × mortality | 14.10 | 8.32 | 7.57 | 6.89 |
| fSurrenders | a × surrender rate | 94.00 | 66.55 | 60.56 | – |
| gAccount values paid | Death + surrender + maturity | −1'084'869 | −762'322 | −703'807 | −7'219'810 |
| hDeath extra paid | e × 1'000 | −14'100 | −8'319 | −7'570 | −6'889 |
| iAdministration costs | a × 40 | −37'600 | −33'276 | −30'281 | −27'556 |
| jDiscount factor at the year-end | 1 ÷ (1 + 3%) ^ years | 1.000000 | 0.970874 | 0.942596 | 0.915142 |
| kPV of outflows | (g + h + i) × j | −1'136'569 | −780'502 | −699'084 | −6'638'671 |
| lCoverage units | b + 1'000 × a | 10'238'350 | 9'180'672 | 8'464'953 | 7'805'164 |
| Line item | Return on fund | BEL | RA | CSM | Liability | Profit |
|---|---|---|---|---|---|---|
| aOpening balanceClosing balance of year 1 | 8'959'416 | 7'998 | 334'696 | 9'302'110 | ||
| bTime value at the opening rateFund: opening fund × opening rate. BEL and RA: unwind. CSM: fund − BEL − RA | 278'951 | 268'785 | 240 | 9'926 | 278'951 | – |
| cMarket: fund return differs from expectedFund: actual − expected return. BEL: revalue with actual fund. CSM: fund − BEL | – | – | – | – | – | – |
| dMarket: interest rate changeBEL and RA at the new rate. CSM: −(BEL + RA) | – | – | – | – | – | – |
| eClaims experience this year (death extra)Actual − expected death-extra payments | – | 4'700 | – | – | 4'700 | −4'700 |
| fActual deaths and surrenders: effect on future yearsBEL and RA for future years with the actual policies. The fund and the BEL fall together for the account values paid IFRS 17.B111. CSM: −(BEL + RA) | – | 14'770 | −344 | −14'426 | – | – |
| gAssumption change for future yearsBEL and RA on the new assumption. CSM: −(BEL + RA) | – | 7'155 | −165 | −6'990 | – | – |
| hRA release for this yearRA on this year's death-extra and costs | – | – | −2'350 | – | −2'350 | 2'350 |
| iCSM release for this yearCSM before release × coverage units this year ÷ all remaining coverage units | – | – | – | −92'720 | −92'720 | 92'720 |
| jCash paid at year-endActual benefits and costs paid. No profit effect | −1'136'569 | −1'136'569 | ||||
| kClosing balance and totals for the yearSum of a to j | 278'951 | 8'118'257 | 5'379 | 230'486 | 8'354'122 | 90'370 |
Year 3: Market fall and rate cut
| Line item | How it is calculated | BEL incl. this year | BEL future years | RA incl. this year | RA future years |
|---|---|---|---|---|---|
| aStep 0: Opening valuation | Prior year-end basis, discounted to the start of the year | 8'118'257 | 7'337'755 | 5'379 | 3'360 |
| bStep 1: Move one year forward | Same cash flows, discounted to the year-end | 8'361'805 | 7'557'888 | 5'541 | 3'461 |
| cStep 2: Actual fund return | Year 3 return −10% instead of 3% | 7'320'418 | 6'612'716 | 5'541 | 3'461 |
| dStep 3: New interest rate | Rate 3% → 2% for discounting and future returns | 7'321'418 | 6'613'716 | 5'591 | 3'511 |
| eStep 4: Actual deaths and surrenders | Actual decrements this year | 7'321'418 | 6'613'716 | 5'591 | 3'511 |
| fStep 5: New assumptions | New best estimates for future years (no change this year) | 7'321'418 | 6'613'716 | 5'591 | 3'511 |
| Line item | How it is calculated | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|
| aPolicies in force at start | Actual for this year | 831.90 | 757.03 | 688.90 |
| bOpening fund | Actual for this year | 8'348'772 | 6'735'080 | 6'157'729 |
| cFund return | b × return | −834'877 | 134'702 | 123'155 |
| dAMC to insurer | −(b + c) × 1.5% | −112'708 | −103'047 | −94'213 |
| eDeaths | a × mortality | 8.32 | 7.57 | 6.89 |
| fSurrenders | a × surrender rate | 66.55 | 60.56 | – |
| gAccount values paid | Death + surrender + maturity | −666'107 | −609'006 | −6'186'671 |
| hDeath extra paid | e × 1'000 | −8'319 | −7'570 | −6'889 |
| iAdministration costs | a × 40 | −33'276 | −30'281 | −27'556 |
| jDiscount factor at the year-end | 1 ÷ (1 + 2%) ^ years | 1.000000 | 0.980392 | 0.961169 |
| kPV of outflows | (g + h + i) × j | −707'702 | −634'174 | −5'979'542 |
| lCoverage units | b + 1'000 × a | 9'180'672 | 7'492'109 | 6'846'625 |
| Line item | Return on fund | BEL | RA | CSM | Liability | Profit |
|---|---|---|---|---|---|---|
| aOpening balanceClosing balance of year 2 | 8'118'257 | 5'379 | 230'486 | 8'354'122 | ||
| bTime value at the opening rateFund: opening fund × opening rate. BEL and RA: unwind. CSM: fund − BEL − RA | 250'463 | 243'548 | 162 | 6'753 | 250'463 | – |
| cMarket: fund return differs from expectedFund: actual − expected return. BEL: revalue with actual fund. CSM: fund − BEL | −1'085'340 | −1'041'387 | – | −43'953 | −1'085'340 | – |
| dMarket: interest rate changeBEL and RA at the new rate. CSM: −(BEL + RA) | – | 1'000 | 50 | −1'050 | – | – |
| eClaims experience this year (death extra)Actual − expected death-extra payments | – | – | – | – | – | – |
| fActual deaths and surrenders: effect on future yearsBEL and RA for future years with the actual policies. The fund and the BEL fall together for the account values paid IFRS 17.B111. CSM: −(BEL + RA) | – | – | – | – | – | – |
| gAssumption change for future yearsBEL and RA on the new assumption. CSM: −(BEL + RA) | – | – | – | – | – | – |
| hRA release for this yearRA on this year's death-extra and costs | – | – | −2'080 | – | −2'080 | 2'080 |
| iCSM release for this yearCSM before release × coverage units this year ÷ all remaining coverage units | – | – | – | −75'038 | −75'038 | 75'038 |
| jCash paid at year-endActual benefits and costs paid. No profit effect | −707'702 | −707'702 | ||||
| kClosing balance and totals for the yearSum of a to j | −834'877 | 6'613'716 | 3'511 | 117'198 | 6'734'425 | 77'118 |
Year 4: As expected
| Line item | How it is calculated | BEL incl. this year | BEL future years | RA incl. this year | RA future years |
|---|---|---|---|---|---|
| aStep 0: Opening valuation | Prior year-end basis, discounted to the start of the year | 6'613'716 | 5'979'542 | 3'511 | 1'655 |
| bStep 1: Move one year forward | Same cash flows, discounted to the year-end | 6'745'991 | 6'099'134 | 3'581 | 1'689 |
| cStep 2: Actual fund return | Year 4 return 2%, as expected | 6'745'991 | 6'099'134 | 3'581 | 1'689 |
| dStep 3: New interest rate | Rate 2% → 2% for discounting and future returns | 6'745'991 | 6'099'134 | 3'581 | 1'689 |
| eStep 4: Actual deaths and surrenders | Actual decrements this year | 6'745'991 | 6'099'134 | 3'581 | 1'689 |
| fStep 5: New assumptions | New best estimates for future years (no change this year) | 6'745'991 | 6'099'134 | 3'581 | 1'689 |
| Line item | How it is calculated | Year 4 | Year 5 |
|---|---|---|---|
| aPolicies in force at start | Actual for this year | 757.03 | 688.90 |
| bOpening fund | Actual for this year | 6'735'080 | 6'157'729 |
| cFund return | b × return | 134'702 | 123'155 |
| dAMC to insurer | −(b + c) × 1.5% | −103'047 | −94'213 |
| eDeaths | a × mortality | 7.57 | 6.89 |
| fSurrenders | a × surrender rate | 60.56 | – |
| gAccount values paid | Death + surrender + maturity | −609'006 | −6'186'671 |
| hDeath extra paid | e × 1'000 | −7'570 | −6'889 |
| iAdministration costs | a × 40 | −30'281 | −27'556 |
| jDiscount factor at the year-end | 1 ÷ (1 + 2%) ^ years | 1.000000 | 0.980392 |
| kPV of outflows | (g + h + i) × j | −646'857 | −6'099'134 |
| lCoverage units | b + 1'000 × a | 7'492'109 | 6'846'625 |
| Line item | Return on fund | BEL | RA | CSM | Liability | Profit |
|---|---|---|---|---|---|---|
| aOpening balanceClosing balance of year 3 | 6'613'716 | 3'511 | 117'198 | 6'734'425 | ||
| bTime value at the opening rateFund: opening fund × opening rate. BEL and RA: unwind. CSM: fund − BEL − RA | 134'702 | 132'275 | 70 | 2'357 | 134'702 | – |
| cMarket: fund return differs from expectedFund: actual − expected return. BEL: revalue with actual fund. CSM: fund − BEL | – | – | – | – | – | – |
| dMarket: interest rate changeBEL and RA at the new rate. CSM: −(BEL + RA) | – | – | – | – | – | – |
| eClaims experience this year (death extra)Actual − expected death-extra payments | – | – | – | – | – | – |
| fActual deaths and surrenders: effect on future yearsBEL and RA for future years with the actual policies. The fund and the BEL fall together for the account values paid IFRS 17.B111. CSM: −(BEL + RA) | – | – | – | – | – | – |
| gAssumption change for future yearsBEL and RA on the new assumption. CSM: −(BEL + RA) | – | – | – | – | – | – |
| hRA release for this yearRA on this year's death-extra and costs | – | – | −1'892 | – | −1'892 | 1'892 |
| iCSM release for this yearCSM before release × coverage units this year ÷ all remaining coverage units | – | – | – | −62'468 | −62'468 | 62'468 |
| jCash paid at year-endActual benefits and costs paid. No profit effect | −646'857 | −646'857 | ||||
| kClosing balance and totals for the yearSum of a to j | 134'702 | 6'099'134 | 1'689 | 57'087 | 6'157'910 | 64'360 |
Year 5: Maturity
| Line item | How it is calculated | BEL incl. this year | BEL future years | RA incl. this year | RA future years |
|---|---|---|---|---|---|
| aStep 0: Opening valuation | Prior year-end basis, discounted to the start of the year | 6'099'134 | – | 1'689 | – |
| bStep 1: Move one year forward | Same cash flows, discounted to the year-end | 6'221'116 | – | 1'722 | – |
| cStep 2: Actual fund return | Year 5 return 2%, as expected | 6'221'116 | – | 1'722 | – |
| dStep 3: New interest rate | Rate 2% → 2% for discounting and future returns | 6'221'116 | – | 1'722 | – |
| eStep 4: Actual deaths and surrenders | Actual decrements this year | 6'221'116 | – | 1'722 | – |
| fStep 5: New assumptions | New best estimates for future years (no change this year) | 6'221'116 | – | 1'722 | – |
| Line item | How it is calculated | Year 5 |
|---|---|---|
| aPolicies in force at start | Actual for this year | 688.90 |
| bOpening fund | Actual for this year | 6'157'729 |
| cFund return | b × return | 123'155 |
| dAMC to insurer | −(b + c) × 1.5% | −94'213 |
| eDeaths | a × mortality | 6.89 |
| fSurrenders | a × surrender rate | – |
| gAccount values paid | Death + surrender + maturity | −6'186'671 |
| hDeath extra paid | e × 1'000 | −6'889 |
| iAdministration costs | a × 40 | −27'556 |
| jDiscount factor at the year-end | 1 ÷ (1 + 2%) ^ years | 1.000000 |
| kPV of outflows | (g + h + i) × j | −6'221'116 |
| lCoverage units | b + 1'000 × a | 6'846'625 |
| Line item | Return on fund | BEL | RA | CSM | Liability | Profit |
|---|---|---|---|---|---|---|
| aOpening balanceClosing balance of year 4 | 6'099'134 | 1'689 | 57'087 | 6'157'910 | ||
| bTime value at the opening rateFund: opening fund × opening rate. BEL and RA: unwind. CSM: fund − BEL − RA | 123'155 | 121'982 | 33 | 1'140 | 123'155 | – |
| cMarket: fund return differs from expectedFund: actual − expected return. BEL: revalue with actual fund. CSM: fund − BEL | – | – | – | – | – | – |
| dMarket: interest rate changeBEL and RA at the new rate. CSM: −(BEL + RA) | – | – | – | – | – | – |
| eClaims experience this year (death extra)Actual − expected death-extra payments | – | – | – | – | – | – |
| fActual deaths and surrenders: effect on future yearsBEL and RA for future years with the actual policies. The fund and the BEL fall together for the account values paid IFRS 17.B111. CSM: −(BEL + RA) | – | – | – | – | – | – |
| gAssumption change for future yearsBEL and RA on the new assumption. CSM: −(BEL + RA) | – | – | – | – | – | – |
| hRA release for this yearRA on this year's death-extra and costs | – | – | −1'722 | – | −1'722 | 1'722 |
| iCSM release for this yearCSM before release × coverage units this year ÷ all remaining coverage units | – | – | – | −58'227 | −58'227 | 58'227 |
| jCash paid at year-endActual benefits and costs paid. No profit effect | −6'221'116 | −6'221'116 | ||||
| kClosing balance and totals for the yearSum of a to j | 123'155 | – | – | – | – | 59'949 |