A loan balance is the amount shown as owed at a particular point in the loan, while a payoff amount is the exact sum required to close the loan on a specified date. This calculator estimates a loan’s remaining balance after a chosen number of monthly payments; enter the original loan amount, APR, term, and payments made to see the estimated balance, plus the scheduled monthly payment.
Formula
The calculator estimates the balance after a set number of equal monthly payments on a fixed-rate, fully amortizing loan. It first calculates the monthly payment, then applies the standard balance formula:
- Monthly rate: r = APR / 1,200, where APR is the annual percentage rate entered as a percentage.
- Monthly payment: M = round[P × r / (1 − (1 + r)−n), 2].
- Balance after k payments: B = P × (1 + r)k − M × [(1 + r)k − 1] / r.
P is the original amount borrowed, in dollars; r is the monthly interest rate as a decimal; n is the total term in months (years × 12); k is the number of payments made; M is the monthly payment in dollars, rounded to cents; and B is the estimated remaining principal balance in dollars. The calculation assumes payments are made monthly and on schedule.
Worked Example
Using the calculator’s default values—$20,000 principal, 8% APR, a five-year term, and 12 monthly payments made:
- Convert APR to a monthly rate: r = 8 / 1,200 = 0.0066667.
- Convert the term to months: n = 5 × 12 = 60.
- Calculate the payment: M = 20,000 × 0.0066667 / [1 − (1.0066667)−60] = $405.53, rounded to cents.
- Apply the balance formula after 12 payments: B = 20,000 × (1.0066667)12 − 405.53 × [(1.0066667)12 − 1] / 0.0066667 = $16,544.45, rounded to cents.
The calculator therefore displays an estimated balance of $16,544.45 and a scheduled monthly payment of $405.53. Small differences from an account statement can arise because actual payment posting dates and rounding may differ.
Assumptions
- The interest rate stays fixed for the entire loan term.
- Payments are equal, monthly, and made at the end of each monthly period.
- Interest accrues monthly using APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, and other amounts not entered.
Why a Payoff Amount Differs
The balance shown in an online account or statement is usually a principal balance calculated as of a particular date. A payoff quote is date-specific and can add interest accruing between the last payment and the date the lender receives the payoff. Depending on the loan and the lender’s calculation, it may also account for unpaid charges or an administrative fee. The quote may specify an expiration date because the amount can change as interest continues to accrue.
For example, a borrower might see a principal balance of $10,000 but receive a payoff quote above $10,000. That does not necessarily mean the account is wrong: the quote may include accrued interest and other amounts due to bring the account to zero on the stated date. The calculator’s balance is not a payoff quote and cannot determine these lender-specific additions.
How to Get and Use an Exact Payoff Quote
Ask the loan servicer or lender for a payoff statement or quote, and check its amount, date, payment instructions, and expiration date before sending money. A practical sequence is:
- Confirm which loan account the quote covers and the date through which the amount is calculated.
- Check whether the instructions require a particular payment method or reference information.
- Send the quoted amount so it arrives by the stated date; ask for an updated quote if timing changes.
- After payment, confirm the account is closed or has a zero balance, and follow up if the statement shows an amount still due.
Do not assume that paying the displayed principal balance will automatically satisfy the loan. A payment may be applied first to accrued interest or other amounts, leaving a small remainder. If the loan has a variable rate, irregular payments, fees, a balloon payment, or other nonstandard terms, a basic amortization estimate is especially limited.
Common Misunderstandings and Limits
“Balance” can mean more than one thing. A statement may show principal remaining, a current amount due, or a total account balance. Read the label and the statement date. The amount due this month is not necessarily the total needed to close the loan.
Payments do not reduce principal dollar for dollar. With an amortizing loan, part of each payment covers interest, and the remainder reduces principal. Early in a loan, a larger share of a scheduled payment may go to interest than later, depending on the terms. This is why the balance after a year is not simply the original principal minus 12 full payments.
Payment count matters. Enter payments actually posted, not merely scheduled or sent. The calculator allows up to 600 payments, but entering more payments than the loan’s full term can produce an extrapolated value that does not represent a closed loan. For a precise current balance, compare the estimate with the lender’s dated account information.
Frequently Asked Questions
Is the loan balance the same as the payoff amount?
No. A balance commonly refers to principal remaining or an account figure as of a stated date. A payoff amount is the lender’s dated total to satisfy the loan, and may include accrued interest or other amounts.
Why is my payoff quote higher than my principal balance?
Interest may have accrued since the balance date. A payoff quote can also include other unpaid amounts under the loan’s terms. Ask the lender to explain individual line items if the difference is unclear.
Does paying the balance shown on my statement close the loan?
Not necessarily. The statement may not include interest that accrues after its calculation date. Request a payoff quote for the date your payment is expected to arrive.
How long is a payoff quote valid?
Its validity depends on the quote and the loan’s terms. Check the stated good-through or expiration date; request a new quote if payment will arrive later.
Can this calculator tell me my exact payoff amount?
No. It estimates principal under a fixed-rate monthly-payment model. It does not know the lender’s posting dates, accrued interest, fees, or payoff instructions. The lender’s disclosure gives the exact figures.
This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Original loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 in k | Monthly payments made | - | 12 | 0 | 600 out bal | Estimated balance after payments | $ | p * (1 + apr / 1200) ^ k - round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2 out pmt | Scheduled monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- M&T Bank Lending Calculator: Estimate Loan Payments$405.53
- M&T Bank Payment Calculator: Estimate Loan Costs$405.53
- M&M Test and Balance: What It Measures
- M&T Bank Auto Loan Calculator: Estimate Payments$405.53
- Loan Term Calculator by Payment: Estimate Months to Pay Off47 months
- Personal Loan Calculator: Payments, Interest and Costs$405.53