Actuarial Reserve Adequacy Analyzer
Build defensible reserve analyses with validated assumptions and regulatory compliance
What You Can Do
You can construct rigorous reserve adequacy analyses that document every assumption, test sensitivity across realistic ranges, and produce variance explanations aligned with regulatory standards. The skill ensures your reserve valuations are defensible to auditors and regulators, with clear audit trails showing how each assumption drives reserve levels and enables confident sign-off.
Features
Systematically capture and organize all reserve assumptions with explicit rationale, data sources, and confidence levels for complete governance trails
Run parameterized sensitivity analyses across realistic ranges for interest rates, mortality, expense trends, and lapse assumptions with pivot-table style output
Generate multivariate scenario testing using correlated assumption paths to evaluate reserve adequacy under extreme market and operational conditions
Automatically decompose year-over-year reserve changes into assumption updates, model refinements, and experience variances with regulatory-compliant explanations
Cross-check reserve methodologies against IFRS 17, ASC 944, Solvency II, and NAIC standards with automated compliance recommendations
Measure the isolated and combined reserve impact of each assumption change to prioritize calibration efforts and board communication strategies
Generate formatted workpapers with assumption rationale, sensitivity tables, compliance references, and reviewer sign-off sections for external audits
Example Output
Assumption Documentation Output:
Assumption: Mortality Improvement
Current Value: 1.5% annual improvement
Data Source: Internal experience 2020–2024, CMI tables
Confidence Level: High (95% credible interval)
Regulatory Basis: NAIC Valuation Manual Section 3
Sensitivity Impact: ±0.5% variance = ±$2.3M reserve impact
Sensitivity Analysis Summary:
| Scenario | Interest Rate ±100bps | Mortality ±10% | Expense Trend ±2% | Combined Impact |
|---|---|---|---|---|
| Low | $95M | $98M | $101M | $92M |
| Base | $103M | $103M | $103M | $103M |
| High | $112M | $108M | $105M | $115M |
Variance Bridge (Year-over-Year):
- Prior year reserve: $100.0M
- Experience gain: +$1.2M (actual vs assumed mortality)
- Assumption updates: −$2.1M (interest rate decline)
- Model refinement: +$3.5M (new expense data)
- Current year reserve: $102.6M (variance: +2.6% explained)
What's Included
- Assumption Template Library: Pre-built templates for life, annuity, and health insurance liabilities with built-in regulatory references and industry benchmarks
- Sensitivity Matrix Tool: Interactive calculator for stress-testing reserves across 5–10 assumptions simultaneously with automated pivot tables and tornado charts
- Compliance Checklist Framework: Dynamic checklists for IFRS 17, ASC 944, Solvency II, and NAIC requirements with skip-logic based on product type and jurisdiction
- Variance Decomposition Workpaper: Automated waterfall analysis breaking down YoY reserve changes by component with detailed explanations and audit sign-off sections
- Executive Summary Generator: Produce board-ready summaries of reserve adequacy, key risks, and management recommendations backed by documented sensitivity results
- Audit Defense Portfolio: Compile all workpapers, assumption rationales, sensitivity results, and regulatory mappings into a single audit-ready deliverable
Who It's For
- Reserve Actuaries and Valuation Teams
- Chief Financial Officers overseeing reserve adequacy
- External and Internal Auditors
- Regulatory Compliance and Model Governance Teams
- Insurance Enterprise Risk Management Functions
Best For
- Year-end reserve adequacy validation and sign-off
- IFRS 17 and ASC 944 compliance reviews
- Assumption change impact quantification and board communication
- Reserve trend and sensitivity analysis for investor reporting
- Audit preparation and external reviewer collaboration
You might also like
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.
You analyze diverse climate datasets, quantify emerging climate risks, and generate underwriting-ready catastrophe model parameters. This skill converts complex climate science into actionable inputs for risk assessment, enabling you to stress-test portfolios against climate scenarios and refine model calibration with empirical climate trends.
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.
You can build production-ready ML pipelines that start with data validation and progress through model training, evaluation, and deployment. Cortex detects your ML stack, defines success metrics upfront, builds baseline models before optimization, and generates serving-ready artifacts—eliminating manual workflow steps and reducing time from data to deployed model.
This skill analyzes medical histories, diagnoses, and clinical data to generate risk assessments and coverage recommendations for health insurance underwriting. You can streamline initial reviews, evaluate pre-existing conditions, and document coverage decisions with regulatory compliance checks built in. The skill helps you process medical documentation faster while maintaining consistency and accuracy in your risk evaluation process.
Analyze your insurance portfolio to identify concentration risk across perils, geographies, and underwriting assumptions. Validate catastrophe model outputs against real exposure data and flagged data gaps. Generate concise executive risk summaries that highlight key vulnerabilities and inform underwriting decisions.
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.