Home Mortgage Calculator


Home Mortgage Calculator


A powerful mortgage calculator for fixed and variable rate mortgages and optional extra payments.


If you have already purchased this Digital product, sign in to access your purchases



This is a commercial-use version of our popular Home Mortgage Calculator for Excel. If you are a borrower wanting to analyze your own home loan, you can download the personal-use version from Vertex42.com for free. You can also download the free version if you want to try the spreadsheet before purchasing.

There is also a video on our website demonstrating how to use this spreadsheet.

Visit Vertex42.com for more information about this template.

License: Commercial Use (for assisting clients, seller financing, and use by real estate companies. Not for resale, re-branding, or public distribution)


  • Fixed or variable-rate mortgages
  • Optional extra payments
  • Monthly or Semi-Annual compounding
  • Accelerated Biweekly and Accelerated Weekly payment options

Some Limitations:

  • Not for mortgages that accrue interest on a daily basis.
  • Not for detailed payment tracking such as missed payments, fees, escrow, etc.
Store Policies

Thank you for your interest in templates by Vertex42.com!

All of our templates are copyrighted works, so that means the templates, including any modified versions of the templates, may not be sold, distributed, published to an online gallery, hosted on a website, or placed on a public server such as the internet, without written permission from Vertex42 LLC.

The Vertex42 attribution within our templates may not be removed. Documents designed for purposes such as invoicing and other business-to-business communication generally allow you to create printouts or PDFs with minimal or no Vertex42 branding, depending on the application.

Some of our templates are licensed for Private Sharing, such as project management templates designed to be shared with a project team, timesheets that are shared with a manager, or a team roster that is shared with parents of the players.

Some of our templates are licensed for Personal Use Only, such as personal finance spreadsheets, meaning that they should not be used in a business for business purposes.

Some of our templates may be licensed for Commercial Use, which means they can be used in a business for business purposes, but still never for resale or general distribution.

Each of our templates contains information about which license applies. Thank you for your attention to these details.

Customer Reviews

No reviews yet

More from Vertex42.com

Thank you for your interest in our incentive!

To apply and receive this incentive, fill in the form below. We will contact you on how this incentive works and how we can support you in the implementation. You will receive a confirmation email with a download link to important information about this incentive.

You will receive a confirmation email for your request. The confirmation email will consist of a link to download necessary content in relation to this incentive/offer. By downloading the content you also agree to confirm email subscription form the store and the marketplace. You can always unsubscribe to email subscriptions at any time you wish in the future.


Thank You for your interest in my free download!

To download this free content, just enter your e-mail address below. We will send you an email with the link to download this free content.

Please verify your e-mail subscription in the confirmation e-mail you will receive. You can always unsubscribe anytime you wish in the future.