inscalc.net

User guide

Open the calculator

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.

QuestionAllowed valuesDefaultAsked if
Closing date of the reporting perioddatetoday's datealways
Currency of the discount curveCurrencyEURalways
Current discount ratesDiscount curveeiopaalways
Insurance finance income or expenses disaggregated between profit or loss and other comprehensive income (paragraph 88(b))Yes or noNalways

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

DataWhat to enterUnitEntered byRequired
Illiquidity premium added to the risk-free curveilliquidity premiumConstant spread reflecting the liquidity of the contracts (B80); 0.002 for 0.20%.rate, as a decimal (0.025 = 2.5%)single valueyes
Maturity of a point of the entered curvematurityIn years.yearsEntered discount curveyes
Spot rate of a point of the entered curverateAnnual spot rate; 0.025 for 2.5%.rate, as a decimal (0.025 = 2.5%)Entered discount curveyes

Groups of contracts

DataWhat to enterUnitEntered byRequired
Measurement approach of the groupapproachPAA: premium allocation approach (paragraphs 53–59); GMM: general measurement model (paragraphs 32–52).Groups of contractsyes
Group initially recognised at the start of the periodnewYes: no opening balances; the cash flows with the start-of-period base are those at initial recognition.Groups of contractsyes
Portfolio of contracts of the groupportfolioFree 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 receivedamount, in the currency of the entriesGroups of contracts
Insurance acquisition cash flows paid in the periodacquisition paidamount, in the currency of the entriesGroups of contracts
Asset for insurance acquisition cash flows derecognised when the group is recognisedasset derecognisedNew 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 entriesGroups of contracts
Loss component at the start of the periodloss component openingamount, in the currency of the entriesGroups of contracts

Premium allocation approach

DataWhat to enterUnitEntered byRequired
Liability for remaining coverage at the start of the period, excluding the loss componentPAA · LRC openingamount, in the currency of the entriesGroups 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 premiumsExcluding investment components.amount, in the currency of the entriesGroups of contracts
Insurance acquisition cash flows of the groupPAA · group acquisitionIncluding the asset for acquisition cash flows derecognised.amount, in the currency of the entriesGroups of contracts
Share of coverage provided, cumulative, at the start of the periodPAA · coverage openingPassage 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 closingshare, as a decimal (0.30 = 30%)Groups of contracts
Facts and circumstances indicate an onerous group (paragraph 57)PAA · onerousGroups of contracts
Fulfilment cash flows that relate to remaining coveragePAA · remaining coverage FCFIf the group is onerous.amount, in the currency of the entriesGroups of contracts

General measurement model

DataWhat to enterUnitEntered byRequired
Discount rate determined at initial recognitionGMM · locked-in rateConstant 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 openingAt the opening current rates (value of the previous closing).amount, in the currency of the entriesGroups of contracts
Risk adjustment for non-financial risk of the remaining coverage at the start of the periodGMM · RA openingFor a group recognised in the period: amount at initial recognition.amount, in the currency of the entriesGroups of contracts
Risk adjustment for non-financial risk of the remaining coverage at the end of the periodGMM · RA closingamount, in the currency of the entriesGroups of contracts
Contractual service margin at the start of the periodGMM · CSM openingamount, in the currency of the entriesGroups of contracts
Insurance acquisition cash flows not yet amortised at the start of the periodGMM · acquisition to amortiseamount, in the currency of the entriesGroups of contracts
Coverage units provided in the periodGMM · period unitsnumberGroups of contracts
Coverage units expected to be provided after the end of the periodGMM · future unitsnumberGroups of contracts
Remaining coverage period at the start of the period, in yearsGMM · remaining coverage periodStraight-line amortisation of acquisition cash flows (B125). Empty or 1 or less: cash flows fully amortised in the period.numberGroups of contracts
Share of the difference between premiums received and expected that relates to future serviceGMM · premiums: future shareIt 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 shareIt 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 1Breakdown 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.numberGroups of contracts
Coverage units expected in the 2nd year after the end of the periodGMM · units year 2numberGroups of contracts
Coverage units expected in the 3rd year after the end of the periodGMM · units year 3numberGroups of contracts
Coverage units expected in the 4th year after the end of the periodGMM · units year 4numberGroups of contracts
Coverage units expected in the 5th year after the end of the periodGMM · units year 5numberGroups of contracts

Incurred claims

DataWhat to enterUnitEntered byRequired
Liability for incurred claims at the start of the periodLIC · LIC openingOpening carrying amount, including the risk adjustment for non-financial risk.amount, in the currency of the entriesGroups of contracts
Risk adjustment for non-financial risk of incurred claims at the start of the periodLIC · RA LIC openingamount, in the currency of the entriesGroups of contracts
Risk adjustment for non-financial risk of incurred claims at the end of the periodLIC · RA LIC closingamount, in the currency of the entriesGroups of contracts
Incurred claims and other insurance service expenses paid in the periodLIC · claims paidExcluding insurance acquisition cash flows.amount, in the currency of the entriesGroups 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

DataWhat to enterUnitEntered byRequired
Group of contracts of the cash flowgroupFuture cash flowsyes
Base date of the cash flowbaseStart: projection at the start of the period (or at initial recognition); end: projection at the end of the period.Future cash flowsyes
Nature of the cash flownatureFuture cash flowsyes
Timing of the cash flow after the base datetIn years; 0.5 for a mid-year cash flow.yearsFuture cash flowsyes
Undiscounted amount of the cash flowamountPositive, inflow or outflow.amount, in the currency of the entriesFuture cash flowsyes

Acquisition cash flow asset

DataWhat to enterUnitEntered byRequired
Asset for insurance acquisition cash flows at the start of the periodasset openingCash flows paid before the related groups are recognised (paragraph 28B). Empty: 0.amount, in the currency of the entriesAcquisition cash flow asset, by portfolio
Insurance acquisition cash flows paid in the period and recognised as an assetcash flows to the assetPaid 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 entriesAcquisition cash flow asset, by portfolio
Impairment loss on the asset recognised in the periodimpairmentExcess 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 entriesAcquisition cash flow asset, by portfolio
Reversal of impairment losses on the asset recognised in the periodimpairment reversalWhen the impairment conditions no longer exist or have improved (paragraph 28F). Empty: 0.amount, in the currency of the entriesAcquisition 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 1Timing of derecognition of the closing asset (paragraph 109A); the rest goes beyond three years. Empty: 0.amount, in the currency of the entriesAcquisition 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 2amount, in the currency of the entriesAcquisition 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 3amount, in the currency of the entriesAcquisition cash flow asset, by portfolio

Disclosures

DataWhat to enterUnitEntered byRequired
Confidence level corresponding to the risk adjustment for non-financial riskRA confidence levelReported 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:

DataRuleSource
liability for remaining coverage at the start of the period, excluding the loss componentNew group: no opening liability for remaining coverageparagraph 25
loss component at the start of the periodNew group: no opening loss componentparagraph 25
contractual service margin at the start of the periodNew group: no opening contractual service marginparagraph 25
present value of the future coverage cash flows at the start of the periodNew group: no opening present value of cash flowsparagraph 25
liability for incurred claims at the start of the periodNew group: no opening liability for incurred claimsparagraph 25
risk adjustment for non-financial risk of incurred claims at the start of the periodNew group: no opening risk adjustment of incurred claimsparagraph 25
insurance acquisition cash flows not yet amortised at the start of the periodNew group: no opening unamortised acquisition cash flowsparagraph 25
share of coverage provided, cumulative, at the start of the periodNew group: no opening coverage providedparagraph 25
coverage units expected in the 1st year after the end of the periodUnits of the first five years greater than the future unitsparagraph 109
coverage units expected in the 1st year after the end of the periodNegative coverage unitsparagraph B119
confidence level corresponding to the risk adjustment for non-financial riskConfidence level outside 0 to 1 (0.75 for 75%)paragraph 119
portfolio of contracts of the groupAsset derecognised, but the group's portfolio has no line in the acquisition cash flow asset table: use exactly the same nameparagraphs 14, 28C
asset for insurance acquisition cash flows at the start of the periodNegative asset for acquisition cash flows at closing: derecognition or impairment greater than the assetparagraphs 28C, 28E
asset for insurance acquisition cash flows at the start of the periodNegative assetparagraph 28B
insurance acquisition cash flows paid in the period and recognised as an assetNegative amount paidparagraph 28B
impairment loss on the asset recognised in the periodNegative impairment: a reversal goes in its own columnparagraph 28E
impairment loss on the asset recognised in the periodImpairment greater than the available assetparagraph 28E
reversal of impairment losses on the asset recognised in the periodNegative reversalparagraph 28F
part of the closing asset expected to be derecognised in the 1st year after the end of the periodDerecognition expected over three years greater than the closing assetparagraph 109A
part of the closing asset expected to be derecognised in the 1st year after the end of the periodNegative amountparagraph 109A
asset for insurance acquisition cash flows derecognised when the group is recognisedAsset derecognised on a group already recognised: only when the group is recognisedparagraph 28C
asset for insurance acquisition cash flows derecognised when the group is recognisedAsset derecognised on a group without a portfolioparagraphs 28A, 28C
asset for insurance acquisition cash flows derecognised when the group is recognisedNegative asset derecognisedparagraph 28C
asset for insurance acquisition cash flows derecognised when the group is recognisedAsset 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 periodNegative contractual service marginparagraphs 38, 43
loss component at the start of the periodNegative loss componentparagraph 49
loss component at the start of the periodLoss component and contractual service margin both positiveparagraphs 48 to 50
risk adjustment for non-financial risk of the remaining coverage at the start of the periodNegative risk adjustment for non-financial riskparagraphs 37, B87
risk adjustment for non-financial risk of the remaining coverage at the end of the periodNegative risk adjustment for non-financial riskparagraphs 37, B87
risk adjustment for non-financial risk of incurred claims at the start of the periodNegative risk adjustment for non-financial riskparagraphs 37, B87
risk adjustment for non-financial risk of incurred claims at the end of the periodNegative risk adjustment for non-financial riskparagraphs 37, B87
liability for remaining coverage at the start of the period, excluding the loss componentPremium allocation approach column (opening liability) on a general model groupparagraph 29
expected premium receipts of the group for its whole coveragePremium allocation approach column (expected premiums) on a general model groupparagraph 29
insurance acquisition cash flows of the groupPremium allocation approach column (group acquisition cash flows) on a general model groupparagraph 29
share of coverage provided, cumulative, at the start of the periodPremium allocation approach column (coverage opening) on a general model groupparagraph 29
share of coverage provided, cumulative, at the end of the periodPremium allocation approach column (coverage closing) on a general model groupparagraph 29
fulfilment cash flows that relate to remaining coveragePremium allocation approach column (remaining coverage FCF) on a general model groupparagraph 29
facts and circumstances indicate an onerous group (paragraph 57)Onerous under paragraph 57 declared on a general model groupparagraphs 29, 57
discount rate determined at initial recognitionGeneral model column (locked-in rate) on a premium allocation approach groupparagraph 29
present value of the future coverage cash flows at the start of the periodGeneral model column (opening present value) on a premium allocation approach groupparagraph 29
risk adjustment for non-financial risk of the remaining coverage at the start of the periodGeneral model column (opening RA) on a premium allocation approach groupparagraph 29
risk adjustment for non-financial risk of the remaining coverage at the end of the periodGeneral model column (closing RA) on a premium allocation approach groupparagraph 29
contractual service margin at the start of the periodGeneral model column (opening CSM) on a premium allocation approach groupparagraph 29
insurance acquisition cash flows not yet amortised at the start of the periodGeneral model column (unamortised acquisition) on a premium allocation approach groupparagraph 29
coverage units provided in the periodGeneral model column (period units) on a premium allocation approach groupparagraph 29
coverage units expected to be provided after the end of the periodGeneral model column (future units) on a premium allocation approach groupparagraph 29
remaining coverage period at the start of the period, in yearsGeneral model column (remaining coverage period) on a premium allocation approach groupparagraph 29
share of the difference between premiums received and expected that relates to future serviceGeneral model column (future share of premium difference) on a premium allocation approach groupparagraph 29
share of the difference between insurance acquisition cash flows paid and expected that relates to current serviceGeneral model column (period share of acquisition difference) on a premium allocation approach groupparagraph 29
coverage units expected in the 1st year after the end of the periodGeneral model column (units year 1) on a premium allocation approach groupparagraph 29
coverage units expected in the 2nd year after the end of the periodGeneral model column (units year 2) on a premium allocation approach groupparagraph 29
coverage units expected in the 3rd year after the end of the periodGeneral model column (units year 3) on a premium allocation approach groupparagraph 29
coverage units expected in the 4th year after the end of the periodGeneral model column (units year 4) on a premium allocation approach groupparagraph 29
coverage units expected in the 5th year after the end of the periodGeneral model column (units year 5) on a premium allocation approach groupparagraph 29
discount rate determined at initial recognitionLocked-in rate to enter (non-zero)paragraph B72(b)
coverage units provided in the periodCoverage units of the period to enter, positiveparagraph B119
coverage units expected to be provided after the end of the periodNegative future coverage unitsparagraph B119
share of coverage provided, cumulative, at the start of the periodCumulative coverage outside 0 to 1paragraph B126
share of coverage provided, cumulative, at the end of the periodCumulative coverage outside 0 to 1paragraph B126
share of coverage provided, cumulative, at the end of the periodCumulative coverage at closing lower than at openingparagraph B126
share of coverage provided, cumulative, at the end of the periodCumulative coverage at closing to enterparagraph B126
expected premium receipts of the group for its whole coverageExpected premiums of the group to enter, positiveparagraph B126
fulfilment cash flows that relate to remaining coverageOnerous group: fulfilment cash flows of remaining coverage to enterparagraphs 57, 58
insurance acquisition cash flows recognised as expenses (paragraph 59(a))Paragraph 59(a) option reserved for the premium allocation approachparagraph 59(a)
incurred claims not discounted (paid within one year, paragraph 59(b))Paragraph 59(b) option reserved for the premium allocation approachparagraph 59(b)
share of the difference between premiums received and expected that relates to future serviceShare outside 0 to 1paragraph B96(a)
share of the difference between insurance acquisition cash flows paid and expected that relates to current serviceShare outside 0 to 1paragraph B96(a)
premiums received in the periodNegative amount paidinsurers' practice
insurance acquisition cash flows paid in the periodNegative amount paidinsurers' practice
incurred claims and other insurance service expenses paid in the periodNegative amount paidinsurers' practice
liability for incurred claims at the start of the periodLiability for incurred claims lower than its risk adjustmentparagraph 40(b), insurers' practice
timing of the cash flow after the base dateNegative timinginsurers' practice
undiscounted amount of the cash flowNegative amount: all amounts are entered as positiveinsurers' practice
base date of the cash flowIncurred claims to be entered with the closing basisparagraph 40(b)
nature of the cash flowCoverage cash flow on a premium allocation approach group: only incurred claims are enteredparagraph 55
group of contracts of the cash flowGeneral model group without opening cash flowsparagraphs 32, 33
group of contracts of the cash flowGeneral model group with future units but no closing cash flowsparagraph 40(a)
maturity of a point of the entered curveMaturity to enter, strictly positiveparagraph 36
maturity of a point of the entered curveMaturity already entered on another pointparagraph 36
spot rate of a point of the entered curveRate 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.

ResultFormulaArticle
Insurance service resultinsurance service result
revenue − expenses80(a)
Insurance revenuerevenue
revenue PAA + revenue GMM83, 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 expensesexpenses
group expenses + net impairment84, 28E, 28F
Insurance service expenses of the groups of contractsgroup expenses
incurred claims + period acquisition variance + acquisition amortisation + losses and reversals84, 103(b)
Impairment loss on the asset for acquisition cash flows, net of reversalsnet impairment
sum(impairment − impairment reversal)28E, 28F
ResultFormulaArticle
Net carrying amount of insurance contracts issued at the end of the period: portfolios that are liabilities less portfolios that are assetsinsurance contracts in the balance sheet
portfolios that are liabilities − portfolios that are assets78
Portfolios of insurance contracts issued that are liabilities at the end of the periodportfolios 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 flowsportfolio closing
groups closing − asset closing78, 99
Group linked to a portfolio of the portfolios tablein a portfolio
(portfolio ≠ "") + 0 ⊗ GMM14
Carrying amount of insurance contracts issued at the end of the periodinsurance contracts
LRC closing + LIC closing40
Portfolios of insurance contracts issued that are assets at the end of the periodportfolios 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.

LevelMessage
infoGroups 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.