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:
Mortgage
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.