Calculator Inputs
Use cumulative values by accident year and development age. Leave future cells blank where development is not yet observed.
Example Data Table
This example shows a typical cumulative triangle. Earlier accident years are more developed, while recent years have more blank future periods.
| Accident Year | 12 Months | 24 Months | 36 Months | 48 Months | 60 Months |
|---|---|---|---|---|---|
| 2021 | 120,000 | 180,000 | 210,000 | 225,000 | 230,000 |
| 2022 | 132,000 | 196,000 | 222,000 | 235,000 | - |
| 2023 | 145,000 | 208,000 | 236,000 | - | - |
| 2024 | 158,000 | 226,000 | - | - | - |
| 2025 | 171,000 | - | - | - | - |
Formula Used
1) Individual age-to-age link ratio
Link Ratio = Next Development Value ÷ Current Development Value
2) Selected development factor
The calculator applies your chosen method, such as volume weighted average, simple average, median, trimmed average, or last three average.
3) Cumulative development factor to ultimate
CDF to Ultimate = Product of all selected future age-to-age factors × Tail Factor
4) Projected ultimate loss
Projected Ultimate = Latest Observed Cumulative Loss × CDF to Ultimate
5) IBNR estimate
IBNR = Projected Ultimate − Latest Observed Cumulative Loss
6) Loaded reserve
Loaded Reserve = IBNR × (1 + Reserve Loading %)
7) Stress ultimate
Stress Ultimate = Projected Ultimate × (1 + Stress Margin %)
How to Use This Calculator
- Choose the measure type, such as incurred or paid losses.
- Enter cumulative triangle values by accident year and development age.
- Select a factor method that matches your reserving preference.
- Set the tail factor for late development beyond the last age.
- Optionally add stress margin and reserve loading assumptions.
- Click the calculate button to generate selected factors and reserve estimates.
- Review the factor tables, CDFs, projected ultimate losses, and IBNR.
- Download the results as CSV or PDF for sharing and documentation.
Frequently Asked Questions
1) What is a loss development factor?
A loss development factor measures how cumulative losses grow from one development age to the next. It helps estimate ultimate losses from incomplete claim development data.
2) Why should I use cumulative values instead of incremental values?
Traditional chain-ladder style development factors are calculated from cumulative triangles. Cumulative values make age-to-age ratios stable and easier to compare across accident years.
3) What does the tail factor represent?
The tail factor captures expected development beyond the last reported age in your triangle. It is useful when claims continue developing after the latest available maturity.
4) Which selection method should I choose?
Volume weighted is common when larger years should influence factors more. Simple averages treat each year equally. Median and trimmed averages reduce the effect of outliers.
5) What does IBNR mean in this calculator?
IBNR here is the projected future development still expected after the latest observed cumulative amount. It equals projected ultimate losses minus the latest recorded cumulative value.
6) Can I leave cells blank?
Yes. Blank cells are expected for immature accident years. The calculator only uses matched development pairs where both ages contain valid cumulative amounts.
7) What is the loaded reserve output?
Loaded reserve adds your chosen reserve loading percentage to IBNR. It provides a practical adjusted reserve view for internal planning, scenario testing, or conservative booking.
8) What does the chart show?
The chart compares latest reported cumulative losses with projected ultimate losses for each accident year. It helps you quickly visualize remaining development and reserve pressure.