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.
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
| Input | Value |
|---|---|
| Total cash balance | 25,000 |
| Base account retention threshold | 5,000 |
| Base annual rate | 1% |
| Sweep annual rate | 4% |
| Days held | 365 |
| Result | Value |
|---|---|
| Total interest | 850 |
| Swept balance | 20,000 |
| Gain · Interest versus base account | 600 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Total cash balance | 25,000 | 27,500 | Total interest | 850 | 950 |
| Base account retention threshold | 5,000 | 5,500 | Total interest | 850 | 835 |
| Base annual rate | 1% | 2% | Total interest | 850 | 900 |
| Sweep annual rate | 4% | 5% | Total interest | 850 | 1,050 |
| Days held | 365 | 402 | Total interest | 850 | 936.164384 |
