How to Use Excel as a Full Mortgage Calculator

In this tutorial, you will learn how to use Excel as a full mortgage calculator.

Prerequisites: Microsoft Excel.

Step 1. Launch Excel, and select File – New

launch Excel

Step 2. Choose „Office Templates”.

Step 3. In the search box, type:


And see the results.

search for mortgage

Step 4. Excel is connecting to its server and showing you all the templates from the server. Choose „Mortgage Amortization Schedule”.

Click „ Download”. A full template for mortgage calculation is opened.

download template

Step 5: Fill in the upper fields with the details of your mortgage. Excel will do the rest.

fill in details and calculate

Result: Congratulations, you have learnt how to us Excel as a full mortgage calculator.