InsurTech Operating and Valuation ModelFree Financial Model Download
Forecast insurtech profitability by modeling premium volume growth, underwriting margins, customer acquisition payback, and investment income from float. Track cohort-level profitability from acquisition through renewal and assess combined ratio trends by line of business.
Free download. No sign-up required.
About this model
This operating model forecasts InsurTech profitability by projecting premium volume growth across distribution channels, calculating underwriting and administrative expense ratios, forecasting loss ratios and loss adjustment expenses, and computing investment income from premium float. Answer: can the platform sustain combined ratios <100% and generate positive underwriting profit while scaling customer acquisition?
The workbook builds premium revenue from multiple lines of business (auto, home, specialty) and channels (direct digital, partner distribution, B2B). Customer acquisition cost (CAC) targets: Year 1–2 £100–200 per customer for digital, declining with scale. Loss ratio (incurred losses / premiums) by line: auto 65–75%, home 60–70%, specialty 55–75%. LAE (loss adjustment expense) 8–12% of premium. Commissions and admin expenses 20–25% of premium. Investment income on premium float (float earning yield on treasury + credit investments). Combined ratio (losses+LAE+expenses / premium) must stay <95–100% for sustainability. Breakeven premium scale: typically £50M–100M annual premium depending on loss experience and expense run-rate.
Used by InsurTech founders raising Series A/B funding, PE sponsors acquiring digital insurance platforms, and traditional carriers evaluating digital strategies. The model reveals the capital intensity of customer acquisition (CAC payback 2–4 years depending on retention) and sensitivity to loss ratio assumptions (1% change in loss ratio impacts combined ratio by 1pp, often wiping out profitability). Premium float investment income is material (2–3% annually), but growth phase companies often spend float on marketing rather than retaining for investment. Benchmarks: Lemonade (underwriting loss offset by investment income), Root, Oscar—all targeting sub-100% combined ratios at scale.
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
- Premium volume growth by line of business and distribution channel
- Loss ratio and loss adjustment expense as a percentage of premium
- Commissions and administrative expenses
- Customer acquisition cost and lifetime value by channel
- Investment income from premium float and combined ratio analysis
Premium and customer cohort modeling
Track cohort profitability from acquisition through retention and model premium growth, loss inflation, and renewal margins by vintage.
Underwriting economics and loss ratio trends
Model loss ratios by line of business, incorporate claim inflation trend assumptions, and forecast combined ratios over the projection period.
Float and investment income
Calculate available float from unearned premiums and claim reserves, model investment returns on that float, and show contribution to overall profitability.
Frequently asked
What is the combined ratio and how does it relate to profitability?+
Combined ratio equals losses plus LAE plus commissions plus expenses, divided by premiums. Below 100% means underwriting profit. Above 100% means underwriting loss, though investment income from float can offset that loss.
What loss ratio should I assume for a new insurtech line?+
Start conservative at 60-70% for auto or homeowners lines and 50-60% for higher-margin specialty lines. Refine using historical data or peer benchmarks, and model loss ratio inflation at 3-5% annually.
How do I calculate CAC payback?+
CAC payback equals customer acquisition cost divided by annual underwriting profit per customer. A payback period of 2-3 years or less is generally healthy for profitable insurance businesses.
Who uses insurtech financial models?+
InsurTech founders, insurance investors, P&C underwriters, and insurance VCs use these models for underwriting profitability analysis, customer acquisition strategy, and company valuation.
What is premium float and why does it matter?+
Float is the pool of premiums collected but not yet paid out as claims. Insurers invest this float, generating income that can subsidize underwriting losses. Larger float and higher investment yields improve overall profitability.
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.
Captive Insurance Company Model
Captive insurer financial projections and reinsurance analysis.
Reinsurance Company Underwriting Model
Reinsurance premium income, claims reserves, underwriting margin, and ROE for reinsurance portfolios.
Life Insurance Valuation Model
Valuation model for life insurance products and in-force book value using mortality assumptions and surrender rates.