calculate-loan

01 Loan payments

Amortization Schedule with Specific Payment

Calculator No. 01-20804 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

An amortization schedule with a specific payment shows the exact breakdown of each monthly payment into interest and principal over the life of a loan, based on a fixed payment amount you choose. This calculator takes your loan amount, interest rate, and term, and returns the monthly payment, total interest, and a full schedule of balances—so you can see precisely how each payment reduces what you owe.

Formula

The monthly payment for a fixed-rate loan is calculated using the standard amortization formula:

M = P × [r(1 + r)^n] / [(1 + r)^n – 1]

Where:

  • M = monthly payment (in dollars)
  • P = principal loan amount (in dollars)
  • r = monthly interest rate (annual rate divided by 12, expressed as a decimal; e.g., 8% APR → 0.08/12 = 0.0066667)
  • n = total number of monthly payments (loan term in years × 12)

Each month’s interest is calculated as the current balance multiplied by the monthly rate. The principal portion is the payment minus that interest. The balance then decreases by the principal portion, and the process repeats for the next month.

Worked Example

Using the default values from the calculator above: loan amount $20,000, APR 8%, term 5 years.

  1. Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
  2. Total payments: n = 5 × 12 = 60
  3. Compute (1 + r)^n = (1.0066667)^60 ≈ 1.4898457
  4. Payment = 20000 × [0.0066667 × 1.4898457] / [1.4898457 – 1] = 20000 × (0.0099323) / (0.4898457) ≈ 20000 × 0.020276 = 405.52
  5. Total paid over 60 months: 405.52 × 60 = $24,331.20
  6. Total interest = 24,331.20 – 20,000 = $4,331.20

The calculator rounds the payment to $405.52, and the total interest shows $4,331.20, matching the example.

Assumptions

  • Fixed interest rate for the entire term (no rate changes).
  • Payments are made at the end of each month.
  • Interest compounds monthly at the annual rate divided by 12.
  • The payment is rounded to the nearest cent, and the final payment may differ slightly to account for rounding.
  • This calculation does not include fees, taxes, insurance, PMI, or escrow amounts—those would be added separately.

How to Read the Schedule

An amortization schedule lists each payment number, the payment amount, the interest portion, the principal portion, and the remaining balance. In the early months, interest consumes most of the payment. For example, on a $20,000 loan at 8% for 5 years, the first payment of $405.52 includes about $133.33 in interest and $272.19 in principal, leaving a balance of $19,727.81. As the balance decreases, the interest portion shrinks and the principal portion grows. By the final payment, almost all of it goes to principal.

If you choose a specific payment amount that differs from the calculated minimum, the schedule changes. A higher payment reduces the number of months and the total interest. A lower payment (but still above the monthly interest) extends the term. If the payment is below the monthly interest, the balance grows—this is called negative amortization.

Choosing a Payment Amount

When you have a specific payment in mind, you can compare it to the minimum required payment. The minimum is what the formula gives for the full term. If your specific payment is higher, you’ll pay off the loan early. To estimate the new payoff time, use the formula: n = –ln(1 – rP / M) / ln(1 + r), where M is your payment. For example, if you pay $500 instead of $405.52 on the same $20,000 loan at 8%, the term becomes about 47 months instead of 60, and total interest drops to roughly $3,500.

If your specific payment is lower than the minimum, the loan will not be paid off by the original term. You would need to extend the term or make a balloon payment at the end. Always check with your lender to see if extra payments are applied to principal directly and if any prepayment penalties apply.

Common Mistakes and Misconceptions

  • Using the annual rate instead of the monthly rate – Always divide the APR by 12 before using it in the formula.
  • Forgetting to round the payment – The schedule uses the rounded payment, so totals may differ by a few cents from an unrounded calculation.
  • Assuming the interest is simple – Amortized loans compound monthly, so the interest calculation is based on the remaining balance each month.
  • Thinking the payment is fixed forever – This formula assumes a fixed rate. Adjustable-rate loans will have changing payments.
  • Ignoring extra fees – Origination fees, closing costs, and insurance are not part of the amortization formula.

Limitations of the Formula

The standard amortization formula works only for fixed-rate, fully amortizing loans with level payments. It does not apply to interest-only loans, balloon loans, or loans with variable rates. For those, you need a different calculation. Also, the formula assumes payments are made on time every month; late fees or missed payments will alter the schedule. The result is an estimate for educational purposes—your lender’s disclosure will show the exact figures, including any fees or adjustments.

Frequently Asked Questions

How do I find the amortization schedule for a specific payment amount?

Enter your loan amount, interest rate, and term into the calculator above to get the minimum payment and full schedule. If you want to see the effect of a different payment, you can adjust the term or use a separate extra-payment calculator. The schedule will show how many months it takes to pay off with that payment.

What happens if I pay more than the scheduled payment?

Extra payments go directly to principal (assuming your lender applies them that way), which reduces the balance faster. This shortens the loan term and lowers total interest. For example, paying an extra $50 per month on a $20,000 loan at 8% for 5 years would cut the term by about 5 months and save roughly $400 in interest.

Can I pay less than the minimum payment?

Yes, but only if your lender agrees to a modified payment plan. If you pay less than the interest accruing each month, the unpaid interest is added to the principal, increasing your balance. This is called negative amortization and can lead to owing more than you borrowed.

Why does the interest portion change every month?

Interest is calculated on the current remaining balance. As you pay down principal, the balance decreases, so the interest charged each month also decreases. The payment stays the same, so the extra amount goes toward principal, accelerating the payoff.

Does the schedule include taxes and insurance?

No. The amortization schedule only covers principal and interest. If you have an escrow account for property taxes and insurance, those are added to your monthly payment but are not part of the amortization calculation. Your lender will provide a separate breakdown.

What if my loan has a variable rate?

This calculator assumes a fixed rate. For an adjustable-rate mortgage or loan, the payment changes when the rate adjusts. You would need to recalculate the schedule after each rate change, using the new rate and the remaining balance and term.

This result is an estimate for educational purposes; 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

The whole Loan payments section →