Chain-ladder IBNR - step by step guide

Version 6



    The attached workbook is a step-by-step guide on how to calculate chain-ladder IBNR.


    Besides being handy for potential readers in the insurance sector on how to calculate chain-ladder IBNR, these calculations are also valuable for anyone who wants a deeper understanding of table calculations. These calculations were definitely an eye-opener for myself in this regard.


    The calculations appeared originally in following threads:


    Chain-ladder table calculation - Question 1

    Chain-ladder table calculation - Question 2

    Chain-ladder table calculation - Question 3




    Chain-ladder Table Calculations Result.png

    Chain-ladder Table Calculations Step-by-Step.png

    Tableau Version:    8.1

    Original Author:   Dan Huff    Kettan