Before signing a mortgage loan contract we all must simulate the amounts that we need to repay every month based on the contract conditions. Nobody should accept to sign a loan contract before doing the financial analysis job to understand the full consequences of the contract he is about to enter into.
I had to take a few such decisions and I wanted to have a tool that help me understand better the risks and the strategies I have to pursue in order to minimize the cost of the loan.
Loan Simulator Mortgage Calculator
The excel file I offer anyone is interested in such impact analysis is very complex and can simulate the modification of reference interest rate every month and also the potential benefits of advance payments.
You can find here the excel file for download: