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
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.
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 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 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.