I did some calculation for 500K loan.
The better options are either pay early (not too early) or pay extremely late:
25 years loan tenure with 3% yield investment on the extra cashflow (due to lower mortgage payment). Final value = 1.12 Million (each individual about 556K)
10 years loan tenure. Once mortgage is completed, invest free-up cashflow into 3% yield investment for 15 years. Final value = 1.08M (each individual about 504K)
Note: The higher the investment yield, the greater the difference between 25 and 10 years (can be as great as 100K).
| A | B | C | D | E | F | G | H | I | J | H |
| Loan Tenure (Years) | Principal | Total Interest paid
(assume 2.6%) | Monthly Mortgage payment | Yearly Mortgage payment | Extra Yearly Cash (against 10 years tenure) | Future Cash Value after tenure (3% Yield) | Delta | Remaining years to 25 years mark | 3% yield Investment of [E + F]
(after mortgage is paid; till 25 years mark) | Final Value |
| 25 | 500,000.00 | 180,504.26 | 2,268.35 | 27,220.20 | 29,615.04 | 1,112,134.85 | 931,630.59 | - | - | 1,112,134.85 |
| 20 | 500,000.00 | 141,745.66 | 2,673.94 | 32,087.28 | 24,747.96 | 684,936.56 | 543,190.90 | 5.00 | 310,798.39 | 995,734.95 |
| 15 | 500,000.00 | 104,356.16 | 3,357.53 | 40,290.36 | 16,544.88 | 316,948.30 | 212,592.14 | 10.00 | 671,098.90 | 988,047.20 |
| 10 | 500,000.00 | 68,351.93 | 4,736.27 | 56,835.24 | - | | - | 15.00 | 1,088,785.95 | 1,088,785.95 |