Portfolio Catastrophe Risk Analysis
Quantify portfolio cat risk, validate underwriting models, summarize for executives
What You Can Do
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.
Features
Quantify portfolio exposure aggregation by peril, region, and loss-of-value scenarios. Identify single points of failure in your underwriting.
Cross-check modeled loss estimates against historical claims, exposure assumptions, and known vulnerabilities. Flag unrealistic assumptions.
Detect gaps in exposure data—missing geocodes, incomplete line-of-business detail, outdated building characteristics—and estimate impact on model credibility.
Run portfolio-level stress tests across peril combinations (e.g., Florida hurricane + wildfire in California) to assess tail risk exposure.
Visualize risk concentration with aggregated loss potential by location and peril type, making concentration immediately obvious to decision-makers.
Produce narrative risk summaries highlighting concentration findings, model validation concerns, and underwriting recommendations.
Calculate loss ratios, concentration indices, and tail-risk metrics that position your portfolio relative to industry benchmarks.
Example Output
Portfolio Concentration Summary
- Florida Hurricane Exposure: $450M (18% of portfolio) in coastal counties; 75th percentile for peer group
- Model Validation: Modeled loss for worst historical hurricane (2004 Charley equivalent) is 22% lower than actual claims; assumptions may underestimate secondary perils (storm surge, wind-driven rain)
- Data Quality: 8% of properties missing zip code; 12% lack construction year—estimated 3–5% variance in model accuracy
- Executive Recommendation: Reduce Florida new-business target to $400M; re-calibrate model for secondary perils before next renewal cycle
Stress Test Result Scenario: 2024 Florida Hurricane + 2023 California Wildfire Simultaneous Event → Estimated 90th percentile portfolio loss: $680M (vs. $420M average annual loss)
What's Included
- Portfolio Analysis Template: CSV schema for exposure data (lines, limits, geocodes, construction type, occupancy) formatted for rapid risk analysis.
- Model Validation Checklist: Standardized questions and data points to audit catastrophe model assumptions (peril correlation, secondary perils, intensity decay).
- Risk Concentration Framework: Quantitative methods to calculate concentration indices, identify aggregate exposures, and flag concentration thresholds for review.
- Executive Summary Generator: Prompt templates and decision-tree logic to translate technical findings into boardroom-ready risk narratives.
- Stress Test Library: Pre-built scenarios (single peril, multi-peril, geographic clusters) to stress-test portfolio loss under tail-risk conditions.
Who It's For
- Insurance Underwriters
- Portfolio Risk Managers
- Chief Risk Officers & Compliance Teams
- Reinsurance Brokers & Risk Consultants
- Quantitative Risk Modelers
Best For
- Catastrophe Risk Concentration Analysis
- Model Assumption Validation & Audit
- Executive Risk Reporting & Board Presentations
- Portfolio Stress Testing & Scenario Analysis
- Underwriting Decision Support & New Business Review
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 rapidly assess commercial loan applications by analyzing financial statements, credit history, industry dynamics, and collateral. Claude generates comprehensive risk memos with clear underwriting recommendations, enabling you to make faster, better-documented lending decisions with consistent risk evaluation criteria across your portfolio.
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.
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.