Loan Amortization Tool: Monthly Payment and Interest

A loan amortization tool estimates a fixed monthly payment and the total interest paid over a loan’s scheduled term. Enter the loan amount, annual percentage rate (APR), and term in years to see the payment and interest estimate; the example uses a $20,000 loan at 8% APR for five years.

Formula

For a fixed-rate loan with equal monthly payments, the payment is calculated using the standard amortizing-loan formula:

Payment = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the amount borrowed, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 1,200. The APR is entered as a percentage per year.
• n is the number of monthly payments: loan term in years × 12.
• Payment is the monthly principal-and-interest amount, rounded to the nearest cent.

Total interest is estimated as the rounded monthly payment multiplied by the number of payments, minus the original loan amount: Interest = Payment × n − P. Because this uses the payment rounded to cents, the estimate follows the displayed payment. Actual loan servicing may use different rounding or payment conventions.

Worked Example

Using the calculator’s default values: a $20,000 principal, 8% APR, and a five-year term.

1. Convert the APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
2. Find the number of payments: 5 × 12 = 60.
3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)⁻⁶⁰].
4. The unrounded result is about $405.53 per month; rounded to cents, the monthly payment is $405.53.
5. Estimate total interest using the displayed payment: $405.53 × 60 − $20,000 = $4,331.80.

Assumptions

• The interest rate remains fixed throughout the term.
• Payments are equal, made monthly, and are assumed to arrive at the end of each monthly period.
• Interest is compounded monthly using APR divided by 12.
• The calculation excludes fees, taxes, insurance, PMI, escrow, and any charges not entered as loan principal.

What an Amortization Tool Shows

Amortization is the gradual repayment of debt through scheduled payments. Each payment is divided between interest and principal. In the early part of a typical fully amortizing loan, the outstanding balance is larger, so more of the payment goes toward interest. As principal is repaid, the balance falls and the interest portion generally declines, leaving more of each fixed payment to reduce principal.

This calculator summarizes the payment and total interest, not a complete month-by-month schedule. A full amortization table would show, for every payment, the starting balance, interest charged, principal repaid, and remaining balance. Those details can help explain how much principal remains at a particular point, but the exact schedule depends on the contract’s dates, rounding, and payment rules.

When to Use It and How to Read the Result

Use the estimate to understand the arithmetic of a fully amortizing fixed-rate loan or to see how the entered principal, APR, or term affects a scheduled payment. It can also help distinguish the monthly payment from the total amount paid across the full term. The result is not a quote or a decision about whether a loan is appropriate.

• Monthly payment is the estimated recurring principal-and-interest amount, not necessarily the whole amount due on a bill.
• Total interest is the estimated interest across all scheduled payments, assuming the loan runs for the full stated term.
• Principal is the borrowed amount entered. If financed charges are included in a lender’s principal, they may increase the actual payment.

For a practical estimate, use the loan amount and APR supplied in the lender’s current disclosure, and check whether the quoted payment includes anything beyond principal and interest. A mortgage payment, for example, may be presented alongside taxes, insurance, or escrow amounts that this calculation does not model.

Common Mistakes and Limits

APR is entered as a percentage per year, so 8 means 8%, not 0.08. The formula converts it to a monthly rate by dividing by 1,200. The term is entered in years and converted to months; entering a number of months as though it were years would produce a very different result. Check both units before relying on an estimate.

Another common misunderstanding is that total interest is the same as total payments. Total payments equal the monthly payment multiplied by the number of payments; total interest subtracts the original principal from that amount. Neither figure includes excluded charges. Also, a displayed payment rounded to cents can produce a small difference from a lender’s final payment schedule, especially if the last payment is adjusted.

The formula assumes one fixed rate, regular monthly periods, equal payments, and a loan fully repaid by the scheduled final payment. It does not model variable rates, irregular payment dates, skipped payments, late charges, additional principal payments, balloon payments, refinancing, or a changing balance caused by fees. For an adjustable-rate loan or a contract with unusual payment terms, this simplified estimate may not match the actual schedule.

Frequently Asked Questions

What does a loan amortization tool calculate?
It estimates the regular payment needed to repay a loan over a specified term at a fixed rate, along with estimated total interest under the calculator’s assumptions.

Does the monthly payment include taxes and insurance?
No. This calculation covers principal and interest only. Taxes, insurance, PMI, escrow, and other charges are not included unless separately entered in a calculator designed to model them.

Why does the interest portion change each month?
Interest is calculated on the outstanding balance. As scheduled payments reduce principal, the balance generally falls, so later payments allocate less to interest and more to principal.

Does paying extra reduce the total interest?
Extra principal payments can change a loan’s balance and payoff timing, but this calculator assumes only the scheduled equal payments. The effect of extra payments depends on how the loan applies them and is not included here.

Is APR the same as the monthly interest rate?
No. APR is entered as an annual percentage. This formula uses APR divided by 12 to obtain a monthly rate, with the percentage converted to a decimal by dividing by 100 as well.

Why might a lender’s payment differ from this estimate?
The lender may use different rounding, dates, fees, payment timing, or loan terms. The calculation also excludes taxes, insurance, and other charges that may appear in a total bill.

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

Related

• Auto Loan Amortization: Payments, Interest, and Balance
• 5 Year Loan Amortization Calculator and Payment Formula
• Personal Loan Amortization Schedule in Excel

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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2