inscalc.net

Overview

Open the calculator

At a glance

inscalc calculates online the IFRS 17 liabilities and profit or loss of insurance contracts issued, group of contracts by group of contracts, from your projected cash flows.

Free, no account: a session token is enough. In English and French, with the terms of the official versions of the Standard.

What it is for

  • Check an IFRS 17 calculation produced by another tool, component by component.
  • Prepare the presentation in the statement of financial position (paragraph 78) and the disclosures of the notes (paragraphs 100 to 132): statement of profit or loss, reconciliations, new contracts, CSM timing, rates, maturities, sensitivity.
  • Measure the effect of an assumption: discount curve, coverage units, group becoming onerous.
  • Learn on five complete examples, each figure linked to its paragraph of the Standard: Examples.

Confidentiality

No name, no e-mail address. Your entries are encrypted with a key derived from your token: without it, no one can read them. An unused session is erased after 30 days. The details: Data protection.

What it does

For an annual reporting period:

  • premium allocation approach (PAA), onerous groups included;
  • general measurement model for contracts without direct participation features: contractual service margin, loss component, risk adjustment for non-financial risk;
  • liability for incurred claims, under both approaches;
  • discounting with the EIOPA risk-free curve, updated every month, plus an illiquidity premium, or with an entered curve;
  • insurance finance expenses in profit or loss, or disaggregated with other comprehensive income (paragraph 88(b));
  • asset for insurance acquisition cash flows by portfolio (paragraphs 28B to 28F) and portfolios that are assets or liabilities (paragraph 78);
  • statement of profit or loss and reconciliations of paragraphs 101 and 103, in total and by group; analysis of revenue (paragraph 106), contracts recognised in the period (107), asset for acquisition cash flows (105A, 109A), CSM timing (109), confidence level and rates (119, 120), interest rate sensitivity (128), cash flow maturities (132): an Excel workbook;
  • each result with its formula and its paragraph of IFRS 17.

What it does not do

  • Contracts with direct participation features (variable fee approach).
  • Reinsurance contracts held.
  • Transition (Appendix C).
  • Interim periods: the period is the year ending on the closing date.
  • Cash flow projection and calculation of the risk adjustment for non-financial risk: they are inputs.
  • IFRS 9 and IFRS 18.

The simplifications of the calculation, and the direction of the error each may cause, are listed in the User guide.

What you need

By group of contracts:

  • the approach and the opening amounts: liabilities, loss component, contractual service margin;
  • the premiums received, the insurance acquisition cash flows and the claims paid in the year;
  • general model: the future cash flows projected at the start and at the end of the period, the locked-in rate, the risk adjustment for non-financial risk, the coverage units (including those of the next five years), the remaining coverage period and, for the differences between premiums received and expected and between acquisition cash flows paid and expected, the share relating to future service or to the period;
  • premium allocation approach: the expected premiums and the coverage provided;
  • the incurred claims still to be paid at the closing date;
  • where relevant, by portfolio, the asset for acquisition cash flows paid before the groups are recognised and its part allocated to each new group;
  • for the disclosures: the confidence level of the risk adjustment for non-financial risk and the interest rate shock of the sensitivity.

Try it

Open the IFRS 17 insurance contract calculation page, then “Open an example”: five fictitious companies ready to calculate, from the non-life insurer under the premium allocation approach to the onerous group under the general model, described with their key figures on the Examples page. How to use it: User guide.

Frequently asked questions

Is it free?

Yes, with no subscription and no account: a session token is enough to calculate, export and resume your work.

Is the variable fee approach (VFA) covered?

No. The calculation covers the premium allocation approach and the general model for contracts without direct participation features.

Are the tables of the notes produced?

Yes: the statement of profit or loss and the reconciliations of paragraphs 101 and 103, in total and by group of contracts, where each column runs from opening to closing, the portfolios that are assets and liabilities (paragraph 78), then the disclosures of paragraphs 105A to 132 (asset for acquisition cash flows, revenue, new contracts, CSM timing, rates, sensitivity, maturities), in an Excel workbook.

Where do the discount rates come from?

From the risk-free curve published every month by EIOPA, loaded automatically, plus the illiquidity premium you enter; or from a curve you enter.