Loan Balance Over Time Calculator and Amortization

A loan balance over time calculator estimates how much principal remains after each monthly payment, using the loan amount, APR, term, and elapsed payment count. Enter the loan details and the number of payments made to see the estimated remaining balance alongside the monthly payment and total interest.

Formula

The balance formula is B_k = P(1 + r)^k − M[(1 + r)^k − 1] / r. Here, B_k is the balance after k monthly payments in dollars; P is the original principal in dollars; r is the monthly interest rate as a decimal, calculated as APR ÷ 1,200; k is the number of payments; and M is the fixed monthly payment in dollars.

The calculator uses the standard level-payment formula to find the payment: M = P × r / [1 − (1 + r)⁻ⁿ], where n is the number of monthly payments, or years × 12. It then uses that payment in the balance formula. Total interest is estimated as monthly payment × number of months − original principal.

The displayed balance is specifically after 12 payments, matching the calculator’s stated output. To estimate a different point in the schedule, use that payment count in place of 12 in the balance formula. The calculator holds the payment constant and does not model irregular payment dates or changes to the loan.

Worked Example

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

1. Calculate the unrounded monthly payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ $405.53. The calculator’s displayed payment is $405.53.
2. For the balance after 12 payments, use the formula: $20,000 × (1.0066667)¹² − $405.53 × [(1.0066667)¹² − 1] ÷ 0.0066667 ≈ $16,499.29.
3. Using the rounded displayed payment, total interest over 60 payments is $405.53 × 60 − $20,000 = $4,331.80.

Results are rounded to cents for display. The balance calculation uses the formula’s unrounded payment internally, while the total-interest output multiplies the displayed, cent-rounded payment by the number of payments. Consequently, small differences from a lender’s final schedule can arise from its rounding method.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal monthly payments made at the end of each monthly period; the balance is measured just after the twelfth payment.
• Interest compounds monthly using APR ÷ 12. This is a simplified monthly-rate model.
• Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.

How the Balance Changes

Each payment covers the interest accrued for that period first; whatever remains reduces principal. Early in a level-payment loan, the balance is relatively large, so more of the payment goes toward interest. As the balance falls, less interest accrues and more of each unchanged payment reduces principal. This is the pattern shown in an amortization schedule.

A balance does not usually fall by the full amount of the payment. For example, in the first month of the example, interest is about $133.33 ($20,000 × 0.0066667). With a $405.53 payment, roughly $272.20 reduces principal. Later payments have a different interest-principal split, even though the payment stays the same.

“Balance” can also mean a payoff amount. A payoff quote may include interest accrued since the last scheduled payment and other amounts that this calculator does not model. Treat the displayed figure as a mathematical estimate of principal remaining immediately after the specified payment, not as a lender’s payoff quote.

When to Use This Estimate

This calculator is useful for understanding the expected repayment path of a fixed-rate, fully amortizing loan, or for checking how much principal may remain after a year of payments. It can also help explain why a loan’s outstanding balance may decline more slowly at the beginning than a borrower expects.

For a meaningful estimate, use the original amount financed rather than the amount of cash received if the financed principal includes other items. Enter the APR and term shown in the lender’s disclosure. If the loan has already been partly repaid, use the original loan details and the actual number of payments made; entering today’s balance as the original amount would start a new hypothetical schedule.

Common Sources of Difference

• Variable rates: A changing APR alters later interest charges, so a fixed-rate projection will not track the actual schedule.
• Extra, missed, or late payments: These change principal and timing. The formula assumes equal payments on schedule.
• Different payment timing: A lender may calculate interest using daily accrual or another convention rather than the simplified monthly model.
• Rounding: Lenders may round interest or payments at different stages. Repeated small differences can change the final balance.
• Loan structure: Interest-only periods, balloon payments, deferred interest, or a final adjusted payment do not follow the standard level-payment schedule throughout.

APR is entered as a yearly percentage, not as a monthly percentage. The calculator converts it to a monthly rate by dividing by 1,200; entering a monthly rate where APR is requested would produce a substantially different result. Get the actual rate, payment schedule, and any fees from the lender rather than treating the example inputs as market figures.

Frequently Asked Questions

How do I calculate my loan balance after a certain number of payments?
Convert APR to a monthly decimal rate, calculate the scheduled payment, then apply the balance formula with the number of payments made. This calculator shows the balance after 12 payments; substitute another payment count in the formula to estimate a different point.

Does the balance include interest?
The formula estimates the principal remaining immediately after the specified payment. Interest due between payment dates, accrued payoff interest, and other charges are not added to that balance.

Why does the loan balance go down slowly at first?
Interest for each period is based on the outstanding principal. When the principal is high, more of a fixed payment goes to interest and less goes to principal. The principal portion generally grows as the balance declines.

Can I use this for a variable-rate loan?
Only as a simplified estimate under the assumption that the entered APR stays fixed. A rate change can alter the interest charged and payment schedule, so this calculation cannot forecast the changing balance accurately.

Why is my lender’s balance different?
Possible reasons include daily interest accrual, payment dates, extra or late payments, fees, rate changes, and rounding. Check the lender’s current statement or request an account-specific payoff figure for the precise amount.

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

Related

• Check Student Loan Balance: Estimate What You Owe
• Debit Loan Account Balance on Bank Statement?
• Certificate of Loan Balance: Meaning and How It Works

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 bal | Balance after 12 months | $ | p * (1 + apr / 1200) ^ 12 - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ 12 - 1) / (apr / 1200) | 2
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2