Calculation guide
Enter two increasing upper limits and three marginal rates; the last band is open-ended. Static balance, one year, simple interest. This is not a whole-balance tier tariff.
Inputs
Balance
Example entry 25000 (in the selected currency).
First upper limit
Example entry 10000 (in the selected currency).
Second upper limit
Example entry 20000 (in the selected currency).
First band rate
Example entry 2 %. Allowed range 0 to 100.
Second band rate
Example entry 3 %. Allowed range 0 to 100.
Rate above second limit
Example entry 4 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Balance | 25,000 |
| First upper limit | 10,000 |
| Second upper limit | 20,000 |
| First band rate | 2% |
| Second band rate | 3% |
| Rate above second limit | 4% |
| Result | Value |
|---|---|
| Annual interest | 700 |
| Balance in highest band | 5,000 |
Calculation steps
Annual interest = ((((min(Balance, First upper limit) × First band rate) + (max(0, (min(Balance, Second upper limit) − First upper limit)) × Second band rate)) + (max(0, (Balance − Second upper limit)) × Rate above second limit)) ÷ 100)
((((min(25,000, 10,000) × 2) + (max(0, (min(25,000, 20,000) − 10,000)) × 3)) + (max(0, (25,000 − 20,000)) × 4)) ÷ 100) = 700
Balance in highest band = max(0, (Balance − Second upper limit))
max(0, (25,000 − 20,000)) = 5,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 |
|---|---|---|---|---|---|
| Balance | 25,000 | 27,500 | Annual interest | 700 | 800 |
| First upper limit | 10,000 | 11,000 | Annual interest | 700 | 690 |
| Second upper limit | 20,000 | 22,000 | Annual interest | 700 | 680 |
| First band rate | 2% | 3% | Annual interest | 700 | 800 |
| Second band rate | 3% | 4% | Annual interest | 700 | 800 |
| Rate above second limit | 4% | 5% | Annual interest | 700 | 750 |
