Reinsurance Company Underwriting ModelFree Financial Model Download
Model reinsurance economics with premium growth by treaty, loss ratio assumptions, expense allocations, and underwriting ROE. Tracks combined ratio by line and includes catastrophe stress scenarios without assuming static combined ratios.
Free download. No sign-up required.
About this model
Model reinsurance underwriting profit, loss reserves, and investment income for a multi-line reinsurer navigating hard and soft market cycles. This template projects gross written premium (GWP) with cession rates for retrocession, calculates net earned premium (NEP) using two-year earning patterns (policies earn 50% in year written, 50% next year), and applies loss ratios and expense ratios to compute combined ratio. Reserve adequacy is tracked through reserve development and loss payout triangles.
The workbook contains a premium building sheet with NWP and UPR (unearned premium reserve) roll-forwards, a claims reserving sheet tracking incurred losses by cohort and payout patterns over 5+ years (long-tail lines carry reserves forward multiple years), an opex sheet with acquisition cost deferral via DAC (deferred acquisition costs), and an income statement combining underwriting profit (NEP less incurred losses and expenses) with investment income from the float. The balance sheet tracks loss reserves, DAC, and retro recoverables (receivables from retrocessionaires). Key ratios include loss ratio, expense ratio, combined ratio (target ≤95% for profitability), and premium/surplus ratio.
Target users are reinsurance company CFOs, insurance-focused PE investors, underwriting managers, and analysts evaluating reinsurers by underwriting cycle and investment performance in the $500M to $10B market cap range.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Reinsurance premium income by line and treaty type
- Incurred loss ratio and loss development assumptions
- Loss reserve adequacy and reserve strengthening scenarios
- Catastrophe loss scenarios and tail risk modeling
- Underwriting ROE and return on risk-adjusted capital
Line-of-business segmentation
Track premium, loss ratios, and profitability separately by property, casualty, specialty, and other lines to show where underwriting margins are earned.
Loss development and reserve adequacy
Model ultimate loss development, tail factors, and reserve adequacy by line to forecast future claims payments and reserve release or strengthening.
Catastrophe and tail risk stress testing
Include stressed scenarios for 100-year and 250-year natural disaster events to test capital adequacy and return on risk-adjusted capital.
Frequently asked
What is a reinsurance underwriting model?+
A model that projects reinsurance premium income, incurred losses, expense ratios, and underwriting ROE by line of business, used by reinsurers, investors, and rating agencies.
What is a combined ratio in reinsurance?+
Combined ratio equals loss ratio plus expense ratio. A ratio below 100% indicates underwriting profit; above 100% indicates an underwriting loss offset by investment income.
How do I model loss development and tail factors?+
Use historical loss development patterns by line to estimate ultimate losses, with longer tails applied to liability lines and shorter tails to property lines.
Can I model multiple catastrophe scenarios?+
Yes. The model includes probability-weighted 100-year, 250-year, and maximum reasonable loss scenarios to test whether capital is adequate under extreme events.
Who uses a reinsurance financial model?+
Reinsurers use it for underwriting strategy and pricing, insurance investors for book value analysis, and brokers and rating agencies for capacity and credit assessment.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Insurance Portfolio Risk and Return Model
Portfolio model for insurance investment holdings including asset allocation, duration matching, credit risk, and spread analysis.
Life Insurance Valuation Model
Valuation model for life insurance products and in-force book value using mortality assumptions and surrender rates.
Captive Insurance Company Model
Captive insurer financial projections and reinsurance analysis.
InsurTech Operating and Valuation Model
Operating model for insurance tech platforms including underwriting volumes, loss ratios, expense ratios, and insurance-linked returns.