PeterA007 wrote: ↑Tue Sep 24, 2024 2:48 pmWe have been making extra payments each month on a mortgage. Our bank has been applying it to interest and zero to reducing principal. ... [Our bank says] it is all applied to interest and our next regular monthly payment isnt due until Oct 2025.
An extra payment can't be applied against interest. [*] It is either applied against the loan balance or it is not applied at all. It sounds like your bank is doing the latter. Instead of applying your extra payments against the loan balance when received, it is holding them and applying them the following month. If you repeatedly make extra payments, the end result is application of your extra payments is delayed further and further into the future. This is illustrated in the table below. It assumes
- A $139,581 loan balance September 2023.
- 6% interest and a $1,000 monthly payment needed to pay off the loan in 20 years. (Payment calculated with Excel PMT function.)
- Beginning October 2023 you made the regular $1,000 payment plus an extra $1,000 payment every month for 12 months to September 2024.
- Beginning October 2024 you make no payments at all for 12 months.
- Columns B & C assume the bank applies the total $2,000 payment every month as it's received.
- Columns D & E assume the bank applies only the regular $1,000 payment each month and delays the $1,000 extra until the following month. By September 2024, 12 extra payments have been delayed. The bank applies these each month October 2024 through September 2025.
Under these assumptions the loan balance September 2025 would be $131,137 if the bank applies each $2,000 payment as it's received. But it would be $131,898 or $761 more if the bank only applies $1,000 each month. This can be seen both in cells B9:B11 (using the Excel
FV function) and in row 37 at the bottom of the table.
Code: Select all
Row Col A Col B Col C Col D Col E Col F Formula in Column B (B13:B37 copied to D13:D37)
2 Rate 6.0%
3 Months 240
4 Balance 139,581
5 Regular payment 1,000.00 =PMT(B2/12,B3,-B4,0,0)
6 Extra payment 1,000.00 =B5
7 For nbr months 12
8 Resume reg pmts FALSE
9 Bal w extra pmt 131,137 =FV(B2/12,ROUND((B6/B5)*B7,0),IF(B8,B5,0),-FV(B2/12,B7,B5+B6,-B4,0),0)
10 Bal wo extra pmt 131,898 =FV(B2/12,ROUND((1+B6/B5)*B7,0),B5,-B4,0)
11 Difference 761 =B10-B9
Extra Applied -- Delayed --
12 Month Balance Pmt Balance Pmt Diff
Code: Select all
13 Sep-2023 139,581 139,581 =$B4
14 Oct-2023 138,279 2,000 139,279 1,000 1,000 =B13*(1+$B$2/12)-C14
15 Nov-2023 136,970 2,000 138,975 1,000 2,005 | | |
16 Dec-2023 135,655 2,000 138,670 1,000 3,015 | | |
17 Jan-2024 134,333 2,000 138,364 1,000 4,030 | | |
18 Feb-2024 133,005 2,000 138,055 1,000 5,050 | | |
19 Mar-2024 131,670 2,000 137,746 1,000 6,076 | | |
20 Apr-2024 130,328 2,000 137,434 1,000 7,106 | | |
21 May-2024 128,980 2,000 137,122 1,000 8,141 | | |
22 Jun-2024 127,625 2,000 136,807 1,000 9,182 | | |
23 Jul-2024 126,263 2,000 136,491 1,000 10,228 | | |
24 Aug-2024 124,894 2,000 136,174 1,000 11,279 | | |
25 Sep-2024 123,519 2,000 135,854 1,000 12,336 | | |
26 Oct-2024 124,136 0 135,534 1,000 11,397 | | |
27 Nov-2024 124,757 0 135,211 1,000 10,454 | | |
28 Dec-2024 125,381 0 134,887 1,000 9,507 | | |
29 Jan-2025 126,008 0 134,562 1,000 8,554 | | |
30 Feb-2025 126,638 0 134,235 1,000 7,597 | | |
31 Mar-2025 127,271 0 133,906 1,000 6,635 | | |
32 Apr-2025 127,907 0 133,575 1,000 5,668 | | |
33 May-2025 128,547 0 133,243 1,000 4,696 | | |
34 Jun-2025 129,190 0 132,909 1,000 3,720 | | |
35 Jul-2025 129,836 0 132,574 1,000 2,738 | | |
36 Aug-2025 130,485 0 132,237 1,000 1,752 v v v
37 Sep-2025 131,137 0 131,898 1,000 761 =B36*(1+$B$2/12)-C37
* For example, in October 2023 in the illustration table, a
regular $1,000 payment covers the $698 interest (139581 * 6% / 12) leaving $302 to be applied against the loan balance, reducing it to $139,279 (139581 - 302). There is no interest left for the extra payment to be applied against. If it is applied at all, it reduces the loan balance.