Excel Model: Early Mortgage Payoff Calculator

Title: Early Mortgage Payoff Calculator

 Description:

 

This spreadsheet helps users calculate the benefits of making extra payments on their mortgage to pay it off early. It includes sections for loan information, a summary of loan payments with and without extra payments, and a detailed payment schedule.

 

  • Loan Information: Enter details such as loan amount, annual interest rate, term of the loan, and extra monthly payment.
  • Loan Summary: Compare monthly payment, number of payments, total payments, total interest, and interest savings with and without extra payments.
  • Payment Schedule: Track monthly payments, including breakdowns of principal and interest, cumulative totals, and remaining balance.

 

Source: Custom Calculator

Click the following icon to open the full workbook viewer in a new tab, allowing you to easily edit and save.

Click the following icon to download the spreadsheet, allowing you to save the file on your computer along with edits.

Leave a Comment