InsurTech Operating and Valuation Model

The model builds revenue from policies in force and average premium per policy to get gross written premium (GWP). Ceded reinsurance premium is then subtracted to produce net written premium (NWP), and the change in unearned premium reserve (UPR) converts that into net earned premium (NEP).

• This distinction matters: GWP is not P&L revenue because premiums are earned over the policy term, typically six or twelve months. Growth assumptions range from 20%–60% for early-stage carriers, decelerating to 10%–20% at scale.
• Embedded API distribution, cross-sell, and rate adequacy are the primary growth levers, while digital customer acquisition cost inflation and reinsurance capacity constraints act as headwinds. Investment income adds a second revenue stream: average invested assets, or float, multiplied by portfolio yield.

Float grows as premiums are collected upfront and claims are paid later, so a growing book generates cash even when underwriting is unprofitable.

Incurred losses are calculated as NEP multiplied by the loss ratio, while paid claims follow a development pattern (for example, 40% in year one, 30% in year two, and 30% thereafter). The difference between cumulative incurred and cumulative paid forms loss reserves, split between case reserves and IBNR.

• Loss adjustment expenses cover claims staff, legal costs, and AI-driven processing. Operating expenses are tracked by category: sales and marketing at 15%–25% of GWP for growth-stage carriers, technology and engineering at 8%–15% of NEP, plus G&A, policy administration, compliance, and reinsurance brokerage.
• These costs feed into the loss ratio, expense ratio, and combined ratio. The design assumes early-stage combined ratios of 95%–130% improving to 85%–95% at maturity, reflecting the operating leverage that comes with scale and better risk selection.

The model captures this improvement trajectory rather than holding a flat loss ratio.

The model produces an income statement, balance sheet, cash flow statement, capital adequacy schedule, and KPI dashboard. The income statement shows NEP, fee income, and investment income, then subtracts incurred losses, LAE, and operating expenses to arrive at underwriting profit, EBITDA, net income, and key ratios.

• The balance sheet captures investments (float), premium receivables, reinsurance recoverables, deferred acquisition costs, loss reserves, UPR, and equity, with a balance check. The cash flow statement uses the indirect method, adjusting net income for non-cash items such as changes in loss reserves and UPR.
• Capital adequacy calculates required risk-based capital and premium-to-surplus ratio, which must stay below 3.0x. The KPI sheet tracks loss ratio, expense ratio, combined ratio, ROE, customer acquisition cost, retention, and investment yield.

Cross-sheet dependencies flow from premium build and claims reserves into the statements, with a deliberate one-period lag to avoid circularity between investment income and cash flow.

This template is designed for evaluating investment, acquisition, or growth capital decisions for a full-stack digital P&C carrier. It helps you test how changes in premium growth, loss ratio improvement, and expense discipline interact to produce a path to profitability.

• The validation checks highlight common modeling mistakes: confusing GWP with earned revenue, skipping the UPR roll-forward, treating paid claims as incurred losses, or modeling positive working capital in a business that collects premiums upfront. It also enforces that cash never turns negative without a facility, that loss reserves cover IBNR, and that the balance sheet balances every period.
• The public download is a values-only preview, so you can review the structure and logic, but live formulas and automatic recalculation are not included. The design assumes a full-stack carrier and does not cover MGA or brokerage structures.