Loan Payment Calculator Amortization Schedule Explained

A loan payment calculator with an amortization schedule estimates the fixed monthly payment and shows how each payment is divided between interest and principal. Enter the loan amount, annual percentage rate (APR), and term to see the payment and total interest; the schedule itself can then be built month by month from those figures.

Formula

The calculator uses the standard fixed-payment loan formula. It calculates the monthly payment from the principal, monthly interest rate, and number of monthly payments:

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

• P is the amount borrowed, in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. For an 8% APR, r = 0.08 ÷ 12.
• n is the number of monthly payments, calculated as years × 12.

Total interest is estimated as monthly payment × n − P. The displayed payment is rounded to cents, and total interest uses that rounded payment. The schedule’s monthly balances are calculated iteratively: interest for the month is the opening balance multiplied by r; principal paid is the payment minus that interest; and the closing balance is the opening balance minus principal paid.

Worked Example

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

1. Payment = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
2. The resulting payment is about $405.53 per month when rounded to cents.
3. Total interest = $405.53 × 60 − $20,000 = $4,331.80.

For the first schedule row, interest is $20,000 × 0.0066667, or about $133.33. The payment therefore reduces principal by about $272.20, leaving a balance of about $19,727.80. Later interest charges generally decline as the balance falls. Because the payment is rounded, the final payment may need a small adjustment to clear the remaining balance exactly.

Assumptions

• The APR and payment amount remain fixed for the modeled term.
• Payments occur monthly, at the end of each monthly period.
• Interest accrues monthly using APR divided by 12.
• Fees, taxes, insurance, PMI, and escrow are not included; the loan amount is treated as the starting principal.

How to Read an Amortization Schedule

An amortization schedule is a dated or numbered table showing the starting balance, payment, interest, principal reduction, and ending balance for each period. Its rows explain where the payment goes, while the calculator’s headline payment is the same level amount assumed for every month.

• Beginning balance: the amount still owed before that month’s payment.
• Interest: beginning balance multiplied by the periodic rate.
• Principal: payment minus interest, assuming the payment covers the interest due.
• Ending balance: beginning balance minus principal paid.

At the beginning of a fully amortizing loan, the balance is larger, so the interest portion is usually larger too. As principal is repaid, the interest portion tends to shrink and more of each level payment goes to principal. This is why a payment amount alone does not show how quickly the debt balance declines.

When to Use the Calculator

Use the estimate to understand the basic payment structure of a fixed-rate, fully amortizing loan or to examine how the inputs affect the math. A schedule is useful for seeing the projected balance after a given number of payments and the cumulative interest over the modeled term. To check a real loan, enter the principal, APR, and term stated in the lender’s disclosure; do not substitute a promotional rate or an assumed fee.

APR and the note’s interest rate can differ when certain borrowing costs are reflected in APR. This calculator uses the entered APR directly as its monthly rate basis. If the lender calculates payment interest using a different rate, daily accrual, irregular payment dates, or another convention, its figures can differ from this estimate.

Common Misconceptions and Limits

A common misconception is that the entire monthly payment reduces the amount borrowed. It does not: the interest due is paid first in the basic schedule, and only the remainder reduces principal. Another is that a calculator’s result is necessarily the lender’s exact payment. Dates, rounding, fees, payment processing, and loan-specific terms can create differences.

• Enter the APR as a percentage, such as 8 for 8%, not 0.08. The formula divides the APR by 1,200.
• Enter the term in years. The formula converts years to months; a term already expressed in months should not be entered as years.
• Use the amount actually financed as principal, rather than an asset’s price if the financed balance differs.
• Do not assume extra payments are included. They change the balance path and may affect payoff timing; this calculator models level scheduled payments only.

The standard formula assumes a positive APR, regular monthly periods, a constant rate, and enough payment to amortize the balance over the stated term. It is not designed for interest-only periods, variable rates, balloon payments, deferred interest, skipped payments, or a changing payment schedule. The annualized APR divided by 12 is a simplifying monthly-rate convention; actual loan documents specify the applicable calculation and payment terms.

Frequently Asked Questions

What does an amortization schedule show?
It shows each scheduled payment’s interest and principal portions, along with the remaining balance after payment. A full schedule has one row for each payment period.

Why does the principal portion increase over time?
With a fixed rate and level payment, interest is calculated on the remaining balance. As the balance falls, the interest portion generally falls, leaving more of the payment to reduce principal.

Does the monthly payment include taxes and insurance?
No. This calculation covers principal and interest under its assumptions. Taxes, insurance, PMI, and escrow are excluded unless separately included in a lender’s quoted payment.

Why is the lender’s payment different from the calculator?
The loan may use a different principal, rate, term, payment date, day-count method, or rounding convention. Fees and other payment components can also affect the disclosed amount.

Can I use this for a variable-rate loan?
Only as a snapshot based on a single entered rate. It does not project future rate changes or recalculate payments when a variable rate changes.

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

Related

• Graduated Loan Payment Calculator and Payment Schedule
• GM Payment Calculator: Estimate Monthly Car Payments
• GMC Payment Calculator: Estimate Your Monthly Cost

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