skip to Main Content

Excel Mortgage Calculator

4.6 (5 reviews)

Excel Home Mortgage Calculator automatically calculates interest amortization, monthly fixed fee and remaining loan balance with charts.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



Buying our house is one of the most critical decisions we give in our lives. It is great to have our own house but this also puts us in a long term commitment of payments. So, before giving our decisions it is a good idea to make our plans to see the future payments for the credit we will take. This Excel Home Mortgage Calculator helps you to calculate your loan payments supported with some charts.

Excel Home Mortgage Calculator Features:

This tool is prepared with macros. So, all you need to do is to put your loan amount, interest rate and the number of years you plan to pay back the credit.

Firstly, on Dashboard fill in the settings options according to your own case. Then click on “Calculate” button and tool will automatically list down the loan payments.


In addition to this Dashboard has some graphs to present a visual situation of your payments. These are;

  • Trend of Debts and Paid Up Capital
  • Monthly Payment rate shows your Interest Paid, Capital Paid and Remaining Balance
  • Payment Percentage

Mortgage-Calculator-Template-Someka-S01-1Mortgage Calculator will automatically calculate the interest amortization, monthly fixed fee and remaining balance. Don’t forget to check at least a few combinations until you find the most suitable option according to your own situation.

Features Summary:

  • Home Mortgage Amortization Calculator in Excel
  • Future payments of your loan
  • Automatically calculates the interest amortization, monthly fixed fee, and remaining balance
  • Clear on sheet instructions
  • Nice dashboard design with charts
  • Compatible with Excel 2007 and later versions.
  • Print-Ready
  • Includes VBA macros. (don’t forget to enable macros when you open the tool)

If you liked this template, don’t forget to check our other Excel Calculators

This Excel Home Mortgage Calculator is ready-to-use and provided as is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



5 reviews for Excel Mortgage Calculator

  1. Ahmed

    The template is user friendly and the ability to customize to our needs is totally requires a few steps. If you use Excel for all types of works, this would be exactly that you are looking for tracking your mortgage payments.

  2. carrie_c1

    Easy to enter data. Automatically updates when just click the calculate button. This solves the biggest problem of amortization schedule, it provide the amortization schedule accordingly to the variables provide.

  3. Julian G

    You don’t need any financial advisor to do a calculation. Simple and easy to use template.

  4. stephan.m

    functionality is good but don’t love the design. It’s old

  5. kash

    This form is very easy to use than any other online software calculator i have. It quickly shows the impact on adding extra payments can add equity and reduce interest.. It has saved me time and hassle!

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.