Loan Payoff Sheet: What It Shows and How It Works

A loan payoff sheet is a lender-provided statement showing the amount needed to pay a loan in full on a specified date. This page’s calculator estimates the payoff balance for a fixed-rate loan after a chosen number of monthly payments; enter the original loan amount, APR, term, and payments already made to see the estimated balance and interest paid.

Formula

The calculator uses the standard balance formula for a fixed-rate loan with equal monthly payments. It first calculates the monthly payment, then applies the balance formula after k payments:

• Monthly payment: M = P × r ÷ [1 − (1 + r)⁻ⁿ]
• Estimated balance: B = P × (1 + r)^k − M × [(1 + r)^k − 1] ÷ r

P is the original principal in dollars, r is the monthly interest rate (APR ÷ 1,200), n is the total number of monthly payments (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 balance in dollars. The second output, estimated payments made, is the rounded monthly payment multiplied by k; it is not the amount of principal repaid.

Worked Example

Using the defaults—$20,000 principal, 8% APR, a five-year term, and 12 payments made—the monthly rate is 0.08 ÷ 12 = 0.0066667 and the term is 60 payments.

1. Calculate the monthly payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = about $405.53 per month, rounded to cents.
2. Apply the balance formula after 12 payments: $20,000 × (1.0066667)¹² − $405.53 × [(1.0066667)¹² − 1] ÷ 0.0066667 = approximately $16,480.85.
3. Payments made total $405.53 × 12 = $4,866.36. This total includes both principal and interest.

Small differences can occur if a lender uses a different payment schedule, daily interest calculation, or rounding method.

Assumptions

• The APR is fixed for the full modeled term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly at APR divided by 12.
• The estimate excludes payoff fees, other charges, taxes, insurance, PMI, and escrow.

What a Loan Payoff Sheet Shows

A payoff sheet—also called a payoff statement or payoff quote—is a dated calculation from the loan servicer or creditor. It states the amount required to bring the account to zero when payment is received by a specified date. It may show the unpaid principal, interest accrued through that date, fees or other account charges, credits, and instructions for sending the funds.

The figure is usually date-specific because interest can accrue between the statement date and the date the payment arrives and is processed. A payoff amount is therefore not necessarily the same as the principal balance shown on a regular account statement. A statement may also show a “good-through” date and a per-day interest amount, sometimes called per diem, that helps explain how the total changes if payment is delayed. Confirm those details with the loan servicer rather than assuming the calculator’s balance is the amount to send.

How to Use the Estimate

Enter the original amount borrowed, the loan’s APR, the original term, and the number of scheduled monthly payments completed. The calculator estimates the remaining balance under its fixed-rate assumptions. The payment count should represent payments actually applied to the account, not merely months elapsed. For example, if a payment was skipped or posted late, a simple count may not match the lender’s balance.

For an exact payoff figure, request a current payoff statement from the lender or servicer and follow its payment instructions. Check the amount’s valid-through date, the required method of payment, any processing deadlines, and whether the lender requires an additional amount if funds arrive late. Do not send funds based only on this estimate.

Why an Estimate Can Differ from the Payoff Quote

The formula models a regular amortizing loan, where each payment covers interest due and reduces principal. Real accounts can include details that are not represented here. Differences may arise from payment timing, daily rather than monthly interest accrual, variable rates, late or missed payments, extra principal payments, payment holds, accrued fees, or lender-specific rounding. The original APR and term may also fail to describe a loan after a modification or rate change.

Extra payments are particularly important: if they were applied to principal, the actual balance may be lower than this estimate. If they were held, applied to a future installment, or allocated differently, the effect may differ. Review the account’s transaction history and ask the servicer how payments were applied when the calculator’s result does not align with the account balance.

Payoff Sheet Compared with an Amortization Schedule

An amortization schedule lays out expected payments over the life of a loan, typically showing each payment’s interest and principal portions and the projected balance afterward. A payoff sheet answers a narrower question: how much is required to close the account on a particular date. The schedule is a forecast based on its assumptions; the payoff statement is the lender’s dated account calculation.

A loan payoff sheet is also different from a paid-in-full confirmation. The payoff statement tells you what to pay; a confirmation or account update can help verify that the payment was received and the balance was cleared. Keep the statement and payment confirmation with your records.

Common Questions About Payoff Sheets

How do I get a loan payoff sheet?

Contact the lender or servicer through its official account channel and request a payoff statement for a specific date. Ask how long it remains valid and how to handle any delay in sending or processing funds.

Is a payoff amount the same as the balance on my statement?

Not always. The statement balance may reflect principal as of an earlier date, while a payoff amount can add interest accrued through a later date and applicable account charges or credits.

Why does the payoff amount change each day?

Interest may continue accruing until the loan is paid and the payment is processed. A lender may provide a good-through date or per-day interest figure; use the lender’s instructions for a later payment date.

Can I use this calculator for an exact payoff?

No. It estimates a balance for a level-payment, fixed-rate loan and does not include all account-specific activity or lender calculations. Request a dated payoff statement for the amount to remit.

What should I check before paying?

Verify the payoff amount, valid-through date, payment instructions, delivery or processing timing, and any stated additional daily interest. After payment, check the account for a zero balance or request confirmation.

This result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Loan Payoff Calculator Ramsey: Estimate Your Debt-Free Date
• Loan Payoff Calculator for Weekly Payments
• Loan Payoff Calculator for Biweekly Payments

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 | Payments already made | - | 12 | 0 | 599
out bal | Estimated payoff balance | $ | 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 paid | Estimated payments made | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * k | 2