• Navigation
  • open search





Home Mortgage Calculator

Download Editors' Rating:
Editors' Rating:
Average User Rating:
out of 4 votes out of 4 votes

Quick Specs

  • Version:
  • Total Downloads:
  • Date Added:
    Nov. 16, 2010
  • Price:
  • File Size:
  • Downloads Last Week:
  • Platform:
  • Product ranking:
    #8 in Calculators

Editors' Review


Home Mortgage Calculator from Vertex42 is a free Excel spreadsheet template for calculating fixed and variable rate home mortgages. That sounds useful but not very exciting, which is a fairly good description of Excel spreadsheets in general. However, Home Mortgage Calculator is more than just a page full of tables. It incorporates many automated features and options, but better still, its clear explanations, numerous examples, and graphical displays make it easy not only to calculate mortgage rates but also get a better overview of your mortgage. To use Home Mortgage Calculator, you will need Microsoft Excel 2002 or above.

We extracted Home Mortgage Calculator's zipped download and opened it in Excel. The first thing we noticed was the numerous examples with caption boxes explaining each step in plain language. Each item had a small red triangle that called up additional information and instructions in a tiny pop-up when we hovered the cursor, and in clear, easy-to-understand terms, too. The spreadsheet has five main sections: Mortgage Information, Extra Payments, Balance, Summary, and Fixed-Rate ARM. The Extra Payments tool offered a graph plotting extra payments against balance year by year, while the interest rate tool includes a graph depicting Interest Rate History. Finally, the Payment Schedule tablet offered some 180 lines of calculations, similar to a tax table. The tool is extremely easy to use, yet it returned accurate calculations quickly. We merely had to enter our own values in each field and click Enter. Home Mortgage Calculator displayed everything from our monthly payment to how many years it would take to pay off our loan. Beyond its built-in features, it behaves just like any Excel template.

Since Home Mortgage Calculator is a spreadsheet template instead of a program, it doesn't have a typical Help file. However, it offers an impressive amount of assistance and plenty of explanations built right in. If you have Excel and want a home mortgage, get Home Mortgage Calculator first.

read more +

Publisher's Description

read more +
User Reviews

Results 1–4 of 4

5 stars

"Great spreadsheet!"

June 11, 2013  |  By gpaint324

2013-06-11 11:41:20  |  By gpaint324

 |  Version: Home Mortgage Calculator 2.0


Great template, did all the things I needed it to do.


None that I've found.

Reply to this review

Was this review helpful? (0)   (0)  

4 stars

"Does all the basic things very well."

February 08, 2013  |  By jalerock

2013-02-08 21:51:32  |  By jalerock

 |  Version: Home Mortgage Calculator 2.0


Easy to use, very intuitive.


No glaring weaknesses.

Reply to this review

Was this review helpful? (0)   (0)  

5 stars

"Best Mortgage Excel of its Kind"

November 01, 2012  |  By samantha827

2012-11-01 22:52:24  |  By samantha827

 |  Version: Home Mortgage Calculator 2.0


I could find my monthly repayment and total cost of a mortgage based on a rate and amount of borrowing.


Could not find any.

Reply to this review Read replies (2)

Was this review helpful? (0)   (0)  

5 stars

"Awesome! Great spreadsheet"

May 28, 2011  |  By notyouravedame

2011-05-28 08:11:00  |  By notyouravedame

 |  Version: Home Mortgage Calculator 2.0


The best feature, in my opinion, is that the spreadsheet allows you to see the long-term effect of occasional extra payments. Most online calculators will only allow you to figure recurring additional payments.


nothing so far


Fabulous tool! This is great for those who like to know how extra payments add up.

Reply to this review

Was this review helpful? (0)   (0)  

Results 1–4 of 4

Add Your Review

Login or create an account to post a review.

You are logged in as . Please submit your review for Home Mortgage Calculator
Add Your Review

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

Update Your Review

Since you've already submitted a review for this product, this submission will be added as an update to your original review.

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

see all reviews +

Full Specifications

Publisher Vertex42
Publisher web site
Release Date November 16, 2010
Date Added November 16, 2010
Version 2.0
Category Productivity Software
Subcategory Calculators
Operating Systems
Operating Systems Windows XP/2003/Vista/7
Additional Requirements Microsoft Excel 2002
Download Information
File Size 291.22KB
File Name
Total Downloads 98,613
Downloads Last Week 23
License Model Free
Limitations Not available
Price Free
Add to my list Report a problem
read more +

Submit a problem report for Home Mortgage Calculator

Please describe the problem you have with this software. This information will be sent to our editors for review.


The Installer isn't working as expected

The download link does not work

The software has a newer version

The product contains malicious software



Please select a feedback type.

Please enter a description.

Submit Problem Report


Problem Report submitted

Thank you for submitting a problem report! The Download team is committed to providing you with accurate software information.