Home Mortgage Calculator

Our free Home Mortgage Calculator for Microsoft® Excel® is a powerful all-in-one worksheet that combines many of the features from our other mortgage and loan calculators. This calculator actually has more features related to making extra payments than our original Extra Payment Mortgage Calculator. If you just want to analyze a variable-rate mortgage, you may want to try our ARM Loan Calculator. If you want to analyze a fixed-rate mortgage, you can also use our Home Equity Loan Calculator, which allows you to estimate the equity in your home over time if you have more than one mortgage. If want to estimate the monthly expenses of owning a home, try our Home Expense Calculator

We Want Your Feedback: Please let us know what you think of this calculator! We want to make it as user-friendly as possible, and to do that, we need your feedback. Please contact us and let us know what you like or dislike about it. Please place "Home Mortgage Calculator" in the subject line of your email.


Home Mortgage Calculator
Screenshot
THE Home Mortgage Calculator

This Excel spreadsheet is an all-in-one mortgage calculator. It lets you analyze a fixed or variable rate home mortgage. You can set up periodic extra payments, or add additional payments manually within the Payment Schedule. Use the spreadsheet to compare different term lengths, rates, loan amounts, and the savings from making extra payments. It also calculates the outstanding balance at the end of a specified number of years and the tax returned if the interest paid is tax deductible.

No Installation, No Macros, Ad-Free

Download the Home Mortgage Calculator Download Now

Cost: Free ($0.00)

File Type: zipped .xls
Size: ~125 KB
Version: 1.1.0
Required: Microsoft Excel 2002(XP), 2003, or 2007

Technical Support:
Contact Vertex42 via email if you have questions specifically about this calculator.

Help support Vertex42.com
(Not Tax-Deductible)

Note: Although we believe the calculations in this spreadsheet to be correct, we do not guarantee the results. Because your personal financial situation is unique, you probably shouldn't rely on this information for making your financial decisions. Please consult your financial advisor, accountant, and lending institution before making any financial decisions.

Using this Mortgage Calculator

Information about how to use the calculator and definitions of some of the terms are included as cell comments in the spreadsheet. So, if you have questions, you can hover the mouse cursor over any cell that has a little red triangle in the corner.

This calculator can help you answer some of the following questions:

  • How much can I save by making extra payments?
  • How does the tax deduction from paying interest change over time?
  • How much might my monthly payment change over time if I have a variable-rate mortgage?
  • How soon could I pay off my home if I make extra payments?
  • What will my loan balance be at the end of 3 or 5 years?

REFERENCES and RESOURCES:

Mortgage Loan at Wikipedia.org
Using a Calculator to Prepay ARM at mtgprofessor.com - Explains what happens if you make extra payments with an adjustable-rate mortgage.
Home Mortgage vs. Line of Credit from FederalReserve.gov - an excellent read!

Link to Our Home Mortgage Calculator

If you have a website, please share this free calculator with your visitors! You can copy the following html code to your website: