analyzing-insurance-financials
Structures insurance company financial analysis with combined ratio, reserve adequacy, and capital metrics. Use when analyzing insurance financials, evaluating combined ratios, or assessing reserve strength.
Best use case
analyzing-insurance-financials is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
Structures insurance company financial analysis with combined ratio, reserve adequacy, and capital metrics. Use when analyzing insurance financials, evaluating combined ratios, or assessing reserve strength.
Teams using analyzing-insurance-financials should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/analyzing-insurance-financials/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How analyzing-insurance-financials Compares
| Feature / Agent | analyzing-insurance-financials | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Structures insurance company financial analysis with combined ratio, reserve adequacy, and capital metrics. Use when analyzing insurance financials, evaluating combined ratios, or assessing reserve strength.
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# Analyzing Insurance Financials Structures insurance company financial analysis around underwriting profitability, reserve adequacy, investment performance, and capital strength to produce actionable assessments of insurer financial health. ## When To Use - Evaluating an insurer's underwriting discipline via combined ratio decomposition - Assessing loss reserve adequacy for due diligence, M&A, or regulatory review - Benchmarking capital and solvency metrics against rating agency thresholds - Analyzing reinsurance program effectiveness and net retention exposure - Reviewing statutory filings (Annual Statement, Quarterly Statement) or GAAP financials for trend analysis - Supporting investment decisions in insurance equities, surplus notes, or ILS ## Inputs To Gather - **Financial statements**: Statutory Annual/Quarterly Statements (filed with NAIC), GAAP 10-K/10-Q, or IFRS 17 reports - **Line-of-business detail**: Schedule P (loss development triangles), Schedule H (accident & health), or equivalent breakdowns - **Investment portfolio**: Schedule D (bonds), Schedule BA (other invested assets), asset quality distribution - **Reinsurance structure**: Schedule F (ceded reinsurance), Schedule S (reinsurance assumed), treaty summaries - **Rating agency reports**: AM Best, S&P, Moody's, or Fitch insurer financial strength ratings and rationale - **Peer/industry benchmarks**: NAIC industry aggregates, SNL/S&P Capital IQ comparables, or relevant cohort data - **Time horizon**: Minimum 3-5 years of historical data for trend analysis; 10 years preferred for reserve development ## Workflow 1. **Classify the insurer** — Identify line mix (P&C vs. life/health vs. multiline), domicile, and regulatory regime. Note whether analysis uses statutory accounting (SAP), GAAP, or IFRS 17. [VERIFY] applicable accounting framework and jurisdictional requirements. 2. **Decompose the combined ratio** - Calculate loss ratio (net incurred losses / net earned premiums) by accident year and calendar year - Calculate expense ratio (underwriting expenses / net written premiums for SAP; / net earned premiums for GAAP trade ratio) - Break out loss adjustment expense (LAE) into defense & cost containment (DCC) vs. adjusting & other (A&O) - Compute combined ratio = loss ratio + expense ratio; flag any result above 100% (underwriting loss) - Analyze trends over 3-5 years; identify deteriorating or improving lines of business 3. **Evaluate reserve adequacy** - Review Schedule P loss development triangles (paid and incurred) for the most recent 10 accident years - Calculate development factors and compare to industry benchmarks - Identify adverse or favorable prior-year reserve development and quantify impact on calendar-year results - Assess carried reserves vs. actuarial central estimate — note any margin (redundancy) or deficiency - Flag lines with long-tail exposure (e.g., general liability, workers' comp, professional liability) for deeper review 4. **Analyze investment portfolio and yield** - Compute net investment income yield (NII / average invested assets) - Review asset allocation: percentage in investment-grade bonds, equities, alternatives, real estate, cash - Assess credit quality distribution (NAIC designation 1-6 for statutory; rating agency equivalents) - Calculate total return on invested assets including realized/unrealized gains - Evaluate asset-liability duration matching — flag significant mismatches 5. **Assess capital adequacy and leverage** - Calculate net premiums written to policyholders' surplus (NPW/PHS) — flag if >3:1 for P&C [VERIFY] threshold by line - Review Risk-Based Capital (RBC) ratio (Total Adjusted Capital / Authorized Control Level) — regulatory minimum is 200% company action level - Compute net leverage ratio (net liabilities / PHS) and gross leverage including reinsurance recoverables - Analyze quality of surplus: note any surplus notes, goodwill, DTA, or non-admitted assets reducing adjusted surplus - Compare to AM Best Capital Adequacy Ratio (BCAR) thresholds for target rating level 6. **Evaluate reinsurance program** - Assess ceded ratio (ceded premiums / gross written premiums) — high cession may indicate capital constraints - Review reinsurer credit quality and concentration risk (Schedule F penalties for unauthorized/undercollateralized reinsurers) - Analyze net retention relative to surplus for catastrophe and per-risk exposures - Identify any commutation activity or material disputes in reinsurance recoverables 7. **Benchmark and synthesize** - Compare all key metrics to peer group and industry medians - Identify outlier metrics (positive or negative) and explain drivers - Assign qualitative assessment of financial strength: strong / adequate / marginal / weak - Highlight key risks: reserve uncertainty, catastrophe exposure, investment concentration, reinsurance dependency ## Output Structure the analysis report with the following sections: - **Executive Summary**: One-paragraph financial health assessment with key metrics and conclusion - **Company Profile**: Line mix, domicile, size (DPW, total assets, surplus), rating history - **Underwriting Analysis**: Combined ratio decomposition with 3-5 year trend tables by line - **Reserve Analysis**: Development triangle summary, prior-year development history, adequacy assessment - **Investment Analysis**: Portfolio composition, yield analysis, credit quality, duration - **Capital & Leverage**: RBC ratio, NPW/PHS, net leverage, surplus quality, BCAR positioning - **Reinsurance Review**: Ceded ratio, reinsurer quality, net retention adequacy - **Peer Comparison**: Side-by-side table of key metrics vs. selected comparables - **Key Risks & Considerations**: Bullet list of material risk factors with severity indication - **Appendix**: Supporting schedules, data sources, glossary of metrics ## Quality Checks - Confirm all ratios use consistent numerator/denominator definitions (SAP vs. GAAP vs. trade basis) — do not mix frameworks - Verify that loss development triangles foot to Schedule P Part 1 summary and that incurred = paid + case reserves + IBNR - Cross-check that NPW reconciles across the income statement, balance sheet, and Schedule T (state page) - Ensure RBC ratio uses the correct formula for entity type (P&C vs. life vs. health) [VERIFY] - Validate that reinsurance recoverables on the balance sheet tie to Schedule F detail - Confirm peer benchmarks are from the same reporting period and use the same accounting basis - Flag any metric where data was estimated, interpolated, or unavailable with [VERIFY] - Check that all trend commentary is supported by the underlying numerical data — no unsupported qualitative claims
Related Skills
managing-dental-insurance-coding
Assigns CDT codes with procedure-specific documentation and insurance submission requirements. Use when coding dental procedures, submitting dental claims, or managing CDT code selection.
analyzing-vital-statistics
Structures vital records analysis with birth, death, and demographic trend reporting. Use when analyzing vital statistics, interpreting mortality data, or reporting demographic trends.
analyzing-social-determinants-of-health
Maps social determinants affecting health outcomes with intervention strategy development. Use when analyzing SDOH, mapping community resources, or designing social health interventions.
analyzing-pharmacovigilance-data
Structures post-marketing safety surveillance with signal detection and PSUR reporting. Use when analyzing safety signals, preparing PSURs, or managing pharmacovigilance data.
analyzing-flow-cytometry
Interprets flow cytometry panels for hematologic malignancy classification and minimal residual disease. Use when analyzing flow cytometry, classifying lymphomas/leukemias, or documenting immunophenotyping.
analyzing-epidemiological-data
Structures epidemiologic analysis with incidence, prevalence, rate calculations, and statistical inference. Use when calculating disease rates, analyzing epi data, or interpreting population statistics.
analyzing-clinical-trial-data
Structures clinical trial data analysis with primary endpoint evaluation and safety reporting. Use when analyzing trial results, evaluating endpoints, or preparing statistical reports.
analyzing-clinical-data-warehouses
Structures clinical data warehouse queries for quality measurement, research, and operational analytics. Use when querying clinical data, building analytics reports, or extracting research datasets.
insurance-policy-summary
Produces structured, citation-backed summaries of U.S. insurance policies, endorsements, claims files, and coverage correspondence for coverage analysis and insurance litigation. Use when summarizing policies, declarations, claims files, reservation-of-rights letters, denial letters, or coverage disputes.
insurance-correspondence-summarization
Produces structured summaries of insurance claims correspondence including coverage letters, reservation of rights (ROR), denial letters, and claim file documents. Extracts policy details, coverage positions, claims chronology, settlement posture, and liability exposure. Use when summarizing claim files, coverage disputes, ROR letters, denial letters, or multi-document insurance correspondence threads.
insurance-claim-summaries
Generates structured summaries of U.S. insurance claim files covering identification, incident narrative, party positions, coverage analysis, and resolution status. Use when synthesizing claim files for adjusters, legal counsel, or claims managers during pre-filing review, discovery, or settlement preparation. Trigger keywords: claim summary, insurance claim, coverage summary, adjuster summary, coverage denial, reservation of rights.
insurance-certificate-compliance
Produces requirement-by-requirement CRE insurance certificate compliance reviews by analyzing ACORD 25 certificates and endorsements against Access Agreement terms. Use when the user mentions COI review, insurance compliance, ACORD 25 analysis, Additional Insured verification, primary/non-contributory status, waiver of subrogation, vendor insurance audit, CGL compliance, umbrella follow-form, broker-ready deficiency instructions, certificate holder vs. additional insured, AI endorsements (CG 20 10, CG 20 37), or carrier rating checks.