Mortgage Calculators for Excel
Download free Mortgage Spreadsheets for Microsoft Excel® - Updated 3/10/2025
Are you buying a home? Are you helping a client with a mortgage decision? Vertex42 provides many free mortgage calculators that you can download and work with on your own computer, using Microsoft Excel. You can customize the spreadsheets, add your own calculations, print amortization schedules, and save your results.
Advertisement
Featured Mortgage Calculators
The ultimate all-in-one mortgage calculator for Excel. Fixed or variable rate. Optional extra payments.
Estimate the mortgage that you can afford based on income, debt-to-income ratio, down payment, and housing expenses.
Create an amortization table and graphs for adjustable rate mortgage (ARM) loans.
A simple spreadsheet for comparing the monthly payment for different mortgages.
Advertisement
Need a second mortgage? This calculator can help answer the questions (a) How much can I borrow? (b) What will my monthly payment be? (c) How much equity will I have in N years?
This is a general revolving line of credit calculator, useful for estimating and tracking payments on a Home Equity Line of Credit (HELOC).
This is a special type of mortgage based on simple interest calculations and daily interest accrual.
Use this calculator to evaluate the mortgage payoff acceleration strategy of using a line of credit to make extra payments with optional paycheck parking.
Advertisement
Create an amortization schedule for a fixed-rate loan with an optional interest-only payment period.
This calculator was designed specifically for Canadian mortgages (and uses some different terminology), but the Home Mortgage Calculator above can also handle the semi-annual compounding for Canadian mortgages and has a more advanced method for choosing accelerated bi-weekly payment options.
This is one of the original mortgage spreadsheets created prior to most of the mortgage calculators listed above. The idea is to compare making extra payments to a basic interest-bearing savings account or investment.
More Free Mortgage Spreadsheets
- Home Expense Calculator - This worksheet helps you estimate the overall monthly cost of owning a home, besides just the mortgage interest and principal.
- Amortization Chart - Explains how to create a chart showing balance vs. interest and principal, with an example spreadsheet.
- Balloon Payment Loan Calculator - For when you are getting close to paying off your mortgage and you want to make a lump sum to finish up.
- Amortization Calculator - A web-based loan calculator
