Mortgage Payment Calculator

This simple mortgage calculator was designed for making side-by-side comparisons of different monthly mortgage payments, not including closing costs, mortgage insurance, or property taxes.

Compare the monthly payment for different terms, rates, and loan amounts to figure out what you might be able to afford. You should also consider how much interest you'll end up paying in the long run. Generally, for longer terms, your payment may be lower, but the total interest may be a lot more. You also might want to try the Home Expense Calculator to take into account some of the other expenses associated with home ownership.

The calculator is set up to compare 5 different mortgages, but you can easily expand this by inserting more columns. Just copy and paste one of the existing columns.

Making extra payments on the principal or "prepayments" can help you pay off your mortgage early and save money by not paying as much interest. This calculator lets you evaluate the effect of making an extra payment each month. The home mortgage calculator lets you add annual payments as well as occasional lump sums.

When considering the interest savings, the simple way to view making extra payments is that it is very similar to investing the money in a interest bearing account with the same interest rate as your mortgage rate (not including the effect of taxes). The main difference is that your money may not be as liquid because you'd need to sell your house or use your equity as collateral to make use of the extra money you've put into your house.

An "Accelerated Biweekly Payment" plan usually refers to a strategy for paying off your mortgage early and paying less interest overall. Normally, your payments would be set up automatically to be made every two weeks. The payment would be equal to one half of a normal monthly payment. You'd end up making 26 payments instead of 24 within a year, resulting in prepayments on the principal equivalent to one monthly payment.

So, to estimate the effect of making accelerated biweekly payments, you just include an amount in the Extra Monthly Payment field equal to the Monthly Payment divided by 12. You can use a formula for this by entering "=C13/12" in cell C14.

The bottom rows of the calculator are for estimating the amount of equity in your home after a number of years. This can be useful if you are planning to sell your home in a few years. The equity calculation includes the total principal paid (including extra payments) as well as your original down payment.