Free Excel templates

A free IFRS 17 CSM Roll-Forward Calculator in Excel

Four live worksheets covering GMM CSM roll-forwards and the OCI option, Onerous Loss Components and Reinsurance Loss-Recovery (IFRS 17.66A), PAA discounted LIC, and VFA participating savings.

Pre-loaded with Meridian Life & General Insurance plc (MLG) in USD thousands ($000): Cohort A starts with $6,832.6k initial CSM and unwinds its Year 2 OCI gain (+$244.6k) to $0.0k at Year 5; Cohort B books a $3,868.7k Day-1 onerous loss offset by a +$1,547.5k 40% reinsurance loss-recovery component; Cohort C produces a 93.29% IFRS 17 combined ratio; Cohort D absorbs +12% and -8% market swings directly into its $2,538.4k VFA CSM.

Get the Excel calculator

One Excel workbook, no macros, nothing locked. Enter your email address and the download opens immediately, along with the other free practitioner models.

IFRS_17_CSM_Roll_Forward_Calculator.xlsx (19 KB)

You join the reader list: occasional notes when new models or handbooks release. Unsubscribe in one click. How your address is used.

The book behind this calculator

The IFRS 17 Handbook walks through every equation, journal entry, and disclosure table for Meridian Life & General Insurance plc across GMM, PAA, VFA, Onerous Contracts, Reinsurance Held, and Transition (FRA/MRA/FVA).

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is inside the 4 tabs

Related reading