Loan Balance Graph Equation Over Time

A loan balance graph shows how much principal remains after each payment; its equation is the balance formula for the loan’s interest rate, payment, and elapsed payment periods. Enter a loan amount, annual percentage rate (APR), and term below to calculate the fixed monthly payment and total interest, then use the balance equation and example to plot the amount owed over time.

Formula

For a fixed-rate loan with equal monthly payments, the balance after k payments is:

B_k = P(1 + r)^k − M × ((1 + r)^k − 1) / r

Here, B_k is the outstanding balance in dollars after payment k; P is the original loan principal in dollars; r is the monthly interest rate as a decimal; M is the fixed monthly payment in dollars; and k is the number of monthly payments made. Convert APR to a monthly decimal with r = APR / 1200 when APR is entered as a percentage. The payment used here is calculated from the standard level-payment formula: M = P × r / (1 − (1 + r)⁻ⁿ), where n is the number of monthly payments.

The calculator uses the term to calculate the monthly payment and total interest. Its balance equation can then produce points for a graph: evaluate it at integer values of k from zero to n. At k = 0, the balance is the original principal; at the end of a fully repaid schedule, it should be approximately zero, subject to cent rounding.

Worked Example

Using the calculator’s default inputs, the principal is $20,000, APR is 8%, and the term is 5 years. The number of monthly payments is n = 5 × 12 = 60, and the monthly rate is r = 8 / 1200 = 0.0066667.

1. Calculate the unrounded payment: M = 20,000 × 0.0066667 / (1 − (1.0066667)⁻⁶⁰), approximately $405.53.
2. The calculator’s payment output is displayed to cents: $405.53 per month.
3. Total interest is calculated using that rounded payment: $405.53 × 60 − $20,000 = $4,331.80.
4. For the balance after 12 payments, substitute k = 12 and the rounded payment: B₁₂ = 20,000(1.0066667)¹² − 405.53 × ((1.0066667)¹² − 1) / 0.0066667, approximately $16,377.70.

That gives a graph point at month 12: (12, $16,377.70). To sketch the full curve, repeat the calculation at selected months, such as 0, 12, 24, 36, 48, and 60. A lender’s exact schedule may differ by a few cents because of payment rounding and its precise interest and posting conventions.

How to Read the Graph

Put elapsed months on the horizontal axis and outstanding principal on the vertical axis. The line generally slopes downward for a fully amortizing loan with payments large enough to cover accrued interest. It is usually curved rather than straight: early payments allocate a larger share to interest, while later payments reduce principal more quickly.

At each month, interest is applied to the previous balance and the payment reduces what remains. In a simplified monthly model, the update is B_k = B_k−1(1 + r) − M. The closed-form balance equation above is the result of applying that update repeatedly. The first payment’s approximate interest portion is the starting balance times the monthly rate; the rest of that payment reduces principal.

When to Use This Equation

The formula is useful for understanding a standard installment loan’s payoff path, estimating the remaining balance at a particular month, or making a basic graph from a payment schedule. It can also help distinguish the loan’s payment amount from its balance: the payment is the regular cash amount due in this model, while the balance is the principal still outstanding after a specified number of payments.

• Use k = 0 for the balance before any payment.
• Use the number of completed payments, not the current calendar month, for k.
• Use the same payment frequency as the model. This calculator assumes monthly payments.
• For a graph with many points, calculate each month or use a spreadsheet based on the monthly balance update.

Common Misconceptions and Limits

A balance graph is not generally a straight-line reduction of principal. Dividing the original loan amount evenly by the number of payments ignores interest; with a level payment, interest is part of each payment and its share changes over time. Another common error is entering APR as a decimal when the formula expects a percent: enter 8 for 8%, not 0.08. The calculator converts the percentage by dividing by 1200.

This model assumes a fixed rate and regular, on-time monthly payments. It does not represent a variable-rate loan, irregular payment dates, skipped or late payments, additional principal payments, or a changing payment amount. It also does not calculate fees, taxes, insurance, PMI, or escrow. If the actual loan has those features, a simple fixed-payment graph may not match the account statement; use the lender’s payment schedule or obtain the relevant details to model them separately.

Rounding matters. The calculator displays the monthly payment to the nearest cent and bases total interest on that rounded payment. A real schedule may apply interest daily, round each period differently, or adjust a final payment. Consequently, formula-based graph points are estimates rather than a substitute for an account’s posted balance.

Assumptions

• Interest rate is fixed for the full term.
• Payments are equal, monthly, and made at the end of each monthly period.
• Interest compounds monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, and escrow are not included.

Frequently Asked Questions

What is the equation for a loan balance after k payments?
For a fixed monthly rate, use B_k = P(1 + r)^k − M((1 + r)^k − 1)/r. Convert APR to a monthly decimal, and use the payment and completed payment count that match the loan schedule.

How do I graph a loan balance over time?
Calculate the balance at month 0 and at later payment counts, then plot months on the horizontal axis and dollars owed on the vertical axis. The monthly recurrence, B_k = B_k−1(1 + r) − M, is convenient for generating points one month at a time.

Why does the loan balance fall slowly at first?
Interest is calculated on the outstanding balance. At the beginning, the balance is largest, so more of each fixed payment covers interest and less reduces principal. As the balance shrinks, the interest portion generally declines.

Can the balance graph show extra payments?
Not with this fixed-payment calculator. An extra payment changes the balance path and may change the payoff date or required final payment. Model each extra payment in the monthly balance update, following the loan’s payment and interest rules.

Why does my calculated balance differ from the lender’s figure?
Differences can result from daily rather than monthly interest accrual, payment posting dates, rounding, fees, rate changes, or extra payments. The equation is a simplified estimate; consult the lender’s statement for the account’s recorded balance.

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

Related

• Car Loan Balance Transfer: Costs, Steps, and Calculator
• Gibbs College Loan Balance Calculator
• Flora Balance Ritual: Meaning, Uses, and Safety

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