Claim cashflow and caps
- Inflated = Amount × (1 + i)^(months/12)
- AfterDed = max(0, Inflated − Deductible)
- InsurerPart = AfterDed × (1 − coinsurance)
- OccCap = min(InsurerPart, PerOccLimit)
- AggCap = min(OccCap, RemainingAggregate) (applied sequentially)
- Insured cost includes deductible, insured coinsurance, and any uncovered amount.
Present value and premium lift
- PV(x) = x / (1 + d)^(t), where t = months/12.
- LossRatio = TotalInsurerPayout / AnnualPremium
- Year‑1 surcharge is modeled by selected curve (tiered, linear, exponential) and capped.
- Multi‑year premium effect decays: Surcharge_y = Surcharge_(y−1) × decay.
- Total economic impact (PV) = insured PV + premium lift PV.
- Enter premium, limits, deductible, and coinsurance.
- Select the number of claims you want to model.
- Fill each claim amount and its months from now.
- Set inflation and discount rates for time effects.
- Pick a surcharge model and retention period assumptions.
- Press Calculate impact to view results above.
- Use the download buttons for CSV or PDF reports.
Sample schedule for comparison testing:
| Claim | Amount | Months from now | Scenario note |
|---|---|---|---|
| 1 | 12,000 | 0 | Immediate payment tests deductible impact. |
| 2 | 8,000 | 4 | Short delay shows inflation and discounting. |
| 3 | 16,000 | 11 | Later claim stresses annual aggregate limit. |
Claim stacking and limit erosion
Multiple claims can consume aggregate capacity faster than expected. Sequential aggregate application means early insurer payments reduce later availability. When the cap binds, the uncovered portion shifts to the insured and changes the effective cost curve. Use the plot to identify where payouts flatten and insured cost accelerates.
Timing, inflation, and present value
Months from now drives two opposing effects. Inflation grows the nominal claim, while discounting reduces its present value. For example, at 3% inflation and 6% discount, a 12‑month claim typically has a higher nominal amount but a lower PV than today. This helps compare cash timing on a consistent basis.
Out-of-pocket mechanics you can audit
The calculator breaks each claim into deductible, coinsurance, and uncovered excess. Deductible applies first, coinsurance splits the remainder, and per‑occurrence limits can leave a residual. Aggregate limits apply across the schedule, so later claims may be mostly insured responsibility. Optional handling and fixed fees extend the model for internal expense allocation.
Premium lift assumptions and retention
Loss ratio equals insurer payout divided by annual premium. Higher ratios can pressure renewals, modeled here as tiered, linear, or exponential surcharge curves. Retention years and decay convert a single-year surcharge into a discounted multi‑year premium lift. A 3‑year horizon with 70% decay provides a conservative tail without assuming permanent penalties.
Budgeting with scenario sensitivity
Run base, adverse, and severe schedules. Adjust deductible, limits, coinsurance, and claim timing to see which lever reduces total economic PV. Track insured PV, remaining aggregate, modeled surcharge, and premium lift PV. Export the CSV or PDF for review, documentation, and alignment across stakeholders consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent consistent.
Q: How does the aggregate limit work across claims?
A: The model applies the aggregate limit sequentially. Each claim reduces remaining aggregate by the insurer payout after deductible, coinsurance, and per-occurrence cap. Later claims may receive reduced insurer payments if the aggregate is exhausted.
Q: Why does a future claim show a different value than today?
A: Future claims are inflated to estimate nominal cost, then discounted to present value for comparability. Higher inflation increases nominal amounts, while higher discount rates reduce present values for later cashflows.
Q: What creates insured cost in this calculator?
A: Insured cost includes the deductible, the insured coinsurance share, any uncovered excess when limits bind, plus optional handling fees and fixed per-claim charges if you enter them.
Q: What is the modeled premium surcharge based on?
A: Surcharge is derived from loss ratio, defined as insurer payout divided by annual premium. You can choose a tiered, linear, or exponential curve and apply a cap to prevent extreme outputs.
Q: Can I use this for different policy structures?
A: Yes, as a planning tool. Enter your deductible, coinsurance, per-occurrence limit, and aggregate limit. If your policy has special sublimits or aggregates, treat them as adjusted limits to approximate behavior.
Q: How should I interpret the total economic impact (PV)?
A: It combines present value of insured out-of-pocket costs and discounted premium lift over the retention period. Use it to compare scenarios, not as an insurer quote or a guarantee of renewal pricing.