Tiered deposit rate across balance bands · Calculation guide

Apply a separate annual rate to the portion in each balance band.

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.

interest = (min(bal,one)*r1+max(0,min(bal,two)-one)*r2+max(0,bal-two)*r3)/100; last = max(0,bal-two)

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

InputValue
Balance25,000
First upper limit10,000
Second upper limit20,000
First band rate2%
Second band rate3%
Rate above second limit4%
ResultValue
Annual interest700
Balance in highest band5,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Balance25,00027,500Annual interest700800
First upper limit10,00011,000Annual interest700690
Second upper limit20,00022,000Annual interest700680
First band rate2%3%Annual interest700800
Second band rate3%4%Annual interest700800
Rate above second limit4%5%Annual interest700750
Tiered deposit rate across balance bands →