Loan Balance Amortization Calculator: See What You Owe

A loan balance amortization calculator estimates your monthly payment, total interest, and the balance remaining over a fixed-rate loan’s scheduled term. Enter the original loan amount, annual APR, and term in years to see an estimate based on equal monthly payments.

Formula

The calculator uses the standard level-payment amortization formula. It calculates the monthly payment from the principal and monthly interest rate, then subtracts the original principal from the sum of all scheduled payments to estimate total interest.

• Monthly payment: M = P × r ÷ [1 − (1 + r)⁻ⁿ]
• Total interest: I = M × n − P
• Monthly rate: r = APR ÷ 1,200
• Number of payments: n = loan term in years × 12

P is the starting principal in dollars, APR is the annual percentage rate entered as a percentage, r is the monthly rate as a decimal, n is the number of monthly payments, M is the monthly payment in dollars, and I is estimated total interest in dollars. For example, an APR of 8% becomes 0.08 ÷ 12, or about 0.006667 per month. The displayed payment is rounded to cents; the total-interest estimate uses that rounded monthly payment multiplied by the scheduled number of payments.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a 5-year term—the loan has 60 monthly payments. The monthly rate is 0.08 ÷ 12 = 0.0066667.

1. Calculate the payment: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
2. The unrounded result is about $405.53, so the monthly payment rounded to cents is $405.53.
3. Multiply the displayed payment by 60: $405.53 × 60 = $24,331.80 in scheduled payments.
4. Subtract the original principal: $24,331.80 − $20,000 = $4,331.80 estimated total interest.

The payment and interest figures are estimates under the formula’s assumptions. Actual loan statements can differ because of payment dates, rounding conventions, fees, rate changes, or other contract terms.

Assumptions

• The interest rate remains fixed throughout the full term.
• Payments are equal monthly installments, made at the end of each monthly period.
• Interest accrues monthly using APR divided by 12.
• The calculation excludes fees, taxes, insurance, private mortgage insurance, and escrow.
• It assumes every scheduled payment is made in full and on time, with no extra payments or missed payments.

How to Read an Amortization Balance

An amortization schedule tracks how each payment is divided between interest and principal. Early in a fully amortizing loan, the balance is relatively high, so the interest portion of a payment is generally larger. As the principal falls, less interest accrues each month and more of the same payment goes toward principal. The scheduled payment can remain level even while its components change.

This calculator reports the payment and total interest for the full scheduled term; it does not display a month-by-month balance. For a specific point in time, the standard balance formula after k payments is B_k = P(1 + r)^k − M × [(1 + r)^k − 1] ÷ r. Here, B_k is the remaining balance after k payments. The result depends on the actual payment count and timing. A lender’s current payoff amount may also include accrued interest or contract-specific charges, so a calculated balance is not automatically a payoff quote.

When to Use This Calculator

Use it to understand the basic payment and interest arithmetic for a fixed-rate loan, or to explore how changing the amount, APR, or term changes those estimates. Enter figures from a lender’s written disclosure or loan documents when available. The APR and term are inputs, not a prediction of what rate or terms a lender will offer.

A longer term generally means more scheduled payments. Even if a longer term reduces the calculated monthly payment for the same principal and rate, it can increase the total interest because interest accrues over more months. A shorter term has fewer payments, but the monthly payment calculated by this formula may be higher. These are mathematical effects, not a recommendation about which term to select.

Common Problems and Limits

• Entering the rate incorrectly: Enter 8 for an 8% APR, not 0.08. The formula converts the percentage to a monthly decimal by dividing by 1,200.
• Using the wrong term unit: The input is in years; the calculation multiplies it by 12. If a document states a term in months, convert it to years before entering it.
• Confusing APR with a periodic rate: APR is an annual input here. This simplified calculation does not separately model fees that may affect a disclosed APR or the loan’s cash flows.
• Rounding differences: The monthly payment is rounded to cents, so multiplying it by the number of payments can differ slightly from a total calculated using unrounded payments. Lenders may also round interest or payment amounts differently.
• Assuming all loans amortize this way: Variable-rate loans, interest-only periods, balloon payments, irregular payment schedules, and loans with changing terms do not follow this fixed-payment model throughout.

The formula also excludes extra principal payments, late payments, skipped-payment arrangements, and changes to the balance. If any of these apply, the actual amortization schedule will not match this simplified estimate.

Frequently Asked Questions

What does loan balance amortization mean?
It describes how scheduled payments reduce a loan balance over time while covering interest. In a standard fully amortizing loan, the payment plan is designed to bring the balance to zero after the final scheduled payment, subject to the agreement’s terms and rounding.

Does this calculator show my balance after each month?
No. It estimates the monthly payment and total interest for the full term. A month-by-month schedule can be calculated using the balance formula and the actual number of payments made, but this calculator does not generate that schedule.

Why can the lender’s balance differ from this estimate?
The calculation assumes a fixed APR, regular monthly timing, and no fees or payment changes. A statement may reflect actual payment dates, accrued interest, rounding, extra payments, a variable rate, or other terms in the loan documents.

Does total interest include fees or insurance?
No. It is the difference between the estimated scheduled payments and the original principal. Fees, taxes, insurance, escrow, and other charges are not included.

Can I use this for a variable-rate loan?
Only as a limited illustration using one APR for the entire term. If the rate changes, the payment or balance path can change too, so this result will not model the loan’s changing schedule.

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

Related

• Account Bank Loan Balance Calculator
• Vehicle Into Trade Calculator: Estimate Trade-In Equity
• Vehicle Loan Calculator With Trade-In: Estimate Payments

in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2