How much will my home loan repayments be if the interest rate changes? What if I choose a different loan term? You can use this FREE home loan analysis calculator to find answers to these questions.

This FREE home loan mortgage analysis spreadsheet allows you to see how your loan repayment will vary when interest rates changes between 1% to 30% under different loan terms from 1 to 30 years.

The mortgage analysis calculator contains a loan summary and a comparison table comparing different monthly (or fortnightly, bi-weekly, or weekly) payments based on two variables: the interest rate (from 1% to 30% in 25 base point increments) and the loan term (for 3, 5, 10, 15, 20, 25, or 30 years as default and you can change them).

Here is a screenshot that will give you a better idea that what you need to do and what this Mortgage Home Loan Analysis Calculator can do for you.

Mortgage Home Loan Analysis Calculator

Things You Need to Know

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.

I believe that the Free Home Loan Repayments Calculator and the Free Home Loan Mortgage Amortization Calculator are useful whether you plan to take a home loan or you already have a mortgage. You can do a detailed mortgage amortization calculation of you home loans by using the Free Home Loan Mortgage Amortization Calculator. You can do monthly, fortnightly (bi weekly or two weeks), or weekly mortgage amortization schedule and even more.

You might also want to try the Free Investment Property Calculator if you want to invest on a residential rental investment property.

Download FREE Mortgage Home Loan Analysis Calculator