This weekend — through Sunday at 11:59 PM: BUNDLE-NOV21 takes 10% off the Practice in a Box + Everything Vault bundle. VAULT-NOV21 takes 15% off the Everything Vault. WEEKEND15 takes 15% off everything else, and the new Close the Month + Close the Year bundle is $149.
Browse templates →

How to Calculate Mortgage Payoff

Your mortgage's real cost is not the payment — it is the interest column added up over the life of the loan. Here is the amortization formula behind the payment, a worked example with round numbers, and the exact effect of paying extra principal each month.

$1,798.65payment on $300,000 at 6% for 30 years
$347,515total interest on that loan, no extras
81 monthsearlier payoff from +$200/month

Welcome to the numbers workshop

Hi, I'm Max — I run Vickery Finance, and this page is one room in the workshop. Everything here walks the same path: from shoebox-and-guesswork to a clean close you can defend, one honest number at a time. Work through it with your own figures in hand — that's when a guide turns into a result. And when you're ready to do the close instead of just reading about it, start with the Free Month-End Close Checklist: it's page one of the 18-step close my templates run, printable and yours to keep. Know your numbers.

What a mortgage payoff calculation actually shows

A mortgage payment looks fixed, but its two parts are not. Every payment splits into interest — calculated on the balance you still owe — and principal, which reduces that balance. Early in the loan the balance is large, so most of the payment is interest. Later, the balance is smaller and more of the same payment goes to principal. That split is why extra payments made early are worth so much more than the same dollars paid later, and a payoff calculation is simply the month-by-month split, run forward until the balance reaches zero.

The calculation answers three questions: what is the required monthly payment, how much interest will the loan cost in total, and how much sooner does the loan end — and how much interest disappears — if you add a fixed extra amount to principal each month?

The formula, step by step

The required payment comes from the standard amortization formula. You only need three inputs: the loan amount, the annual interest rate, and the term.

  1. Convert the rate and the term to months. Monthly rate = annual rate ÷ 12. Number of payments = years × 12. A 6% loan over 30 years becomes a monthly rate of 0.005 and 360 payments.
  2. Apply the payment formula. Payment = Loan × [ r(1 + r)n ÷ ((1 + r)n − 1) ], where r is the monthly rate and n is the number of payments.
  3. Split each payment. Each month, interest = current balance × monthly rate. The rest of the payment reduces the balance. That is the whole engine — repeat it until the balance is zero and add up the interest column to get the loan's true cost.
  4. Model an extra payment. Add the extra amount to the principal part of every payment. The required payment does not change, but the balance falls faster, so next month's interest is smaller, which frees even more of the fixed payment for principal. The loan ends early and the interest column totals less.
  5. Keep taxes and insurance separate. Property tax and homeowner's insurance may ride along in your monthly escrow payment, but they do not reduce the balance and do not change the payoff date. The free calculator shows them in the all-in monthly cost for budgeting, and leaves them out of the payoff math.

A worked example: $300,000 at 6% for 30 years

Take a $300,000 loan at 6% over 30 years. The monthly rate is 0.5% and there are 360 payments, so the formula gives a required payment of $1,798.65. Here is the same loan three ways — no extra payment, and two levels of extra principal:

PlanMonthly P&IPayoff timeTotal interest
No extra payment$1,798.65360 months (30 years)$347,515
+$200/month to principal$1,998.65279 months (23 yrs 3 mos)$256,341
+$300/month to principal$2,098.65252 months (21 years)$227,814

Read the middle row carefully, because it is the whole point of the calculation: an extra $200 a month ends this loan 81 months — about 6 years and 9 months — early, and removes about $91,174 of interest ($347,515 − $256,341). None of that requires a refinance, a new loan, or a lump sum. It is the same payment formula, with the principal part of each payment made larger. These are worked-example figures for one set of round inputs, not a prediction for any specific loan — run your own balance, rate, and term through the calculator to get your numbers.

Why the first extra dollars do the most work

In the first month of the example loan, interest is $300,000 × 0.5% = $1,500, so only $298.65 of the $1,798.65 payment reduces the balance. An extra $200 that month nearly doubles the principal reduction. Every dollar of balance removed early is a dollar that is never charged interest again for the remaining life of the loan, which is why starting an extra payment in year one saves noticeably more than starting the identical payment in year ten. It is also why a one-time lump sum toward principal, entered in the calculator's one-time extra payment field, has an outsized effect when it lands early.

Common mortgage payoff mistakes

When the answer matters

Run this calculation before you refinance, before you commit to extra payments, and whenever your rate, balance, or income changes. The decision it informs is a trade-off: money sent to principal earns a guaranteed return equal to your loan rate, but it becomes illiquid home equity. Knowing your exact payoff date and total interest — rather than a rule of thumb — is what makes that trade-off a decision instead of a guess.

If you carry other debts alongside the mortgage, work the full payoff order — which balance to attack first, and what your debt-free date is across all of them — in the Debt Payoff Planner, which lays snowball and avalanche plans side by side with a payment log and progress dashboard.

Get this exact template

The Debt Payoff Planner turns this payoff math into a month-by-month snowball or avalanche schedule for every debt you carry. It works in Excel and Google Sheets.

Excel & Google Sheets template — instant download. Price is the published list price. All sales are final.

Frequently asked questions

How is a mortgage payment calculated?

With the amortization formula: Payment = Loan × [ r(1 + r)n ÷ ((1 + r)n − 1) ], where r is the monthly rate (annual rate ÷ 12) and n is the number of monthly payments (years × 12). For $300,000 at 6% over 30 years, that is $1,798.65 a month in principal and interest.

How much does an extra $200 a month save?

On the worked example — $300,000 at 6% over 30 years — it ends the loan in 279 months instead of 360 and cuts total interest from $347,515 to $256,341, a saving of about $91,174. Your figure depends on your balance, rate, and how early you start, so run your own numbers in the calculator.

Is one lump sum or a monthly extra better?

They do the same work through the same mechanism — reducing the balance that interest is charged on. A lump sum helps most when it lands early; a monthly extra keeps helping every month. The calculator accepts both, so you can compare your actual options directly.

Do property taxes and insurance change my payoff date?

No. They change what you pay each month in total, but they never reduce the loan balance, so the payoff date and total interest are driven by principal, rate, term, and extra principal payments only.

Should I pay off my mortgage early or invest the extra?

Prepaying earns a certain return equal to your interest rate and removes a fixed obligation; investing may return more or less and carries risk. This guide teaches the payoff calculation so you can see your exact interest saving — the comparison against your own alternatives is a personal decision, and for many households a cash reserve comes before either.

Before you go

1 — Your first win (10 minutes): the Free Month-End Close Checklist — page one of the 18-step close, printable, free.

2 — Do it with the workbook: find your trade's template — every workbook runs this same clean-close ritual, with example data and a guided first step inside.

3 — Keep the rhythm: one practical numbers email a week — Know Your Numbers, free to subscribe.

The way back: start any visit at the Start Here hub, or email a human — [email protected]. I answer.

Know your numbers. — Max

Gear we use

Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you.

Texas Instruments BA II Plus — the financial calculator for amortization and time-value math, when you want the payoff numbers off-screen and double-checked by hand.

Canon P23-DHV-3 Printing Calculator — Canon's compact printing calculator for tape-checked totals at the counter.

Nonprofit Accounting & Financial Statements — Thomas R. Ittelson — nonprofit statements explained for boards, managers, and staff.

More books and gear live on the Resources page.