Settings
Getting started
Click “Start”: the application gives you a session token. Its role, the sessions of a token (scenarios), saving, resuming and recalculation are explained on the Sessions and token page.
The work page is split into four tabs, in the order of input: Settings, Data, Results, Export. A tab is available only once the previous tabs are complete; each tab shows what remains to be completed. Within a tab, each block opens (summary, “Next” button) only once the blocks before it are complete.
The “Settings” tab sets the closing date of the period (the period covers the year ending on that date), the currency, the discount curve and the option to disaggregate insurance finance income or expenses (paragraph 88(b)); then, as an interpretation parameter, the interest rate shock of the sensitivity analysis (PI1, paragraph 128(a)(i)), which the standard does not set: 0.005 (0.5%) by default, between 0.0001 and 0.03.
| Question | Allowed values | Default | Asked if |
|---|---|---|---|
| Closing date of the reporting period | date | today's date | always |
| Currency of the discount curve | Currency | EUR | always |
| Current discount rates | Discount curve | eiopa | always |
| Insurance finance income or expenses disaggregated between profit or loss and other comprehensive income (paragraph 88(b)) | Yes or no | N | always |
Frequently asked questions
How is the contractual service margin calculated?
At initial recognition, it equals the excess of the inflows over the outflows of the fulfilment cash flows, including the risk adjustment for non-financial risk (paragraph 38). Afterwards, it accretes interest at the locked-in rate, is adjusted for changes relating to future service and is released in line with coverage units (paragraph 44, B119).
When can the premium allocation approach be used?
For a group whose coverage period is no more than one year, or whose measurement would not differ materially from the general measurement model (paragraph 53). Revenue is then allocated on the basis of the passage of time (B126).
What is the loss component?
The part of the liability for remaining coverage that depicts the losses on an onerous group; it determines the amounts presented as reversals of losses and excluded from insurance revenue (paragraph 49).
Which discount rates does inscalc use?
Current rates from the EIOPA risk-free curve plus an illiquidity premium (bottom-up approach, B80), or an entered curve; the rate locked in at initial recognition for the interest on the contractual service margin (B72(b)).
Data
Entering data
The “Data” tab has four chapters.
- Discount curve: the illiquidity premium added to the EIOPA risk-free curve (bottom-up approach, B80), or the points (maturity, rate) of an entered curve.
- Groups of contracts: one line per group (free name, then Enter or “+”), with its approach, its portfolio (free name: groups with the same name form a portfolio, paragraph 14; empty: the group forms its own) and, if it is initially recognised at the start of the period, “new” and the part of its portfolio's acquisition cash flow asset allocated to it (paragraph 28C). The “PAA · ” columns apply only to the premium allocation approach, the “GMM · ” columns only to the general measurement model, the “LIC · ” columns to both (liability for incurred claims). An empty cell counts as 0.
- Future cash flows: one line per cash flow, with its group, its base date (start or end of the period), its nature (premiums, benefits and expenses of future coverage, insurance acquisition cash flows, incurred claims), its timing in years after the base date and its undiscounted amount, positive.
- Acquisition cash flow asset, by portfolio, optional: one line for a portfolio with an asset for insurance acquisition cash flows paid before the groups are recognised (paragraph 28B), under the name of the groups' “portfolio” column: opening, cash flows of the period recognised as an asset, impairment and reversal (paragraphs 28E, 28F), derecognition expected over three years (paragraph 109A).
For a group under the general measurement model, the start-of-period cash flows are those projected at the start of the period (or at initial recognition of a new group), the end-of-period ones the closing projection. For a group under the premium allocation approach, only the incurred claims with the end-of-period base are read.
Under the title of each table, an instruction says what to enter and how, and a filled example shows correct lines (those of the application's example); “What to enter?” details each column. The tables of the entered curve (if chosen), of the groups of contracts and of the future cash flows need at least one line; on a started line, the required columns are framed in red while they are empty. A rate is entered as a decimal (0.025 for 2.5%); “2.5%” is accepted.
Discount curve
| Data | What to enter | Unit | Entered by | Required |
|---|---|---|---|---|
Illiquidity premium added to the risk-free curveilliquidity premium | Constant spread reflecting the liquidity of the contracts (B80); 0.002 for 0.20%. | rate, as a decimal (0.025 = 2.5%) | single value | yes |
Maturity of a point of the entered curvematurity | In years. | years | Entered discount curve | yes |
Spot rate of a point of the entered curverate | Annual spot rate; 0.025 for 2.5%. | rate, as a decimal (0.025 = 2.5%) | Entered discount curve | yes |
Groups of contracts
| Data | What to enter | Unit | Entered by | Required |
|---|---|---|---|---|
Measurement approach of the groupapproach | PAA: premium allocation approach (paragraphs 53–59); GMM: general measurement model (paragraphs 32–52). | Groups of contracts | yes | |
Group initially recognised at the start of the periodnew | Yes: no opening balances; the cash flows with the start-of-period base are those at initial recognition. | Groups of contracts | yes | |
Portfolio of contracts of the groupportfolio | Free name (paragraph 14): groups with the same name form a portfolio, presented as an asset or a liability (paragraph 78). Empty: the group forms its own portfolio. | Groups of contracts | ||
Premiums received in the periodpremiums received | amount, in the currency of the entries | Groups of contracts | ||
Insurance acquisition cash flows paid in the periodacquisition paid | amount, in the currency of the entries | Groups of contracts | ||
Asset for insurance acquisition cash flows derecognised when the group is recognisedasset derecognised | New group linked to a portfolio: part of the portfolio's asset allocated to it (paragraphs 28A, 28C). It reduces the contractual service margin or the liability under the premium allocation approach. Empty: 0. | amount, in the currency of the entries | Groups of contracts | |
Loss component at the start of the periodloss component opening | amount, in the currency of the entries | Groups of contracts |
Premium allocation approach
| Data | What to enter | Unit | Entered by | Required |
|---|---|---|---|---|
Liability for remaining coverage at the start of the period, excluding the loss componentPAA · LRC opening | amount, in the currency of the entries | Groups of contracts | ||
Insurance acquisition cash flows recognised as expenses (paragraph 59(a))PAA · 59(a) | Coverage period of no more than one year. | Groups of contracts | ||
Expected premium receipts of the group for its whole coveragePAA · expected premiums | Excluding investment components. | amount, in the currency of the entries | Groups of contracts | |
Insurance acquisition cash flows of the groupPAA · group acquisition | Including the asset for acquisition cash flows derecognised. | amount, in the currency of the entries | Groups of contracts | |
Share of coverage provided, cumulative, at the start of the periodPAA · coverage opening | Passage of time, or expected timing of incurred expenses if the release of risk differs (B126). | share, as a decimal (0.30 = 30%) | Groups of contracts | |
Share of coverage provided, cumulative, at the end of the periodPAA · coverage closing | share, as a decimal (0.30 = 30%) | Groups of contracts | ||
Facts and circumstances indicate an onerous group (paragraph 57)PAA · onerous | Groups of contracts | |||
Fulfilment cash flows that relate to remaining coveragePAA · remaining coverage FCF | If the group is onerous. | amount, in the currency of the entries | Groups of contracts |
General measurement model
| Data | What to enter | Unit | Entered by | Required |
|---|---|---|---|---|
Discount rate determined at initial recognitionGMM · locked-in rate | Constant rate; 0.02 for 2%. | rate, as a decimal (0.025 = 2.5%) | Groups of contracts | |
Present value of the future coverage cash flows at the start of the periodGMM · PV opening | At the opening current rates (value of the previous closing). | amount, in the currency of the entries | Groups of contracts | |
Risk adjustment for non-financial risk of the remaining coverage at the start of the periodGMM · RA opening | For a group recognised in the period: amount at initial recognition. | amount, in the currency of the entries | Groups of contracts | |
Risk adjustment for non-financial risk of the remaining coverage at the end of the periodGMM · RA closing | amount, in the currency of the entries | Groups of contracts | ||
Contractual service margin at the start of the periodGMM · CSM opening | amount, in the currency of the entries | Groups of contracts | ||
Insurance acquisition cash flows not yet amortised at the start of the periodGMM · acquisition to amortise | amount, in the currency of the entries | Groups of contracts | ||
Coverage units provided in the periodGMM · period units | number | Groups of contracts | ||
Coverage units expected to be provided after the end of the periodGMM · future units | number | Groups of contracts | ||
Remaining coverage period at the start of the period, in yearsGMM · remaining coverage period | Straight-line amortisation of acquisition cash flows (B125). Empty or 1 or less: cash flows fully amortised in the period. | number | Groups of contracts | |
Share of the difference between premiums received and expected that relates to future serviceGMM · premiums: future share | It adjusts the contractual service margin (B96(a)); the rest goes to revenue (B124(d)). Empty: 0. | share, as a decimal (0.30 = 30%) | Groups of contracts | |
Share of the difference between insurance acquisition cash flows paid and expected that relates to current serviceGMM · acquisition: period share | It goes to expenses (paragraph 84); the rest adjusts the contractual service margin (B96(a)). Empty: 0. | share, as a decimal (0.30 = 30%) | Groups of contracts | |
Coverage units expected in the 1st year after the end of the periodGMM · units year 1 | Breakdown of the future units over the first five years: timing of the contractual service margin (paragraph 109); the rest goes beyond five years. Empty: 0. | number | Groups of contracts | |
Coverage units expected in the 2nd year after the end of the periodGMM · units year 2 | number | Groups of contracts | ||
Coverage units expected in the 3rd year after the end of the periodGMM · units year 3 | number | Groups of contracts | ||
Coverage units expected in the 4th year after the end of the periodGMM · units year 4 | number | Groups of contracts | ||
Coverage units expected in the 5th year after the end of the periodGMM · units year 5 | number | Groups of contracts |
Incurred claims
| Data | What to enter | Unit | Entered by | Required |
|---|---|---|---|---|
Liability for incurred claims at the start of the periodLIC · LIC opening | Opening carrying amount, including the risk adjustment for non-financial risk. | amount, in the currency of the entries | Groups of contracts | |
Risk adjustment for non-financial risk of incurred claims at the start of the periodLIC · RA LIC opening | amount, in the currency of the entries | Groups of contracts | ||
Risk adjustment for non-financial risk of incurred claims at the end of the periodLIC · RA LIC closing | amount, in the currency of the entries | Groups of contracts | ||
Incurred claims and other insurance service expenses paid in the periodLIC · claims paid | Excluding insurance acquisition cash flows. | amount, in the currency of the entries | Groups of contracts | |
Incurred claims not discounted (paid within one year, paragraph 59(b))LIC · 59(b) | PAA groups only. | Groups of contracts |
Future cash flows
| Data | What to enter | Unit | Entered by | Required |
|---|---|---|---|---|
Group of contracts of the cash flowgroup | Future cash flows | yes | ||
Base date of the cash flowbase | Start: projection at the start of the period (or at initial recognition); end: projection at the end of the period. | Future cash flows | yes | |
Nature of the cash flownature | Future cash flows | yes | ||
Timing of the cash flow after the base datet | In years; 0.5 for a mid-year cash flow. | years | Future cash flows | yes |
Undiscounted amount of the cash flowamount | Positive, inflow or outflow. | amount, in the currency of the entries | Future cash flows | yes |
Acquisition cash flow asset
| Data | What to enter | Unit | Entered by | Required |
|---|---|---|---|---|
Asset for insurance acquisition cash flows at the start of the periodasset opening | Cash flows paid before the related groups are recognised (paragraph 28B). Empty: 0. | amount, in the currency of the entries | Acquisition cash flow asset, by portfolio | |
Insurance acquisition cash flows paid in the period and recognised as an assetcash flows to the asset | Paid before the related group is recognised; they are not repeated in the acquisition paid of the groups. Empty: 0. | amount, in the currency of the entries | Acquisition cash flow asset, by portfolio | |
Impairment loss on the asset recognised in the periodimpairment | Excess of the carrying amount of the asset over the expected net cash inflow of the related groups (paragraph 28E). Empty: 0; an impaired asset is then overstated. | amount, in the currency of the entries | Acquisition cash flow asset, by portfolio | |
Reversal of impairment losses on the asset recognised in the periodimpairment reversal | When the impairment conditions no longer exist or have improved (paragraph 28F). Empty: 0. | amount, in the currency of the entries | Acquisition cash flow asset, by portfolio | |
Part of the closing asset expected to be derecognised in the 1st year after the end of the periodderecognition year 1 | Timing of derecognition of the closing asset (paragraph 109A); the rest goes beyond three years. Empty: 0. | amount, in the currency of the entries | Acquisition cash flow asset, by portfolio | |
Part of the closing asset expected to be derecognised in the 2nd year after the end of the periodderecognition year 2 | amount, in the currency of the entries | Acquisition cash flow asset, by portfolio | ||
Part of the closing asset expected to be derecognised in the 3rd year after the end of the periodderecognition year 3 | amount, in the currency of the entries | Acquisition cash flow asset, by portfolio |
Disclosures
| Data | What to enter | Unit | Entered by | Required |
|---|---|---|---|---|
Confidence level corresponding to the risk adjustment for non-financial riskRA confidence level | Reported as is in the paragraph 119 table; 0.75 for 75%. Empty: table without value. | share, as a decimal (0.30 = 30%) | single value |
Consistency checks
Before the calculation, each entry is checked against the requirements of IFRS 17 and, failing that, against insurers' practice. An entry that breaks one outlines the cell concerned, leaves the block “to be completed” and refuses the calculation: a result drawn from inconsistent entries would be meaningless. The rules applied, with the data item they target and their source:
| Data | Rule | Source |
|---|---|---|
| liability for remaining coverage at the start of the period, excluding the loss component | New group: no opening liability for remaining coverage | paragraph 25 |
| loss component at the start of the period | New group: no opening loss component | paragraph 25 |
| contractual service margin at the start of the period | New group: no opening contractual service margin | paragraph 25 |
| present value of the future coverage cash flows at the start of the period | New group: no opening present value of cash flows | paragraph 25 |
| liability for incurred claims at the start of the period | New group: no opening liability for incurred claims | paragraph 25 |
| risk adjustment for non-financial risk of incurred claims at the start of the period | New group: no opening risk adjustment of incurred claims | paragraph 25 |
| insurance acquisition cash flows not yet amortised at the start of the period | New group: no opening unamortised acquisition cash flows | paragraph 25 |
| share of coverage provided, cumulative, at the start of the period | New group: no opening coverage provided | paragraph 25 |
| coverage units expected in the 1st year after the end of the period | Units of the first five years greater than the future units | paragraph 109 |
| coverage units expected in the 1st year after the end of the period | Negative coverage units | paragraph B119 |
| confidence level corresponding to the risk adjustment for non-financial risk | Confidence level outside 0 to 1 (0.75 for 75%) | paragraph 119 |
| portfolio of contracts of the group | Asset derecognised, but the group's portfolio has no line in the acquisition cash flow asset table: use exactly the same name | paragraphs 14, 28C |
| asset for insurance acquisition cash flows at the start of the period | Negative asset for acquisition cash flows at closing: derecognition or impairment greater than the asset | paragraphs 28C, 28E |
| asset for insurance acquisition cash flows at the start of the period | Negative asset | paragraph 28B |
| insurance acquisition cash flows paid in the period and recognised as an asset | Negative amount paid | paragraph 28B |
| impairment loss on the asset recognised in the period | Negative impairment: a reversal goes in its own column | paragraph 28E |
| impairment loss on the asset recognised in the period | Impairment greater than the available asset | paragraph 28E |
| reversal of impairment losses on the asset recognised in the period | Negative reversal | paragraph 28F |
| part of the closing asset expected to be derecognised in the 1st year after the end of the period | Derecognition expected over three years greater than the closing asset | paragraph 109A |
| part of the closing asset expected to be derecognised in the 1st year after the end of the period | Negative amount | paragraph 109A |
| asset for insurance acquisition cash flows derecognised when the group is recognised | Asset derecognised on a group already recognised: only when the group is recognised | paragraph 28C |
| asset for insurance acquisition cash flows derecognised when the group is recognised | Asset derecognised on a group without a portfolio | paragraphs 28A, 28C |
| asset for insurance acquisition cash flows derecognised when the group is recognised | Negative asset derecognised | paragraph 28C |
| asset for insurance acquisition cash flows derecognised when the group is recognised | Asset derecognised on a group whose acquisition cash flows are expensed (paragraph 59(a)) | paragraphs 28A, 59(a) |
| contractual service margin at the start of the period | Negative contractual service margin | paragraphs 38, 43 |
| loss component at the start of the period | Negative loss component | paragraph 49 |
| loss component at the start of the period | Loss component and contractual service margin both positive | paragraphs 48 to 50 |
| risk adjustment for non-financial risk of the remaining coverage at the start of the period | Negative risk adjustment for non-financial risk | paragraphs 37, B87 |
| risk adjustment for non-financial risk of the remaining coverage at the end of the period | Negative risk adjustment for non-financial risk | paragraphs 37, B87 |
| risk adjustment for non-financial risk of incurred claims at the start of the period | Negative risk adjustment for non-financial risk | paragraphs 37, B87 |
| risk adjustment for non-financial risk of incurred claims at the end of the period | Negative risk adjustment for non-financial risk | paragraphs 37, B87 |
| liability for remaining coverage at the start of the period, excluding the loss component | Premium allocation approach column (opening liability) on a general model group | paragraph 29 |
| expected premium receipts of the group for its whole coverage | Premium allocation approach column (expected premiums) on a general model group | paragraph 29 |
| insurance acquisition cash flows of the group | Premium allocation approach column (group acquisition cash flows) on a general model group | paragraph 29 |
| share of coverage provided, cumulative, at the start of the period | Premium allocation approach column (coverage opening) on a general model group | paragraph 29 |
| share of coverage provided, cumulative, at the end of the period | Premium allocation approach column (coverage closing) on a general model group | paragraph 29 |
| fulfilment cash flows that relate to remaining coverage | Premium allocation approach column (remaining coverage FCF) on a general model group | paragraph 29 |
| facts and circumstances indicate an onerous group (paragraph 57) | Onerous under paragraph 57 declared on a general model group | paragraphs 29, 57 |
| discount rate determined at initial recognition | General model column (locked-in rate) on a premium allocation approach group | paragraph 29 |
| present value of the future coverage cash flows at the start of the period | General model column (opening present value) on a premium allocation approach group | paragraph 29 |
| risk adjustment for non-financial risk of the remaining coverage at the start of the period | General model column (opening RA) on a premium allocation approach group | paragraph 29 |
| risk adjustment for non-financial risk of the remaining coverage at the end of the period | General model column (closing RA) on a premium allocation approach group | paragraph 29 |
| contractual service margin at the start of the period | General model column (opening CSM) on a premium allocation approach group | paragraph 29 |
| insurance acquisition cash flows not yet amortised at the start of the period | General model column (unamortised acquisition) on a premium allocation approach group | paragraph 29 |
| coverage units provided in the period | General model column (period units) on a premium allocation approach group | paragraph 29 |
| coverage units expected to be provided after the end of the period | General model column (future units) on a premium allocation approach group | paragraph 29 |
| remaining coverage period at the start of the period, in years | General model column (remaining coverage period) on a premium allocation approach group | paragraph 29 |
| share of the difference between premiums received and expected that relates to future service | General model column (future share of premium difference) on a premium allocation approach group | paragraph 29 |
| share of the difference between insurance acquisition cash flows paid and expected that relates to current service | General model column (period share of acquisition difference) on a premium allocation approach group | paragraph 29 |
| coverage units expected in the 1st year after the end of the period | General model column (units year 1) on a premium allocation approach group | paragraph 29 |
| coverage units expected in the 2nd year after the end of the period | General model column (units year 2) on a premium allocation approach group | paragraph 29 |
| coverage units expected in the 3rd year after the end of the period | General model column (units year 3) on a premium allocation approach group | paragraph 29 |
| coverage units expected in the 4th year after the end of the period | General model column (units year 4) on a premium allocation approach group | paragraph 29 |
| coverage units expected in the 5th year after the end of the period | General model column (units year 5) on a premium allocation approach group | paragraph 29 |
| discount rate determined at initial recognition | Locked-in rate to enter (non-zero) | paragraph B72(b) |
| coverage units provided in the period | Coverage units of the period to enter, positive | paragraph B119 |
| coverage units expected to be provided after the end of the period | Negative future coverage units | paragraph B119 |
| share of coverage provided, cumulative, at the start of the period | Cumulative coverage outside 0 to 1 | paragraph B126 |
| share of coverage provided, cumulative, at the end of the period | Cumulative coverage outside 0 to 1 | paragraph B126 |
| share of coverage provided, cumulative, at the end of the period | Cumulative coverage at closing lower than at opening | paragraph B126 |
| share of coverage provided, cumulative, at the end of the period | Cumulative coverage at closing to enter | paragraph B126 |
| expected premium receipts of the group for its whole coverage | Expected premiums of the group to enter, positive | paragraph B126 |
| fulfilment cash flows that relate to remaining coverage | Onerous group: fulfilment cash flows of remaining coverage to enter | paragraphs 57, 58 |
| insurance acquisition cash flows recognised as expenses (paragraph 59(a)) | Paragraph 59(a) option reserved for the premium allocation approach | paragraph 59(a) |
| incurred claims not discounted (paid within one year, paragraph 59(b)) | Paragraph 59(b) option reserved for the premium allocation approach | paragraph 59(b) |
| share of the difference between premiums received and expected that relates to future service | Share outside 0 to 1 | paragraph B96(a) |
| share of the difference between insurance acquisition cash flows paid and expected that relates to current service | Share outside 0 to 1 | paragraph B96(a) |
| premiums received in the period | Negative amount paid | insurers' practice |
| insurance acquisition cash flows paid in the period | Negative amount paid | insurers' practice |
| incurred claims and other insurance service expenses paid in the period | Negative amount paid | insurers' practice |
| liability for incurred claims at the start of the period | Liability for incurred claims lower than its risk adjustment | paragraph 40(b), insurers' practice |
| timing of the cash flow after the base date | Negative timing | insurers' practice |
| undiscounted amount of the cash flow | Negative amount: all amounts are entered as positive | insurers' practice |
| base date of the cash flow | Incurred claims to be entered with the closing basis | paragraph 40(b) |
| nature of the cash flow | Coverage cash flow on a premium allocation approach group: only incurred claims are entered | paragraph 55 |
| group of contracts of the cash flow | General model group without opening cash flows | paragraphs 32, 33 |
| group of contracts of the cash flow | General model group with future units but no closing cash flows | paragraph 40(a) |
| maturity of a point of the entered curve | Maturity to enter, strictly positive | paragraph 36 |
| maturity of a point of the entered curve | Maturity already entered on another point | paragraph 36 |
| spot rate of a point of the entered curve | Rate at or below −100% | paragraph 36 |
Results
Reading the results
The “Results” tab runs the calculation. At the top, a fixed band gives the date of the calculation and the key closing figures: insurance revenue and insurance service expenses, insurance service result, insurance finance income or expenses (IFIE), then contractual service margin (CSM), liability for remaining coverage (LRC), liability for incurred claims (LIC), carrying amount of the groups of contracts and net amount of the contracts in the statement of financial position (portfolios that are liabilities less portfolios that are assets, paragraph 78). Clicking a figure leads to its line in the explanation. The “Warnings” badge unfolds the remarks of the calculation; it opens by itself when there is an alert.
Below, the explanation takes the whole height: one line per component of the calculation, with its total and one column per group of contracts (approach recalled under the name of the group); the “All groups” list keeps only one. Clicking a line unfolds it and opens below its formula written with its symbols, the paragraph of IFRS 17 and the link to the glossary; values that are not set by group (one per cash flow) are listed there too. Amounts are in the currency chosen in the Settings (recalled next to the figures and at the head of the explanation), with two decimals; rates and shares are shown as percentages; in the exported workbook, the “Session” sheet recalls the currency and rates use the percentage format.
| Result | Formula | Article |
|---|---|---|
Insurance service result insurance service result | revenue − expenses | 80(a) |
Insurance revenue revenue | revenue PAA + revenue GMM | 83, 103(a) |
Insurance revenue (premium allocation approach) revenue PAA | PAA ⊗ PAA · expected premiums ⊗ (PAA · coverage closing − PAA · coverage opening) | B126 |
Insurance revenue (general measurement model) revenue GMM | GMM ⊗ (expected expenses + RA released + CSM released + amortisation GMM − allocated to loss component + premium adjustment) | B121, B124, B125 |
Insurance service expenses expenses | group expenses + net impairment | 84, 28E, 28F |
Insurance service expenses of the groups of contracts group expenses | incurred claims + period acquisition variance + acquisition amortisation + losses and reversals | 84, 103(b) |
Impairment loss on the asset for acquisition cash flows, net of reversals net impairment | sum(impairment − impairment reversal) | 28E, 28F |
| Result | Formula | Article |
|---|---|---|
Net carrying amount of insurance contracts issued at the end of the period: portfolios that are liabilities less portfolios that are assets insurance contracts in the balance sheet | portfolios that are liabilities − portfolios that are assets | 78 |
Portfolios of insurance contracts issued that are liabilities at the end of the period portfolios that are liabilities | sum(max(0 ; portfolio closing)) + sum((1 − in a portfolio) ⊗ max(0 ; insurance contracts)) | 78(b), 99 |
Carrying amount of the portfolio at the end of the period, net of the asset for acquisition cash flows portfolio closing | groups closing − asset closing | 78, 99 |
Group linked to a portfolio of the portfolios table in a portfolio | (portfolio ≠ "") + 0 ⊗ GMM | 14 |
Carrying amount of insurance contracts issued at the end of the period insurance contracts | LRC closing + LIC closing | 40 |
Portfolios of insurance contracts issued that are assets at the end of the period portfolios that are assets | sum(max(0 ; − portfolio closing)) + sum((1 − in a portfolio) ⊗ max(0 ; − insurance contracts)) | 78(a), 99 |
Calculation conventions
The calculation follows the paragraphs of IFRS 17 cited in each formula, with these conventions:
- annual period; a new group is initially recognised at the start of the period;
- constant locked-in rate per group under the general measurement model (B72(b));
- differences in the period between premiums received and expected, and between insurance acquisition cash flows paid and expected: the share that relates to future service, entered by group, adjusts the contractual service margin (B96(a)), the rest goes to revenue (premiums, B124(d)) or expenses (acquisition cash flows, paragraph 84); empty columns: premium difference in revenue, acquisition difference in the margin;
- acquisition cash flows under the general model amortised on a straight-line basis over the remaining coverage period (B125): not yet amortised at the start, paid in the period and still expected; premium allocation approach: in line with the coverage provided entered, which must then reflect the passage of time;
- risk adjustment for non-financial risk released in line with coverage units, without disaggregation between the insurance service result and insurance finance income or expenses (paragraph 81);
- insurance finance expenses of the liability for incurred claims at the one-year rate of the closing curve;
- liability for remaining coverage under the premium allocation approach not adjusted for the time value of money (paragraph 56);
- asset for insurance acquisition cash flows held by portfolio: its part derecognised when a group is recognised is entered (paragraphs 28A to 28C) and enters the group's fulfilment cash flows (lower margin, or a loss) or reduces its liability under the premium allocation approach; the impairment is entered (the test of paragraph 28E is not redone) and goes to insurance service expenses; if empty, the asset is overstated when impaired;
- presentation in the statement of financial position (paragraph 78): asset for acquisition cash flows deducted from its portfolio; a portfolio with a negative net amount is an asset; a group without a portfolio forms its own: if several such groups actually form one portfolio, the assets and liabilities presented are both overstated, the net amount remains right.
Outside the calculation: contracts with direct participation features (VFA), reinsurance contracts held, transition, projection of the cash flows and calculation of the risk adjustment for non-financial risk, which remain inputs.
| Level | Message |
|---|---|
| info | Groups without a portfolio: groups without a portfolio. Each forms its own portfolio in the statement of financial position (paragraph 78), without an asset for acquisition cash flows. If several of these groups belong to the same portfolio, portfolios that are assets and liabilities are both overstated; the net amount remains right. |
Exporting the tables
The “Export” tab delivers the “Disclosures” set (IFRS 17, paragraphs 78 to 132): an Excel workbook, with the calculation rerun on the entries:
- I17-RES: statement of profit or loss (paragraphs 80 to 88), and I17-RES-G by group of contracts;
- I17-78: portfolios of insurance contracts issued that are assets and liabilities, at the start and end of the period (paragraph 78), and I17-78-P by portfolio;
- I17-103: reconciliation of the liability for remaining coverage excluding the loss component, the loss component and the liability for incurred claims (paragraphs 100, 103, 105), and one sheet per component, group by group (I17-103-LRC, I17-103-EP, I17-103-LIC);
- I17-101: reconciliation of the measurement components of the general measurement model, present value of the cash flows, risk adjustment for non-financial risk and contractual service margin (paragraphs 101, 104, 105), and one sheet per component, group by group (I17-101-VA, I17-101-RA, I17-101-CSM);
- I17-105A: reconciliation of the asset for insurance acquisition cash flows (paragraph 105A), and I17-105A-P by portfolio;
- I17-106: analysis of insurance revenue under the general model (paragraph 106), and I17-106-G by group of contracts;
- I17-107: effect of contracts initially recognised in the period, contracts not onerous and onerous (paragraphs 107, 108);
- I17-109: expected recognition in profit or loss of the closing contractual service margin, year by year over five years then beyond (paragraph 109), according to the coverage units entered by year, without discounting;
- I17-109A: expected derecognition of the closing asset for acquisition cash flows, over three years then beyond (paragraph 109A);
- I17-119-120: confidence level of the risk adjustment for non-financial risk (paragraph 119) and current discount rates from 1 to 50 years (paragraph 120), and I17-120-G: locked-in rate of each group under the general model;
- I17-132: maturity of the closing undiscounted net cash flows, by year over five years then beyond (paragraph 132(b)(i));
- I17-128: effect on profit or loss and on equity, before tax, of an increase and a decrease of the closing curve by the PI1 shock (paragraph 128(a)(i)), calculation redone on the shifted curve.
An increase in the liability is positive; in the statement of profit or loss, income is positive and an expense negative. The “Session” sheet traces the calculation, the “Coverage” sheet lists each empty cell with its reason.