This calculator is a tool developed in MS Excel environment to measure the Asset for Remaining Coverage by simplified measurement model, Premium Allocation Approach, defined based on the requirements of new international international accounting standard IFRS 17 and our experience with its implementation.
The calculator is open so the user can go through the whole calculation step by step without any restraints.
Key benefits of our solution:
- Help to understand the full data request and workflow for IFRS 17
- Able to process premium allocation approach for one group of reinsurance contract held and help you to produce financial results on your own data in understandable MS Excel file.
To have at disposal total carrying amount of reinsurance contracts held, the calculator also includes measurement of the Asset for Incurred Claims by general model approach. You are thus able to measure the carrying amount of reinsurance contracts held at each monthly reporting period.
After execution of the calculation, you can display the Statement of financial position, the Statement of financial performance and reconciliation tables required by the Standard.
If you are interested how the IFRS 17 principles should be reflected in your general ledger, you can also display journal entries based on predefined chart of accounts and accounting scheme.
Both input data and output data used for preparation of reports and journal entries are in database form so you can define which data you will need to store.
The calculator is primarily developed for real calculations, but you can also use it to support IFRS 17 implementation process – each of the process step is in detail explained and defined. The user does not need any additional documentation.
This tool is not a black box and it can be easily customized it by your needs – you can do it by yourself or you can ask us to support you with it.
It could be used separately as a stand-alone calculator or if you need more complex solution it can be a part of our IFRS 17 Cube solution (see link below).
We have also other IFRS17 tools. For further information follow the link at each tool:
IFRS17 GMA proxy calculator - link
IFRS17 PAA calculator - link
IFRS17 Transition calculators - link
IFRS17 Cube solution - link
IFRS17 Add-ins - link
IFRS17 Eligibility tools - link
IFRS17 Illustrative models - link
We often support client also directly as consultants. For further information about our IFRS17 services, please follow the link.
For further information about IFRS 17, see also our useful links.
If you have any questions please use the contact form below.