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
Step 2. Choose „Office Templates”.
Step 3. In the search box, type:
And see the results.
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.
Step 5: Fill in the upper fields with the details of your mortgage. Excel will do the rest.
Result: Congratulations, you have learnt how to us Excel as a full mortgage calculator.