How to Create a Mortgage Calculator With Microsoft Excel
This wikiHow teaches you how to calculate your mortgage-related expenses like interest, monthly payments, and total loan amount using a Microsoft Excel spreadsheet. Once you’ve done this, you can also create a payment schedule that uses your data to generate a monthly payment plan to ensure you pay off your mortgage in time.
Method One of Two:
Creating a Mortgage Calculator Edit
Method Two of Two:
Making a Payment Schedule (Amortization) Edit