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.
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
| Input | Value |
|---|---|
| Required average balance | 1,000 |
| Days in statement period | 30 |
| Days already completed | 10 |
| Average balance so far | 700 |
| Result | Value |
|---|---|
| Required average for remaining days | 1,150 |
| Remaining days | 20 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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Required average balance | 1,000 | 1,100 | Required average for remaining days | 1,150 | 1,300 |
| Days in statement period | 30 | 33 | Required average for remaining days | 1,150 | 1,130.434783 |
| Days already completed | 10 | 11 | Required average for remaining days | 1,150 | 1,173.684211 |
| Average balance so far | 700 | 770 | Required average for remaining days | 1,150 | 1,115 |
