Calculation guide
Model an embedded deductible. Each row represents one distinct member’s total eligible charges for the period. Enter each person’s remaining deductible before those charges. Do not include copays, coinsurance or noncovered services.
Deductible applied = min(remaining family deductible, sum of capped individual charges).
Inputs
Family deductible remaining before claims
Example entry 3000 (in the selected currency).
Individual deductible remaining
Example entry 1500 (in the selected currency).
Eligible charges
Example entry 2000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Family deductible remaining before claims | 3,000 |
Distinct family members
| Individual deductible remaining | Eligible charges |
|---|---|
| 1,500 | 2,500 |
| 1,500 | 1,000 |
| Result | Value |
|---|---|
| New deductible applied to family | 2,500 |
| Remaining family deductible | 500 |
| Eligible charges above deductible | 1,000 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Family deductible remaining before claims | 3,000 | 3,300 | Remaining family deductible | 500 | 800 |
| Individual deductible remaining (row 1) | 1,500 | 1,650 | New deductible applied to family | 2,500 | 2,650 |
| Eligible charges (row 1) | 2,500 | 2,750 | Eligible charges above deductible | 1,000 | 1,250 |
