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

1

This is our free full-featured mortgage calculator, including fixed-rate and adjustable-rate mortgages, amortization schedule, and optional extra payments.

2

Find out how much home you can afford based on your income, debt-to-income ratio, available funds, and other housing expenses.

3

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

4

This is a simple calculator for making side-by-side comparisons of multiple mortgages.

Advertisement
5

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?

6

Estimate and track payments on a Home Equity Line of Credit (HELOC).

7

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

8

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
9

This is for fixed-rate interest-only mortgages, where the interest-only period is specified as a number of years.

10

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.

11

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

 

Follow Us On ...

FB  PIN  TWEET  LI  IG  YT 
Budget Templates by Vertex42.com
Template Categories

Finance Articles

Make a Budget Financial Modeling Excel Financial Functions Simple Interest Compound Interest Amortization Calculation Amortization Formulas Negative Amortization Debt Consolidation Growth Rate CAGR Calculator & Formula Discount Factors Depreciation NPV