Use this calculator to estimate the balance remaining on a fixed-rate loan after a chosen number of monthly payments. Enter the original loan amount, annual APR, loan term, and elapsed months; the result is an amortization-based estimate, not a lender payoff quote.
Formula
This calculator estimates the level monthly payment and total interest for a fully amortizing loan. It does not calculate balance at a chosen age or after a selected number of payments: the required inputs and outputs in this calculator do not include a borrower’s age or elapsed-payment count. The formula shown here instead uses the entered term to estimate the scheduled payment for the entire loan.
For monthly interest rate r and total number of payments n, the payment is:
Payment = P × r / [1 − (1 + r)−n]
- P is the starting principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1,200. For an 8% APR, r = 0.08 ÷ 12.
- n is the number of monthly payments: years × 12.
- Total interest is the rounded monthly payment × n − principal, in dollars.
The result assumes a constant APR and equal monthly payments that cover principal and interest. The payment is rounded to cents before total interest is calculated.
Worked Example
Using the calculator’s defaults—$20,000 principal, 8% APR, and 5 years—first convert the APR and term:
- Monthly rate: 8 ÷ 1,200 = 0.0066667.
- Number of payments: 5 × 12 = 60.
- Payment before rounding: 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] ≈ $405.53.
- Monthly payment rounded to cents: $405.53.
- Total interest: $405.53 × 60 − $20,000 = $4,331.80.
Because each scheduled payment is rounded to the nearest cent, the last payment on a real loan may be adjusted slightly. The calculator’s total is an estimate based on 60 equal payments.
What “Balance With Age” Can Mean
The phrase “balance with age” can refer to different questions. Someone may mean the debt remaining as a loan gets older, or the relationship between a person’s age and their finances. Those are not the same calculation. A loan balance depends on principal, interest, payment amount, and payment history; age alone does not determine it.
To estimate a balance at a particular point, a calculation needs the number of payments already made, as well as the loan’s payment schedule and rate. For an ordinary fixed-rate loan, each payment first covers interest accrued for that period; what remains reduces principal. Early payments therefore tend to contain a larger interest share than later payments, while the outstanding principal gradually falls.
This page’s calculator accepts the loan’s full term, not elapsed months or a target age. It can provide the scheduled payment and total interest for the entered loan, but it cannot show a personalized balance at a borrower’s age. Do not treat its total-interest figure as the amount still owed at an intermediate date.
How Loan Balances Change
For a level-payment loan with monthly compounding, a balance estimate after k payments can be calculated as:
Bk = P(1 + r)k − M × [(1 + r)k − 1] ÷ r
Here, Bk is the estimated remaining principal in dollars, P is the original principal in dollars, r is the monthly rate as a decimal, k is the number of completed monthly payments, and M is the monthly payment in dollars. This is a related formula, not an output of the calculator above. It assumes regular payments made on schedule and a fixed rate.
For example, a balance estimate after 24 payments requires k = 24. A delay, missed payment, extra principal payment, rate change, or different payment timing can change the actual balance. A lender’s account statement or payoff quote may also reflect charges or adjustments this simplified calculation does not model.
When to Use the Estimate and Common Errors
This calculator is useful for understanding the relationship between a loan’s amount, APR, term, monthly payment, and scheduled interest. You can change one input at a time to see how the calculated payment changes, while remembering that the result depends on the assumptions below.
- Enter APR as a percentage, such as 8 for 8%, not as 0.08.
- Enter the term in years; the formula converts it to months.
- Do not confuse total interest over the full term with the current balance or a payoff amount.
- Use the principal actually borrowed as the amount, rather than adding costs unless those costs are financed into that principal.
- Expect differences if a lender uses different compounding, payment dates, rounding, fees, or a variable rate.
A calculated payment is not an approval decision or a measure of what someone can afford. It is arithmetic based on the values entered. Obtain the actual APR, fees, payment schedule, and account balance from the lender or loan documents.
Assumptions
- The interest rate is fixed for the full entered term.
- Payments are equal, monthly, and made at the end of each period.
- Interest compounds monthly at APR ÷ 12.
- The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, and extra payments.
Frequently Asked Questions
Does age determine how much of a loan is left?
No. The balance depends on the loan terms and payment history, not the borrower’s age by itself. Age can be used as a label for a point in time only if you also know when repayment began and how many payments were made.
Can this calculator show my balance after a certain number of years?
No. It calculates the scheduled monthly payment and full-term interest, but does not ask for elapsed months. A balance estimate needs the number of completed payments and must use a formula that tracks principal over time.
Why does the balance fall slowly at first?
With a standard amortizing loan, interest is calculated on the outstanding principal. When the balance is largest, more of each fixed payment goes toward interest; as principal declines, more of each later payment can reduce principal.
Is total interest the same as the amount I owe?
No. Total interest is the projected interest paid across the full scheduled term. The amount currently owed is a balance at a specific date, and a payoff quote may include items that this estimate excludes.
Why might my lender’s payment differ?
The lender may use different rounding, payment dates, fees, financed costs, or rate terms. Compare the calculator’s assumptions with the loan disclosure and account information.
This result is an estimate for educational arithmetic; the lender’s disclosure gives the exact figures.
Related
Formula used
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
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
- Bank of Queensland Loan Payment Calculator$405.53
- Loan Balance Calculator: Estimate What You Still Owe$16,611.17
- Bank of Queensland Home Loan Rates: What to Compare$405.53
- Balance Transfer Loan Calculator and How It Works$405.53
- Balance of Payments Formula for JC Business20.00
- Auto Loan Balance Calculator: Estimate Your Payoff$16,611.20