Average bank balance calculator
Paste balances to get the average, the low and high, and how the proposed EMI compares. Use made-up figures only.
Result
Made-up example loaded. Replace it with your figures.
Enter figures, or load the made-up example, to see results.
Keep this result
Here it is. The file is built on this page from your figures.
Download my result (CSV)Formulas used
ABB = sum of balances / number of balances
EMI to ABB = proposed EMI / ABB
Worked example, made-up numbers
Nine sample balances averaging 2,16,667, and an EMI of 25,000, give an EMI to ABB of 11.5%.
Assumptions
- You choose the sample dates. Conventions vary by institution.
- ABB alone proves little, since a balance can be arranged. Check bounces and credit sources too.
- Do not paste real customer statements.