Sweep-account interest allocation · Calculation guide

Calculate interest kept in the base account and earned on cash swept above a threshold.

Calculation guide

One fixed balance, no minimum sweep lot or delay; actual days/365 simple interest. Funds up to the threshold remain in the base account.

total = (min(balance,limit)*base+max(0,balance-limit)*sweep)/100*days/365; moved = max(0,balance-limit); uplift = total-balance*base/100*days/365

Inputs

Total cash balance

Example entry 25000 (in the selected currency).

Base account retention threshold

Example entry 5000 (in the selected currency).

Base annual rate

Example entry 1 %. Allowed range 0 to 100.

Sweep annual rate

Example entry 4 %. Allowed range 0 to 100.

Days held

Example entry 365. Allowed range 0 to 1000000. Use whole numbers.

Worked example

InputValue
Total cash balance25,000
Base account retention threshold5,000
Base annual rate1%
Sweep annual rate4%
Days held365
ResultValue
Total interest850
Swept balance20,000
Gain · Interest versus base account600

Calculation steps

Total interest = (((((min(Total cash balance, Base account retention threshold) × Base annual rate) + (max(0, (Total cash balance − Base account retention threshold)) × Sweep annual rate)) ÷ 100) × Days held) ÷ 365)

(((((min(25,000, 5,000) × 1) + (max(0, (25,000 − 5,000)) × 4)) ÷ 100) × 365) ÷ 365) = 850

Swept balance = max(0, (Total cash balance − Base account retention threshold))

max(0, (25,000 − 5,000)) = 20,000

Interest gain versus base account alone = (Total interest − ((((Total cash balance × Base annual rate) ÷ 100) × Days held) ÷ 365))

(850 − ((((25,000 × 1) ÷ 100) × 365) ÷ 365)) = 600

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Total cash balance25,00027,500Total interest850950
Base account retention threshold5,0005,500Total interest850835
Base annual rate1%2%Total interest850900
Sweep annual rate4%5%Total interest8501,050
Days held365402Total interest850936.164384
Sweep-account interest allocation →