Payment Amortization Schedule Calculator

A payment amortization schedule shows how each loan payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual percentage rate (APR), and term to estimate the monthly payment and total interest.

Formula

For a fixed-rate loan with equal monthly payments, the monthly payment is calculated from the principal, monthly interest rate, and number of payments:

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

• P is the starting loan 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: loan term in years × 12.

The calculator rounds the scheduled monthly payment to the nearest cent, then estimates total interest as (rounded payment × number of payments) − principal. A real lender’s final payment can differ slightly because payment amounts, dates, and interest calculations may be adjusted.

Worked Example

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

1. Convert APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
2. Find the number of monthly payments: 5 × 12 = 60.
3. Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = about $405.53 per month after cent rounding.
4. Calculate estimated total interest using the rounded payment: ($405.53 × 60) − $20,000 = $4,331.80.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are equal, made monthly, and paid at the end of each monthly period.
• Interest compounds monthly using APR ÷ 12.
• The estimate excludes fees, taxes, insurance, private mortgage insurance, and escrow unless included in the loan principal or payment by a separate calculation.

How an Amortization Schedule Works

An amortization schedule is a period-by-period record of a loan’s payments. Each row typically lists the payment number or date, opening balance, payment, interest charged, principal repaid, and closing balance. The balance at the end of one period becomes the starting balance for the next.

For a standard fixed-rate loan, interest for a month is generally calculated on the outstanding balance. At the beginning, the balance is larger, so a greater share of the level payment goes toward interest. As principal is repaid, the interest portion declines and the principal portion grows. This gradual shift is called amortization; it does not mean the payment itself necessarily changes.

For example, using the default figures, the first month’s interest under the monthly-rate assumption is about $133.33 ($20,000 × 0.08 ÷ 12). Of the $405.53 payment, roughly $272.20 reduces principal, leaving an estimated balance of $19,727.80. Small differences in a lender’s schedule may result from its exact daily or monthly interest method and rounding.

Reading the Results and Schedule

The monthly payment is the estimated level installment required to repay principal and interest over the entered term under the formula’s assumptions. It is not necessarily the full amount due on a mortgage or another loan: an actual bill may also include separately assessed charges. Total interest is an estimate across all scheduled payments, not the total amount paid, which would include principal as well.

For a detailed schedule, calculate each period in sequence. With a monthly rate r and opening balance B, monthly interest is B × r; principal paid is the scheduled payment minus that interest; and the new balance is B minus principal paid. Repeat for each payment. The last installment may need a small adjustment to bring the balance to zero after rounding.

A schedule can help explain the timing of repayment, compare the interest and principal portions over time, and check how a payment amount relates to the term. It is an estimate, not a substitute for the loan agreement or the lender’s official payment schedule.

Common Questions About the Calculation

Does the monthly payment include taxes and insurance? No. This calculation covers scheduled principal and interest only. Taxes, insurance, escrow, mortgage insurance, and other charges are not included unless separately added to the amount being analyzed.

Why does more of an early payment go to interest? Interest is calculated on the outstanding balance. Since the balance is usually highest at the start, the interest portion is then larger. As the balance falls, less interest accrues and more of a level payment reduces principal.

Why might my lender’s payment differ? The actual contract may use different rounding, payment dates, day-count conventions, fees, or a rate that changes over time. A first or final payment can also be different from the regular installment. Use the lender’s disclosure and schedule for the contracted figures.

Does paying extra change this calculator’s results? Extra payments are not included. If an extra amount is applied to principal, it can change the balance and may reduce interest or the time needed to repay, depending on the loan terms and how the payment is processed. This calculator assumes only the fixed scheduled installment.

Limits and Related Details

This formula applies to a fully amortizing loan with a positive fixed APR, equal monthly payments, and a term expressed in years. It does not model a variable rate, interest-only period, balloon payment, skipped payment, deferred interest, or irregular payment calendar. For a variable-rate loan, a schedule based on today’s rate cannot reliably represent later payments because the rate may change.

APR is entered as a yearly percentage, not as a monthly percentage. Entering 8 for 8% is correct; entering 0.08 would mean 0.08% APR. The calculator converts the annual percentage to a monthly rate by dividing by 1,200. Keep the loan term in years as requested; the formula converts it to months.

Payments rounded to cents can create a small difference between an ideal mathematical schedule and the lender’s actual payoff amount. A payoff quote can also account for interest accrued since the last payment and contract-specific charges. Obtain the real APR, payment timing, fees, and payoff figure from the lender rather than treating this estimate as a statement balance.

Frequently Asked Questions

What is a payment amortization schedule?
A table showing each scheduled payment’s interest and principal portions and the remaining loan balance over time.

How do I calculate a monthly loan payment?
Use the fixed-payment formula with the principal, monthly rate (APR divided by 1,200), and total number of monthly payments. This calculator applies that method and rounds the payment to cents.

Is total interest the same as total payments?
No. Total payments include repayment of the borrowed principal plus interest. In this calculator, estimated total interest equals the sum of rounded scheduled payments minus the original principal.

Can I use this for a variable-rate loan?
Only as a snapshot using the APR entered as though it remained fixed. The calculation does not forecast rate changes or their effects on later payments.

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

Related

• Amortization Calculator Using Monthly Payment
• Amortization Calculator: Principal Payment Explained
• Amortization Calculator With Extra Payments

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