calculate-loan

01 Loan payments

Amortization Schedule: Known Payment Amount

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

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

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.

Yes, an amortization schedule always shows a known payment amount—it is the fixed periodic payment calculated from the loan amount, interest rate, and term. When you enter those three inputs, the payment is determined by a standard formula, and the schedule then breaks that payment into interest and principal portions for each period until the loan is paid off.

Formula

The monthly payment for a fixed-rate amortizing loan is calculated with the standard formula:

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

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

This formula assumes a fixed interest rate, equal monthly payments, and that interest is compounded monthly at the periodic rate r. The payment is rounded to the nearest cent, and each subsequent line of the schedule uses that rounded payment.

Worked Example

Using the default values from the calculator: loan amount P = $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.489846
  4. Numerator: P × r × (1 + r)^n = 20000 × 0.0066667 × 1.489846 ≈ 198.646
  5. Denominator: (1.489846 – 1) = 0.489846
  6. Payment = 198.646 / 0.489846 ≈ 405.53

So the monthly payment is $405.53. Over 60 months, total paid = 405.53 × 60 = $24,331.80. Total interest = $24,331.80 – $20,000 = $4,331.80, matching the calculator output.

Assumptions

  • Fixed interest rate for the entire loan term (no rate changes).
  • Payments are made at the end of each month (ordinary annuity).
  • Interest compounds monthly at APR/12.
  • The payment is rounded to the cent, and the final payment may be slightly adjusted to bring the balance to zero exactly.
  • This estimate does not include fees, taxes, insurance, PMI, or escrow; the lender’s disclosure provides the exact figures.

How the Schedule Works

Each row of an amortization schedule shows the payment number, the payment amount, the interest portion, the principal portion, and the remaining balance. For each period, the interest is calculated as the current balance multiplied by the monthly rate. The principal portion is the payment minus that interest. The balance is then reduced by the principal portion. Because the balance declines, the interest portion decreases over time while the principal portion increases, even though the total payment stays constant.

For example, in the first month of the $20,000 loan at 8% APR, interest = 20000 × 0.0066667 = $133.33. Principal = 405.53 – 133.33 = $272.20. New balance = 20000 – 272.20 = $19,727.80. In the last month, the interest is only a few dollars, and the principal portion is nearly the full payment.

Why the Payment Is Known

The payment is known because it is derived from a closed-form equation. Unlike variable-rate loans or interest-only periods, a fixed-rate amortizing loan has a payment that is set at origination and does not change (unless extra payments are made or the loan is refinanced). This predictability is a key feature of standard mortgages, auto loans, and personal loans. The schedule simply lists every payment in advance, so you know exactly how much you will pay each month and how much of each payment goes to interest versus principal.

How to Use the Calculator

Enter the loan amount, the annual interest rate (APR), and the loan term in years. The calculator instantly returns the monthly payment and the total interest. You can adjust any input to see how the payment changes. For example, increasing the term from 5 to 10 years lowers the monthly payment but increases total interest. Increasing the rate raises both the payment and total interest. This tool is useful for comparing loan offers or planning a budget, but the actual figures come from the lender’s disclosure.

Common Mistakes and Misconceptions

  • Using the annual rate instead of the monthly rate: Always divide APR by 12 before plugging into the formula.
  • Forgetting to round the payment: The schedule uses the rounded payment, so totals may differ by a few cents if you use the unrounded value.
  • Assuming the payment includes taxes and insurance: The formula covers only principal and interest; escrow items are separate.
  • Thinking the interest is simple: Amortized loans use compound interest on the declining balance, which is why the interest portion decreases each month.
  • Ignoring extra payments: If you pay extra, the schedule changes; the calculator does not model that unless you add an extra payment input.

Limitations of the Formula

The standard formula works only for fixed-rate, fully amortizing loans with equal payments. It does not apply to adjustable-rate mortgages, interest-only loans, balloon payments, or loans with fees rolled into the APR. For those, the payment may change or the final payment may be much larger. Also, the formula assumes payments are made exactly on time; late fees or grace periods can alter the actual amortization. Finally, the result is an estimate—the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What if I make extra payments?

Extra payments reduce the principal faster, which shortens the loan term and lowers total interest. The monthly payment stays the same unless you recast the loan, but the schedule is recalculated. You can use an extra-payment calculator to see the effect.

Why does the interest portion decrease over time?

Because interest is calculated on the remaining balance. As you pay down principal, the balance shrinks, so the interest charged each month is smaller. The payment stays the same, so more of it goes to principal each month.

Is the payment the same every month?

Yes, for a fixed-rate loan the payment is constant. However, the final payment may be slightly different (usually a few cents) to bring the balance to exactly zero. Some lenders adjust the last payment accordingly.

Can I calculate the payment if I only know the total interest?

No, you need the loan amount, rate, and term. The total interest is an output, not an input. You could solve for the rate or term iteratively, but the standard formula requires those three inputs.

Does the formula work for biweekly payments?

No, this formula assumes monthly payments. For biweekly, you would need a different formula or adjust the rate and number of periods. Biweekly payments effectively make 26 half-payments per year, which is equivalent to 13 full monthly payments, reducing the term.

The result from this calculator is an estimate; 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 →