Average Balance Target Calculator
Know your yearly or monthly average and its growth over the base? Find the amount you must hold each day to hit a target average growth by a date.
Runs in your browser — nothing is uploadedEnter values
Average type
Where you are now
Your target
Average counted from Jan 1, 2026 (year-to-date).
Result
- December / base amount
- 4,464.29
- Target average (+15%)
- 5,133.93
- Days already averaged
- 281
- Days remaining
- 23
- Total days in period
- 304
How it's calculated
Base = 5,000.00 ÷ (1 + 12%) = 4,464.29
Target average = 4,464.29 × (1 + 15%) = 5,133.93
Required = (Target average × total days − Current average × days so far) ÷ days remaining
= (5,133.93 × 304 − 5,000.00 × 281) ÷ 23 = 6,770.19
Check: (5,000.00 × 281 + 6,770.19 × 23) ÷ 304 = 5,133.93
Assumes the same amount is held on every remaining day (a day-weighted average, as used for average-deposit targets).
About Average Balance Target Calculator
Banks and branch managers are often measured on average balances — the average of the daily closing balance over the year or month — rather than the balance on one day. When there is a growth target over a base such as December’s average, it is hard to know how much money must be held each remaining day to reach it.
This calculator works it out. Enter your current average, its growth over the base, the date it runs to, and the target growth and date. It calculates the balance that must be held every remaining day to reach the target average.
When to use it
- Bank branch and relationship managers tracking deposit targets.
- Planning month-end and year-end deposit mobilisation.
- Checking whether a target is still achievable before a deadline.
- Businesses that must maintain a minimum average balance.
Tips for better results
- Run it again every few days with updated averages to stay on track.
- Earlier action is easier — the required daily amount rises as the deadline approaches.
- Use the monthly average option for monthly targets that reset on the 1st.
How to use the Average Balance Target Calculator
- Choose a yearly (from 1 January) or monthly (from the 1st) average.
- Enter your current average amount, its growth vs the base (e.g. December) and the date it runs to.
- Enter the average growth you want and the date to reach it.
- Hold the required amount every day until the target date.
Frequently asked questions
How is the required amount calculated?
The base is current average ÷ (1 + current growth). The target average is base × (1 + target growth). Because the average is day-weighted, the amount needed on each remaining day = (target average × total days − current average × days so far) ÷ days remaining.
Which days are counted?
Days are counted from the period start (1 January by default) up to and including the current-average date. The remaining days run from the next day up to and including the target date. Untick "includes this day" if today's figure isn't in your average yet.
What is the difference between the yearly and monthly average?
The yearly (year-to-date) average counts every day from 1 January; the monthly (month-to-date) average restarts on the 1st of each month. With fewer days already averaged, a monthly target reacts faster — so the same target usually needs a smaller daily amount. The target date must be in the same year (yearly) or month (monthly).
What if the result is lower than my current average?
Then you are already on track: holding at least the required amount each day still reaches the target average.
Why is the required amount so high near the deadline?
With fewer days left, each day carries more weight in closing the gap, so the balance needed per day rises sharply. Starting earlier spreads the effort over more days.
Can I use it for personal savings goals?
Yes, if your bank or account measures an average balance — for example accounts that require a minimum monthly average to avoid fees.