Pay Off Mortgage Early and Save Money on Interest: Calculate savings in Excel Mortgage Calculator
How to Calculate Mortgage Payoff
The method for precisely determining the rate of amortization, which is the amount needed to pay off a particular mortgage loan, will vary depending on factors like the type of loan, its terms, and what options are exercised by the borrower. However, there is a standard formula used for calculating the loan payoff amount of a mortgage based on the principal, the interest rate, the number of payments made, and the number of payments remaining. This article provides detailed information that will assist you in calculating your mortgage payoff amount based on the terms of your loan. Contact your lender to confirm that your calculation is correct based on the particulars of your mortgage.
Knowing the Essentials
Understand why your mortgage payoff amount does not equal your current balance.Your statement says your most recent balance is ,250, and yet your payoff amount (the amount it would take to close out the mortgage) is listed as ,500. How can that be?
- You may assume that some complicated financial formulas are at play (ones that cost you money, of course), but in fact the answer is quite simple: mortgages are paid in arrears. That is, you pay June’s interest with July’s payment.
- This process starts at the beginning, at closing. If you close in June, for instance, your first payment won’t be due until August, with July’s interest included.
- Thus, to determine your payoff amount, the interest accrual since your last payment must be calculated and added to your balance. This interest wouldn’t typically be added to your balance until your next statement date.
Gather the information needed for your calculations.In order to determine the payoff amount, either using a calculation program or on your own, you need to know a handful of basic figures regarding your mortgage. All of these figures should be available on your statement or other loan documents. These include:
- The total amount borrowed when you took out the loan (for example, 0,000).
- The annual interest rate (for example, 3%, or 0.03). To do the calculations yourself, you will need to divide this number by twelve (0.03 / 12 = 0.0025), because mortgage interest compounds monthly.
- The total number of payments for the life of the loan, which for monthly payments is the number of years times twelve (for example, 20 years = 240 payments).
- The total number of years / payments remaining, and the number paid so far (for example, 15 years = 180 payments made; 5 years = 60 payments remaining).
Consider online calculators if you’d rather not exercise your math muscles.The calculations aren’t all that complicated, but punching a few numbers in and pressing “calculate” is certainly easier. A search for “mortgage payoff calculator” will provide several useful results. Try out a few to ensure accuracy.
- Please note, however, that you may find slight variations in your final results, probably only a few cents, but enough that you should always confirm your payoff amount with your lender before attempting to make a final payment.
- Using two such online calculators for a 0,000 loan at 3% annual interest over 20 years, with five years remaining, produces payoff results of ,729.26 and ,729.33, respectively.
Contact your mortgage lender if you plan to make a final payment.Avoid making what you think is a mortgage payoff only to find out that you still owe a few dollars or cents that keeps your mortgage alive and accruing interest.
- Contact your lender by phone or online; lenders with online account management likely have a page that allows you to make the request. You will likely receive your payoff amount after a week.
- You will be asked to choose a specific date for which to determine the payoff.
- If you want to make the final payment, you will need to complete some version of payment form (online or by mail) with the precise amount due and the time frame in which this amount is valid as a final payoff.
- Such requests can be made solely for informational purposes as well. Some lenders may even include a payoff amount on your monthly statement.
Making the Calculations
Lay out the formula carefully.It looks rather unwieldy at first, but the math is relatively straightforward once you’ve inserted your figures. Just be sure to copy the formula exactly or your results may vary significantly. The formula is:
- B = L [(1 + c)^n - (1 + c)^p] / [(1 + c)^n (- 1)] , in which:
- B = payoff balance due ($)
- L = total loan amount ($)
- c = interest rate (annual rate / 12)
- n = total payments (years x 12 for monthly payments)
- p = number of payments made so far
Insert your figures.Using the same example as for the online calculators, a 20-year, 0,000 mortgage at 3% interest with five years to go, appears thusly:
- B = 200,000 [(1 + 0.0025)^240 - (1 + 0.0025)^180] / [(1 + 0.0025)^240 (-1)]
- Remember that the 3% annual interest rate (0.03) is divided by twelve because it compounds monthly (c = 0.03 / 12 = 0.0025).
- Twenty years of monthly payments is 240 (n = 20 x 12 = 240), and fifteen years of payments so far is 180 (p = 15 x 12 = 180).
Power up your numbers.After adding 1 to 0.0025 the three times it appears in the formula, you will need to raise the resulting 1.0025 to the 240th power (twice) and to the 180th power (once). A good calculator will come in handy here.
- 1.0025^240 = 1.82075499532
- 1.0025^180 = 1.56743172467
- B = 200,000(1.82075499532 - 1.56743172467) / (1.82075499532 - 1)
Subtract from the inside.Once you accomplish this step, the formula will appear much more manageable and will be that much closer to completion.
- 1.82075499532 - 1.56743172467 = 0.253323270652
- 1.82075499532 - 1 = 0.82075499532
- B = 200,000(0.253323270652 / 0.82075499532)
Divide, multiply, and conquer.Now you can finish things off and solve for B, your payoff amount.
- 0.253323270652 / 0.82075499532 = 0.308646638883
- 200,000 x 0.308646638883 = 61729.3277766
- Therefore, your payoff amount is ,729.33.
QuestionHow do you calculate a mid-month mortgage payoff?
Real Estate BrokerReal Estate BrokerExpert AnswerTo calculate mid month, multiply the monthly payment for the insurance premiums, interest, taxes, homeowner insurance, and anything else that is lumped into the monthly mortgage payments by the number of days until the close divided by the number of days in the month.Thanks!
QuestionI have a mortgage with a private individual. I am going to pay off the mortgage. I need an ammortization schedule where I can plug in the amount of my monthly payments (0) for the last 2 years at 7% interest.
Real Estate BrokerReal Estate BrokerExpert AnswerYou can find free ammortization schedules on line. Just search for them. These will allow you to plug in your values.Thanks!
QuestionI owe 31900.00 on mortgage initially. The rate is 6.5 and I have 11yrs & 10 months to pay off, what would my payoff be
Real Estate BrokerReal Estate BrokerExpert AnswerThere are many other factors that are needed to answer this question. You need what the total term of the loan is, the original loan amount, the total number of payments in the term and the total number of payments made so far.Thanks!
I have a 0k loan on a 20 year mortgage. Mortgage gave me breakdown of principal and interest. If I pay my principal early, should i also pay the remaining interest?
If I spend a month not flushing the toilet, would I save enough money on water to pay down my principle in half the normal alloted 30 year time frame?
I understand the formula but I have been paying extra into the mortgage to drive the principle down. What modifications do I need to make to this formula to accommodate the lowered principle?
How can I use the stats on my loan to calculate a payment amount?
- You must get a quote for the mortgage payoff before you sell a property. The money you make on the sale will first go to covering the payoff, then towards all of the other associated fees and closing costs that the seller is responsible for. After these costs, you will then receive anything leftover.
- While you can make the calculations yourself, it always best to get the payoff number from the lender themselves. If your calculations are off even by a few cents, you may end up keeping the mortgage open, and you will continue to accrue interest.
Video: Mortgage Pay Off Strategy - Amortization Calculator
Alexis Mabille SpringSummer 2014 RTW – Paris Fashion Week
Survivalist Ed Stafford tells us the worst things hes ever eaten
These Drugstore Foundations Will Sort Out Even the Most Confused Skin
Bipolar Children and Teens
How to Measure Inseam on Jeans
11 Tips for Better Beach Walking
The most revealing takeaway from Weinstein ex-wife Georgina Chapman’s first interview
The Case for Not Traveling ThisThanksgiving
How to Choose a Browser for Your Android
Most common Asthma Symptoms in Children
What Witchcraft Taught Me About Self-Care
Whole30-Approved Foods and Pantry Staples
6 Mens Health Tips for Fathers Day
The top tips you need to cut down sugar in 2019