The average outstanding balance of a fixed-rate loan in the Average Rates analysis is calculated over the period covering the visualization date:
Sum of (Outstanding balance * Count of days between the start of the period and the end of the period of the payment) / Total day count
Example
A fixed-rate loan over a period from 01/01/2020 to 01/07/2020.
|
Date |
Outstanding Balance at Start of Period |
Day Count |
Outstanding Balance * Day Count |
|---|---|---|---|
|
28/01/2020 |
1 082 409,14 € |
27 (01/01 -> 27/01) |
29 225 046,78 € (1 082 409,14 * 27) |
|
28/02/2020 |
1 076 722,73 € |
31 |
33 378 404,63 € |
|
28/03/2020 |
1 071 027,98 € |
29 |
31 059 811,42 € |
|
28/04/2020 |
1 065 324,87 € |
31 |
33 025 070,97 € |
|
28/05/2020 |
1 059 613,40 € |
30 |
31 788 402,00 € |
|
28/06/2020 |
1 053 893,55 € |
31 |
32 670 700,05 € |
|
28/07/2020 |
1 048 165,31 € |
3 |
3 144 495,93 € |
|
Total |
182 |
194 291 931,78 € |
|
Average outstanding balance
= Sum of (outstanding balance * count of days between the start of the period and the end of the period of the payment) / total day count
= 194 291 931,78 / 182
= 1 067 538,09 €