Mortgage Calculators for Excel

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.

Featured Mortgage Calculators

THE Home Mortgage Calculator

• Our free full-featured mortgage calculator, including fixed-rate and adjust-rate mortgages, amortization schedule, and optional extra payments.

ARM Calculator

• How bad can an ajustable rate mortgage get?
• How high might your monthly payment get over time?
• Include optional extra payments.

Mortgage Payment Calculator

• Simple calculator for making side-by-side comparisons of different mortgages

Home Equity Loan Calculator

• Need a second mortgage? Hopefully not.

Home Equity Line of Credit Calculator

• Useful for estimating and tracking payments on a Home Equity Line of Credit (HELOC).

Simple Interest Mortgage Calculator

• This is a special type of mortgage based on simple interest calculations and daily compounding.

Interest-Only Mortgage Calculator

• For fixed-rate interest-only mortgages loans, where the interest-only period is specified as a number of years, after which the mortgage amortizes at a fixed-rate over the remaining years.

More Free Mortgage Spreadsheets

•  Canadian Mortgage - Designed specifically for Canadian mortgages, where the compound period is semi-annual.
• Extra Payment Mortgage Calculator - Compares making extra payments to putting the money in an interest bearing savings account or investment.
• 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