We create a calculator which shows how changes in interest rates may affect your monthly mortgage payments. In 2022, central banks have consistently been increasing interest rates in order to tackle inflation. Therefore, this calculator becomes ever more important, especially if you are on a variable rate. Based on your current mortgage balance, the remaining term of your mortgage, the current interest rate you’re on and the interest rate change you are expecting, the calculator will retrieve an indication of your current monthly mortgage payment and your new monthly payment as well as the difference between the two.
DISCLAIMER: This calculator is for illustrative purposes only. Although I have taken great care to check all of the calculations, I am not a qualified accountant or advisor, and you should not use this video to substitute financial advice. Make sure you talk to your own accountant or financial advisor before you use this calculator to make any financial decisions.
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
See Fixed Mortgage Repayment Calculator Video:
https://youtu.be/v6n4wWXy5Us
See Variable Mortgage Repayment Calculator Video:
https://youtu.be/zgRw71SgYbo
Please share this video with others that may find it useful:
https://youtu.be/3nPsaKWlybI
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]Overview: (0:00)
Current & New Mortgage Payment: (1:13)
Payment Change: (3:30)