How to Calculate Average Outstanding Balance

Identify your time frame. Sometimes the outstanding balance is calculated on a daily basis. Other times it is calculated on a monthly, quarterly or annual balance. For this example, assume the time frame is one month, from January to February.

Gather your information. You will need to obtain the average loan amount outstanding in the loan portfolio for the beginning of the time period and the end of the time period as well as the number of accounts held in the loan portfolio. Specifically, you will need the ending balance of your account for two different periods. For instance, assume the ending balance for January is $100,000 and the ending balance for February is $110,000.

Find the average of the ending balance from January and the ending outstanding balance for February. The calculation is the end of the first month plus the end of the most recent month divided by two. The calculation for this example is $100,000 plus $110,000 divided by two, or $105,000.

Divide the answer by the average number of account within the loan portfolio. Assume the number of accounts at both the end and beginning of the period is 10. $105,000 divided by 10 is $10,500.