Calculator Inputs
How to use
- Enter claim counts, paid, reserves, and recoveries.
- Set deductible, limit, coinsurance, and development factor.
- Add inflation, trend, and expense assumptions as needed.
- Use reinsurance fields if ceded protection applies.
- Adjust risk sliders and calculate for updated outputs.
- Export CSV or PDF to document your scenario.
Formula used
Net incurred = max(0, Paid + Reserves − Recoveries).
Ultimate incurred = Net incurred × LDF.
Gross per claim = Ultimate incurred / Claim count.
Net per claim = max(0, Gross − Deductible), capped by Limit.
After coinsurance = Net per claim × (Coinsurance%/100).
Before reinsurance = After coinsurance + Per-claim expense.
Ceded = min(max(0, BeforeRe − Attach), ReLimit) × Ceded%.
Retained = BeforeRe − Ceded.
Risk multiplier = 1 + ((AvgRisk − 3) × Step%), using the mean of all sliders.
Adjusted per claim = Retained × Inflation × Trend × Expense × Risk + Fixed/claim.
Present value = Adjusted × 1/(1+Discount)^Years (when provided).
Pure premium = Adjusted total / Exposure units (optional).
Example data table
Sample scenarios to validate inputs and outputs.
| Scenario | Claims | Paid | Reserves | Recoveries | LDF | Deductible | Inflation | Expense | PV rate | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| Retail slip-and-fall | 12 | 36,000 | 18,000 | 2,000 | 1.05 | 500 | 4% | 6% | 3% | Moderate stress with small recoveries |
| Auto property damage | 45 | 90,000 | 25,000 | 0 | 1.02 | 250 | 3% | 5% | 0% | Short-tailed with simple assumptions |
| Workers’ comp claim set | 9 | 120,000 | 90,000 | 5,000 | 1.20 | 1,000 | 6% | 9% | 4% | Longer tail, higher development and PV |