Actuarial Pricing Memo Builder
Build compliant actuarial pricing memos with loss analysis and rate justification
What You Can Do
Generate professional pricing memos that combine loss experience analysis, actuarial calculations, and regulatory justification. The skill structures your memo with standard sections—executive summary, loss analysis, trend calculations, and rate recommendations—while ensuring compliance with state filing requirements and actuarial standards of practice.
Features
Summarize historical claims data, calculate loss ratios, and identify trends across policy years
Document actuarial reasoning with explicit assumptions, trend factors, and premium calculations
Ensure alignment with state insurance code, NAIC standards, and anti-discrimination requirements
Project future loss experience with frequency and severity adjustments, inflation factors, and margin analysis
Follow industry-standard formatting with executive summary, loss analysis, rate calculations, and compliance certification
Generate appendices with loss runs by class code, premium volume history, loss ratio progression, and detailed exhibits
Articulate all actuarial assumptions, data sources, and methodologies for transparency and auditability
Example Output
Example 1: Commercial Auto Rate Filing
ACTUARIAL PRICING MEMO
Proposed Rate Change: +8.5% | Target Loss Ratio: 68% | Effective Date: January 1, 2025
Executive Summary
Based on comprehensive loss experience analysis (2022-2024) and industry trend data, an average rate increase of 8.5% is actuarially justified to achieve sustainable loss ratios.
Loss Experience
- 3-year average loss ratio: 74.2%
- Frequency trend: +2.1% annually
- Severity trend: +3.8% annually
- Benchmark loss ratio: 68%
Rate Justification
Current premium is inadequate by 6.2%. Adjustment factors: Trend (+5.9%) + Inflation (+2.3%) − Margin (−0.5%) = +8.5% net rate change
Example 2: Workers Compensation Adjustment
WC RATE FILING MEMO
Proposed Change: −3.2% Decrease | Filing Jurisdiction: [State]
Loss Ratio Analysis
- Current-year loss ratio (trended): 62.1%
- Target loss ratio: 65.0%
- Variance: −2.9% (favorable)
Medical & Indemnity Trends
- Medical cost trend: +4.2% annually
- Frequency trend: −1.1% (safety improvements)
- Net combined trend: +2.1%
Supporting Schedules
✓ Schedule A: 5-year loss experience by class code | ✓ Schedule B: Premium volume and rate history | ✓ Schedule C: Medical/indemnity breakdown
What's Included
- Memo template structure: Standard sections (executive summary, loss analysis, assumptions, rate calculation, compliance certification) following actuarial society and NAIC guidelines
- Loss analysis section builder: Organize and summarize historical claims data with loss ratios, frequency, severity, and trend calculations
- Rate calculation framework: Step-by-step methodology for computing trend-adjusted loss costs and premium recommendations
- Compliance checklist: Verify alignment with state insurance code, non-discrimination requirements, and regulatory disclosures
- Supporting schedule templates: Appendices for loss runs, premium history, class code detail, and detailed calculation exhibits
- Assumption documentation: Transparent articulation of all actuarial assumptions, data sources, and methodological choices
Who It's For
- Actuaries and actuarial analysts
- Rate filing specialists and compliance officers
- Insurance underwriting managers
- Product development and pricing managers
- Insurance brokers and consultants
Best For
- Rate filing submissions to state insurance departments
- Premium justification and pricing strategy development
- Regulatory compliance documentation and audit readiness
- Post-audit loss analysis and trend documentation
- Cross-functional pricing communication with executive stakeholders
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.