Amortization Schedule Monthly Payments Explained

This calculator estimates the fixed monthly payment on a fully amortizing loan and the total interest paid over the stated term. Enter the loan amount, annual percentage rate (APR), and term in years; the results show the monthly payment and total interest, while the schedule itself can be understood by tracking each payment’s principal and interest portions.

Formula

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

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

• M is the monthly payment in dollars.
• P is the starting loan principal in dollars.
• r is the monthly interest rate as a decimal, calculated as annual APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200.
• n is the number of monthly payments, calculated as years × 12.

The calculator rounds the payment to cents. Total interest is calculated as the rounded monthly payment multiplied by the number of payments, minus the original principal: I = M × n − P. This convention means the displayed total uses the same payment shown to the reader.

Worked Example

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

1. Convert the annual APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667 (approximately).
2. Find the number of monthly payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
4. The monthly payment, rounded to cents, is $405.53.
5. Total of the rounded payments is $405.53 × 60 = $24,331.80. Subtract the $20,000 principal: total interest is $4,331.80.

How a Monthly Amortization Schedule Works

An amortization schedule is a table showing how a loan balance changes over time. Each row typically lists the payment number or date, opening balance, payment amount, interest charged, principal repaid, and closing balance. The monthly payment is usually level for the fixed-rate, fully amortizing loan model used here, but its components change.

Interest for a period is calculated on the outstanding balance. Early in repayment, the balance is relatively large, so more of a level payment goes toward interest. As principal is reduced, the interest portion usually falls and the principal portion rises. The balance reaches zero after the final scheduled payment, subject to payment timing, rounding, and the lender’s actual calculations.

For a simplified monthly calculation, interest for a period is the opening balance multiplied by the monthly rate. Principal repaid is the payment minus that interest, and the next balance is the opening balance minus principal repaid. For example, on a $20,000 balance at 8% APR, one month’s interest under this model is about $133.33. With a $405.53 payment, about $272.20 goes to principal in that first period. Actual statements can differ by cents because of daily interest, dates, or rounding conventions.

How to Read and Use the Results

Use the calculator to estimate the scheduled payment and the interest implied by the entered amount, APR, and term. The APR and term must match the loan figures you want to examine. A longer term generally spreads repayment across more payments and, when other inputs are unchanged, increases total interest; the payment formula itself does not model changing rates or irregular payments.

To read a full schedule, look at the interest and principal columns separately, not just at the fixed payment. The ending balance should generally decline when each payment exceeds the period’s interest. A schedule can help explain the timing of principal repayment and estimate the balance after a given number of payments, but this calculator returns summary figures rather than a row-by-row table.

Common Mistakes and Formula Limits

• Confusing APR with the monthly rate: enter the annual percentage as a percent, such as 8 for 8%. The formula converts it to a monthly rate by dividing by 1,200; do not enter 0.08 in the APR field.
• Using the wrong term unit: this calculator takes years. A five-year term is entered as 5, not 60.
• Assuming every loan has a fixed payment: variable rates, interest-only periods, balloon amounts, skipped payments, and changing payment dates are not represented by this formula.
• Expecting the total to match every statement exactly: payment rounding, daily-interest methods, the first payment date, and a final adjustment can change the actual amounts.
• Counting the payment as the full housing or borrowing cost: fees and separate charges may apply even when the scheduled principal-and-interest payment is fixed.

The formula assumes a positive APR and a fully repaid balance through equal monthly payments. It does not determine a lender’s APR, approval decision, or actual contract terms. Use the figures supplied in the relevant loan disclosure for a contract-specific estimate.

Assumptions

• The interest rate is fixed for the entire loan term.
• Payments are equal, monthly, and made 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 other charges not entered as inputs.

Frequently Asked Questions

What does an amortization schedule show?
It breaks each scheduled payment into interest and principal and shows how the remaining balance changes over the loan term.

Why does more of my early payment go to interest?
Interest is calculated on the outstanding balance. Since that balance is largest near the start of repayment, the interest share is typically larger then; it shrinks as principal is paid down.

Does the monthly payment include taxes and insurance?
Not in this calculator. It estimates principal and interest only. Other amounts may be billed separately or included in a combined payment, depending on the loan arrangement.

Why might my lender’s payment differ by a few cents?
The lender may use different rounding, interest accrual, or payment-date conventions. The contract and payment disclosure govern the actual amounts.

Does paying extra change an amortization schedule?
Extra principal payments can reduce the balance faster and may change future interest or the payoff date, but the calculator does not model extra payments. The effect depends on how payments are applied and the loan terms.

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

Related

• Interest Rate Tracker: Estimate Payments and Interest
• Interest Rate Trends: How Rates Change Over Time
• Interest Rate Table Calculator and Loan Payment Formula

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