Actuarial Reserve Adequacy & IBNR Analysis
Validate reserve adequacy and quantify IBNR exposure with actuarial precision
What You Can Do
You can systematically evaluate whether your insurance reserves are sufficient to cover incurred but not reported (IBNR) claims and identify reserve deficiencies. This skill analyzes claims development patterns, projects future claim emergence, and applies actuarial methods to assess reserve adequacy across product lines and underwriting years.
Features
Calculate incurred-but-not-reported claims using chain ladder, Bornhuetter-Ferguson, and other stochastic methods to quantify tail risk
Determine whether current reserve levels are sufficient against projected ultimate loss ratios and development patterns
Visualize historical claims development, identify acceleration/deceleration patterns, and detect emerging tail risks
Quantify reserve uncertainty with bootstrap methods and simulation to establish reserve ranges (e.g., 50th, 75th, 90th percentiles)
Compare your reserve levels against industry benchmarks, competitor data, and historical adequacy ratios
Model reserve impact under adverse scenarios: claims inflation spikes, higher frequency, longer tail development
Generate methodologies, assumptions, and sign-off documentation to support audit and regulatory compliance
Project cash flow, ultimate loss emergence, and reserve depletion schedules over future periods
Example Output
Example 1: IBNR Adequacy Summary
Reserve Adequacy Assessment — Q2 2026
Current Reserve Level: $45.2M
Projected Ultimate Loss: $48.7M (75th percentile)
Reserve Shortfall: $3.5M (7.3%)
Recommendation: INADEQUATE — Consider strengthening reserves by $3.5–5.1M (90th percentile)
Confidence: Medium (claims lag 18–24 months; only 3 years development)
Example 2: IBNR by Underwriting Year
UW Year | Reported | Est. Ultimate | IBNR | % IBNR | Reserve Adequacy
2023 | $12.1M | $13.4M | $1.3M| 9.7% | ✓ ADEQUATE
2024 | $18.6M | $22.1M | $3.5M| 15.8% | ✗ SHORT $2.1M
2025 | $5.2M | $8.9M | $3.7M| 41.6% | ✗ SHORT $1.8M
Example 3: Reserve Variability (Bootstrap 1,000 runs)
Percentile | Reserve Level | Shortfall vs. Current
50th | $46.8M | $1.6M
75th | $48.7M | $3.5M
90th | $50.3M | $5.1M
What's Included
- IBNR Calculation Templates: Ready-to-use spreadsheet templates for chain ladder, Bornhuetter-Ferguson, and Cape Cod methods with formula walkthroughs
- Reserve Adequacy Frameworks: Structured decision trees and thresholds for determining when reserves are adequate, adequate-with-monitoring, or inadequate
- Development Factor Libraries: Benchmark development factors and decay curves by line of business, claims lag, and reporting practice
- Validation Checklists: QA worksheets to verify data quality, methodology assumptions, reasonableness of results, and peer review sign-off
- Assumption Documentation Template: Standardized format for recording IBNR methodology, inflation assumptions, claims lag, tail factors, and sign-off
- Scenario Workbooks: Pre-built stress scenarios (inflation +5%, claims frequency +10%, tail extension) for sensitivity analysis
Who It's For
- Actuaries & Reserving Specialists
- Insurance Risk Managers & CROs
- CFOs & Finance Leaders (Insurance)
- Internal Audit & Compliance Teams
- Underwriting Managers
Best For
- Quarterly & Annual Reserve Validation
- IBNR Adequacy Assessment & Stress Testing
- Claims Tail Analysis & Run-Off Projection
- Regulatory & Audit Reserve Documentation
- Product Line Reserve Reviews
You might also like
This skill automates the validation of catastrophe risk models by testing parameter assumptions, verifying output accuracy, and documenting compliance with industry standards. You provide your model specifications, historical data, and outputs—Claude generates comprehensive validation reports, identifies assumption inconsistencies, and flags compliance gaps. It streamlines the governance process and reduces manual review time.
You can analyze climate and meteorological datasets to model catastrophe risks, assess hazard exposure, and quantify potential financial losses from extreme weather events. This skill transforms raw climate data into actionable risk scenarios that help you compare different climate futures and understand your organization's vulnerability to natural disasters.
Transform complex commercial applications, loss histories, and operational data into professional risk assessments and coverage recommendations. You'll receive structured underwriting documentation with detailed risk analysis, exposure mapping, and loss pattern evaluation that meet regulatory standards. Streamline your underwriting workflow with data-driven, consistent assessments tailored to each client's unique risk profile.
You can provide Claude with medical history, financial information, and lifestyle details from a life insurance application, and it will structure this data into a comprehensive underwriting assessment. Claude evaluates risk factors across medical, financial, and lifestyle dimensions, documents each finding, and produces a clear recommendation with supporting evidence. The result is a professional underwriting decision that's transparent, compliant, and audit-ready.
This skill systematically evaluates your portfolio's exposure to catastrophic events through concentrated risk analysis, multi-scenario stress testing, and data-driven positioning metrics. It produces executive summaries that quantify tail-risk exposure and recommend portfolio rebalancing actions based on statistical rigor. You can identify hidden correlations, model extreme market events, and communicate catastrophe risk exposure to stakeholders with clarity and precision.
Structure and validate insurance risk models in minutes, not weeks. Generate regulatory-compliant documentation, compliance frameworks, and model validation reports that underwriters and compliance teams can immediately use. Ensure all risk factors, parameters, and assumptions align with insurance regulations and internal governance standards.
This skill analyzes your fleet operations data to identify safety risks, quantify potential financial losses, and generate prioritized loss control recommendations. It scores compliance gaps, flags incident patterns, and provides actionable interventions tailored to your fleet's size, type, and operational context. Use it to reduce accidents, claims, and downtime while demonstrating measurable ROI for safety investments.
This skill automates the validation of catastrophe models by analyzing your data inputs, reviewing model assumptions against industry standards, identifying gaps and risks, and generating comprehensive validation reports ready for stakeholder review. You get systematic documentation of model strengths, weaknesses, and recommendation priorities—accelerating your pre-deployment sign-off, regulatory audits, and annual recalibration cycles.