Calculator Inputs
3 columns (large) • 2 columns (small) • 1 column (mobile)Example Data Table
| Scenario | Type | Claim | Allowed | Limit Remaining | Coinsurance | Network | Other Insurance |
|---|---|---|---|---|---|---|---|
| In-network routine | General | 2,500 | 2,100 | 10,000 | 20% | 1.00 | 0 |
| Out-of-network consult | Diagnostics | 1,800 | (blank) | 5,000 | 30% | 0.70 | 250 |
| Sublimit restricted | Dental | 4,000 | 3,200 | 20,000 | 10% | 1.00 | 0 |
Formula Used
- Pricing basis = Allowed Amount, else Claim × (1 - Provider Discount %).
- Covered basis = max(0, Pricing basis - Excluded - (Non-covered %)).
- Eligible = min(Covered basis, Policy Limit Remaining, Sublimit, Per-claim max).
- OOP before cap = Deductible + Coinsurance + Copay total.
- Insurer gross = Eligible - min(OOP before cap, OOP max remaining).
- Rate cap limits insurer gross to Eligible × Reimbursement rate %.
- Net pay = (After rate cap × Network factor) - Penalties - Other insurance offset.
- Net benefit = Net pay + (Net pay × Tax relief %), then budget adjusted.
How to Use
- Enter claim amount, claim type, and policy limit remaining.
- Add allowed amount or set a provider discount estimate.
- Include exclusions or non-covered portion if your plan applies them.
- Set deductible, coinsurance, copays, and out-of-pocket max remaining.
- Use reimbursement rate cap and network factor for real-world matching.
- Add penalties and other insurance payments when applicable.
- Click Calculate to see results and both charts above.
- Download CSV or PDF from the result section when visible.
Claim Pricing Basis and Eligibility
This calculator starts with a pricing basis that can be your billed claim amount or an insurer allowed amount. If allowed pricing is unknown, an estimated provider discount percentage can be applied to approximate contracted rates. After that, excluded amounts and a non-covered portion reduce the covered basis before policy caps are applied. The final eligible amount is capped by remaining policy limit, claim-type sublimit, and optional per-claim maximum. This sequence helps you see where the first and largest reductions usually occur.
Deductible, Coinsurance, and Copay Mechanics
Cost sharing is modeled in three layers: deductible applied first, then coinsurance on the post-deductible amount, and finally copays per service. A deductible waiver option supports preventive benefits or special riders. Copay totals scale with the number of services, which is useful for multi-visit therapies and recurring diagnostics. The calculator compares total cost sharing against your remaining out-of-pocket maximum, and only applies up to the remaining cap. This prevents overstating patient responsibility when the plan cap is close.
Reimbursement Rate, Network Impact, and Penalties
Some plans limit reimbursement to a percentage of eligible costs, even after cost sharing; the reimbursement rate cap option reflects that rule. Network factor further reduces the insurer’s payable amount when care is out of network or billed at reduced coverage. Late filing and missing pre-authorization penalties are applied as percentage reductions to the insurer payment after network adjustment. This ordering matches common adjudication workflows and produces more realistic maximum reimbursement estimates.
Coordination of Benefits and Offsets
When another insurer pays first, the coordination-of-benefits input subtracts that amount from the post-penalty insurer payment in this model. This keeps total reimbursement from exceeding the eligible amount and helps you compare primary versus secondary coverage scenarios. Use this field for employer coordination, spouse coverage, or accident policies that reimburse a defined portion. If you do not expect another payment source, keep it at zero for a clean single-insurer estimate.
Financial Summary Outputs and Planning Use
Results include eligible amount, net insurer reimbursement, and estimated out-of-pocket, plus optional tax savings and a budget adjustment percentage. These outputs support scenario analysis: change claim type to test preset sublimits, vary network factor to evaluate provider choices, and adjust penalties to understand administrative risk. Export the summary to CSV for recordkeeping and download a PDF snapshot for sharing with finance teams or personal budgeting.