Calculation guide
Assumes the minimum balance remains for all qualifying days and the bonus is earned. Interest in both accounts is simple, actual/365. Include only unavoidable incremental fees. Excludes taxes.
Inputs
Qualifying bonus
Example entry 200 (in the selected currency).
Required minimum balance
Example entry 10000 (in the selected currency).
Holding period in days
Example entry 90. Allowed range 1.0 to 36500.0. Use whole numbers.
Offer account annual rate
Example entry 1 %. Allowed range 0.0 to 100.0.
Alternative account annual rate
Example entry 3 %. Allowed range 0.0 to 100.0.
Extra fees over period
Example entry 10 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Qualifying bonus | 200 |
| Required minimum balance | 10,000 |
| Holding period in days | 90 |
| Offer account annual rate | 1% |
| Alternative account annual rate | 3% |
| Extra fees over period | 10 |
| Result | Value |
|---|---|
| Net incremental benefit | 140.684932 |
| Interest forgone versus alternative | 49.315068 |
| Bonus required to match alternative | 59.315068 |
Calculation steps
Net incremental benefit = ((Qualifying bonus − Extra fees over period) − ((((Required minimum balance × (Alternative account annual rate − Offer account annual rate)) ÷ 100) × Holding period in days) ÷ 365))
((200 − 10) − ((((10,000 × (3 − 1)) ÷ 100) × 90) ÷ 365)) = 140.684932
Interest forgone versus alternative = ((((Required minimum balance × (Alternative account annual rate − Offer account annual rate)) ÷ 100) × Holding period in days) ÷ 365)
((((10,000 × (3 − 1)) ÷ 100) × 90) ÷ 365) = 49.315068
Bonus required to match alternative = max(0, (Extra fees over period + Interest forgone versus alternative))
max(0, (10 + 49.315068)) = 59.315068
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 |
|---|---|---|---|---|---|
| Qualifying bonus | 200 | 220 | Net incremental benefit | 140.684932 | 160.684932 |
| Required minimum balance | 10,000 | 11,000 | Net incremental benefit | 140.684932 | 135.753425 |
| Holding period in days | 90 | 99 | Net incremental benefit | 140.684932 | 135.753425 |
| Offer account annual rate | 1% | 2% | Net incremental benefit | 140.684932 | 165.342466 |
| Alternative account annual rate | 3% | 4% | Net incremental benefit | 140.684932 | 116.027397 |
| Extra fees over period | 10 | 11 | Net incremental benefit | 140.684932 | 139.684932 |
