Minimum average daily balance to waive fees · Calculation guide

Find the average balance needed over the remaining days to meet a waiver threshold.

Calculation guide

Uses calendar-day closing balances; the bank must waive fees based on average balance, not minimum daily balance. Enter the average to date, not the latest balance.

required = max(0,(target*period-average*elapsed)/(period-elapsed)); remaining = period-elapsed

Inputs

Required average balance

Example entry 1000 (in the selected currency).

Days in statement period

Example entry 30. Allowed range 1 to 366. Use whole numbers.

Days already completed

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

Average balance so far

Example entry 700 (in the selected currency).

Worked example

InputValue
Required average balance1,000
Days in statement period30
Days already completed10
Average balance so far700
ResultValue
Required average for remaining days1,150
Remaining days20 days

Calculation steps

Required average for remaining days = max(0, (((Required average balance × Days in statement period) − (Average balance so far × Days already completed)) ÷ (Days in statement period − Days already completed)))

max(0, (((1,000 × 30) − (700 × 10)) ÷ (30 − 10))) = 1,150

Remaining days = (Days in statement period − Days already completed)

(30 − 10) = 20 days

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Required average balance1,0001,100Required average for remaining days1,1501,300
Days in statement period3033Required average for remaining days1,1501,130.434783
Days already completed1011Required average for remaining days1,1501,173.684211
Average balance so far700770Required average for remaining days1,1501,115
Minimum average daily balance to waive fees →