Overview
How much will my home loan repayments be? And how long does it take to repay my mortgage? If you have asked yourself these questions, you can use this FREE home loan amortization calculator to create an mortgage amortization schedule and home loan payment schedule.
Before you take a home loan (a mortgage), it will be helpful if you do a Loan Amortization and Loan Analysis using this FREE home loan amortization calculator. The calculator can provide you with all the numbers you need to compare rates and terms, review principle and interest payments, and do a "what-if" analysis. The calculator is based on the PMT function, one of Excel's Financial functions, which calculates a loan payment with a fixed interest rate and constant payments.
You can do amortisation based on weekly payment, fortnightly payment (biweekly or bi-weekly) , semi-monthly payment, monthly payment, bi-monthly payment, quarterly payment, semi-annually payment, or annually payment by varying your loan terms from 1 to 30 years.
Here is a screenshot that will give you a better idea that what you need to do and what this How to Structure Home Loan Calculator can do for you.
Things You Need to Know
You can even use this calculator for your car loan, personal loan, bad credit loan, unsecured loan, student loan, payday loan, and cash loan or any loan you might want to have an amortization schedule.
This calculator is built in Microsoft Excel worksheet. You need to have Microsoft Excel® 2013 & Above for Microsoft Windows® OR Microsoft Excel 2016 & Above for Mac® to use it.
All the calculators (paid and free ones) on this website are password protected. We don't provide unprotected versions of the PAID calculators due to copyright reasons. If you purchase the paid calculators because you want to get the unprotected version please don't make the purchase as we are not going to provide unprotected copies. By purchasing the paid calculators you agree that no unprotected copies of the PAID calculators will be provided to you. If you don't agree please do not purchase. If you need the unprotected version of any FREE calculator a fee will apply. The advantage of the unprotected version is that you can freely edit the tool without any limit although we still own the copyright of the unprotected calculator. Please note you cannot redistribute our calculators without a written approval from us even for the ones with your modification or customization. In addition we are not going to provide any support on unprotected calculators with any modification or customization.
Important Assumptions
Please note: This free Mortgage Home Loan Amortization Calculator is built based on the following assumptions.
(1) All months are assumed to be of equal length. One year is assumed to contain exactly 52 weeks or 26 fortnights. This implicitly assumes that a year has 364 days rather than the actual 365 or 366.
Download FREE Mortgage Home Loan Amortization Calculator