calculate-loan

01 Loan payments

Loan Balance Confirmation: What It Shows

Calculator No. 01-7720 · Updated · Formula and assumptions shown below

Estimated loan balance $16,611.17
Monthly payment
$405.53
Level-payment formula, rounded to the cent
Original loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Original loan amount ($), Interest rate (APR) (%), Loan term (years), Monthly payments made
You get
Estimated loan balance ($), Monthly payment ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A loan balance confirmation letter is a written statement from a lender or loan servicer confirming the amount it records as outstanding on a specified date. This page’s calculator estimates the balance after a chosen number of monthly payments; enter the original loan amount, APR, term, and payments made to see an estimated remaining balance and a payment-based cross-check.

Formula

The calculator estimates the balance after k monthly payments on a fixed-rate, level-payment loan. In symbols:

r = APR / 1200
M = round[P × r / (1 − (1 + r)−n), 2]
Bk = P × (1 + r)k − M × [(1 + r)k − 1] / r

  • P is the original principal, in dollars.
  • APR is the annual percentage rate entered as a percentage, such as 8 for 8%.
  • r is the monthly rate as a decimal, calculated as APR divided by 1,200.
  • n is the total term in months: years multiplied by 12.
  • M is the monthly payment rounded to cents.
  • k is the number of monthly payments made.
  • Bk is the estimated remaining balance after those payments.

The formula assumes each payment is made at the end of a monthly period and applies interest at the same monthly rate throughout. It is a mathematical estimate, not a lender-issued confirmation.

Worked Example

Using the defaults—$20,000 principal, 8% APR, a five-year term, and 12 payments made—first calculate the monthly rate and number of payments:

r = 8 / 1,200 = 0.0066667; n = 5 × 12 = 60.

Monthly payment: M = round[20,000 × 0.0066667 / (1 − (1.0066667)−60), 2] = $405.53.

Balance after 12 payments: B12 = 20,000 × (1.0066667)12 − 405.53 × [(1.0066667)12 − 1] / 0.0066667 = $16,390.54.

The payment output is the scheduled amount under the formula; the balance output is the estimated amount remaining after the stated number of payments. Actual account figures can differ because of payment dates, rounding, fees, or loan-specific terms.

Assumptions

  • The interest rate is fixed for the modeled period.
  • Payments are equal, made monthly at the end of each period, with 12 periods per year.
  • Interest accrues monthly at APR divided by 12.
  • The estimate does not include fees, taxes, insurance, PMI, escrow, missed or extra payments, or changes to the loan terms.

What a Loan Balance Confirmation Letter Shows

A confirmation letter records the balance a lender or servicer reports at a particular point in time. It may be requested for personal recordkeeping, bookkeeping, an account review, or a transaction in which someone needs written evidence of the debt. The document’s exact format and contents vary by provider and purpose; it is not necessarily a payoff quote.

Depending on the account and request, a letter may identify the borrower and loan account, state the balance as of a named date, and show a breakdown of principal, accrued interest, or other amounts. It may also explain how to request an updated figure. Check the document itself rather than assuming every letter contains the same detail.

The date matters. Interest can accrue and payments can post after a balance is calculated, so a figure confirmed as of one date may not equal the amount due later. If you need an amount to close or pay off an account, ask the servicer for a payoff figure valid through the relevant date and follow its instructions.

How to Request and Check One

Contact the lender or servicer through its established customer-service channel and ask for a balance confirmation stating the “as of” date. The provider may require identity or account verification, and may offer the document through a secure account, by mail, or another channel. Confirm any delivery options or charges directly; they are provider-specific.

  1. Specify which loan account you mean and the date for which you need the balance.
  2. Ask whether the requested document is a balance confirmation, a transaction history, or a payoff quote; these serve different purposes.
  3. Review the borrower and account identifiers, balance date, currency, and itemized amounts if shown.
  4. Compare the figure with recent statements and posted payments, allowing for payment-processing and interest timing.
  5. If something does not match, ask the servicer for a written explanation or a corrected statement.

Handle the letter as sensitive financial information. Use the provider’s secure channel where available, check that the recipient is correct before forwarding it, and avoid sharing full account details unnecessarily.

Confirmation, Statement, and Payoff Quote

These terms are related but not interchangeable. A periodic statement summarizes account activity and amounts due for its billing period. A balance confirmation states the reported balance on a specified date. A payoff quote is intended to give the amount required to pay an account in full by a stated date, and may account for interest through that date or other contract-specific amounts.

A calculator estimates a balance from supplied inputs; it cannot confirm what a lender’s records show. Even a close match does not make the calculation an official document or establish that the loan is paid off. For a decision that depends on the recorded account amount, obtain the relevant statement or written confirmation from the servicer.

Why Figures May Differ

A calculator’s result can differ from a letter for ordinary reasons. The calculator uses a simplified monthly schedule, while account systems may reflect exact posting dates, daily interest calculations, payment allocation rules, rounding, or loan changes. The balance can also be affected by extra or missed payments, deferments, capitalization, fees, or a rate that changed during the period—none of which this calculator models.

Common input errors include entering 8% as 0.08 instead of 8, using the remaining term in place of the original term, or counting a payment that has not posted. Check the APR and dates in your loan documents and statement, and count payments actually credited to the account. The calculator’s amount should be treated as an estimate, especially if the loan is not a fixed-rate, level-payment loan.

Frequently Asked Questions

How do I get a loan balance confirmation letter?
Ask the lender or servicer that maintains the account, state which loan you mean, and request a balance as of a specific date. Follow its identity-verification and delivery process.

Is a loan balance confirmation the same as a payoff letter?
No. A balance confirmation reports a balance as of a date. A payoff quote is intended to state the amount needed to pay the loan in full by a specified date; ask the servicer which document meets your need.

Does a balance confirmation letter prove a loan is paid off?
Not by itself. A zero balance shown for a given date may be useful account evidence, but ask the servicer for written confirmation that the account is closed or satisfied if that is what you need.

Why is my letter’s balance different from the calculator?
The calculator assumes a fixed APR, regular monthly payments, and a standard amortization schedule. Posting dates, daily interest, extra payments, fees, rate changes, and rounding can produce a different account balance.

How recent should the confirmation letter be?
That depends on why it is being requested and what date the recipient requires. Because balances can change as interest accrues and payments post, request a figure dated for the relevant purpose.

The result is an estimate for education, 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 loan 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 pmt | 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

The whole Loan payments section →