calculate-loan

01 Loan payments

Payment Schedule Calculator: Monthly Payments and Balance

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

Monthly payment $405.53
Total interest
$4,331.80
= Monthly payment × loan term × 12 − loan amount
Total paid
$24,331.80
= Monthly payment × loan term × 12
Loan amount
$20,000
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($), Total paid ($)
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.

This payment schedule calculator estimates the monthly payment, total interest, and total paid on a fixed-rate, fully amortizing loan. Enter the loan amount, annual interest rate (APR), and term in years; the results use monthly payments and show the payment amount rounded to cents.

Formula

The calculator uses the standard fixed-payment amortization formula:

PMT = P × r ÷ [1 − (1 + r)−n]

  • PMT is the monthly payment in dollars, rounded to the nearest cent.
  • P is the starting loan principal in dollars.
  • r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
  • n is the number of monthly payments, calculated as years × 12.

Total paid is the rounded monthly payment multiplied by the number of payments: Total = PMT × n. Estimated total interest is total paid minus the original principal: Interest = Total − P. Because the monthly payment is rounded to cents, the total is calculated using that rounded payment; actual lender schedules may adjust the final payment slightly to clear the remaining balance.

Worked Example

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

  1. Convert APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
  2. Calculate the number of payments: 5 × 12 = 60.
  3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
  4. The unrounded result is about $405.53; rounded to cents, the monthly payment is $405.53.
  5. Total paid using the displayed payment is $405.53 × 60 = $24,331.80.
  6. Estimated interest is $24,331.80 − $20,000 = $4,331.80.

Assumptions

  • The interest rate remains fixed for the full term.
  • Payments are equal, made monthly, and treated as paid at the end of each period.
  • Interest compounds monthly at APR divided by 12.
  • Fees, taxes, insurance, mortgage insurance, escrow, and any extra or missed payments are not included.

What a Payment Schedule Shows

A payment schedule, often called an amortization schedule, lays out how each scheduled payment is divided between interest and principal. Early in a typical fixed-rate loan, the outstanding balance is larger, so more of the payment goes toward interest. As principal is paid down, the interest portion generally shrinks and more of each equal payment reduces principal.

The calculator gives summary figures rather than a month-by-month table. For a detailed schedule, a borrower can repeat the balance calculation for each payment. If the monthly payment is PMT, the balance after k payments is:

Balance after k payments = P(1 + r)k − PMT × [(1 + r)k − 1] ÷ r

Here, k is the number of completed monthly payments. For example, the balance after 12 payments is found by setting k to 12. This formula assumes payments occur as scheduled and does not account for fees, irregular dates, or lender-specific rounding adjustments.

How to Use and Read the Results

Enter the amount borrowed rather than the total purchase price if a down payment or other funds reduce the amount financed. Enter the APR as a percentage: for example, type 8 for 8%, not 0.08. The term is in years, and the calculator converts it into monthly periods.

  • Monthly payment: the estimated regular principal-and-interest payment under the stated assumptions.
  • Total interest: the estimated interest across all scheduled payments, using the rounded monthly payment.
  • Total paid: the sum of those scheduled payments, not necessarily the full cost of owning an asset or using a credit product.

For a useful comparison of scenarios, change one input at a time. A longer term generally spreads repayment over more months; that can reduce the calculated monthly payment while increasing the number of periods over which interest is charged. The effect depends on the entered principal and APR. This arithmetic does not establish whether a payment fits a person’s budget or whether a lender will approve an application.

Limits and Common Sources of Difference

This is a mathematical estimate for a conventional fixed-rate loan with level monthly payments. It may not match a lender’s schedule if the rate can change, payments are weekly or biweekly, interest accrues using daily balances, the first period is an unusual length, or the contract uses a different payment convention. A variable-rate loan needs a schedule that accounts for rate changes over time.

Also distinguish the interest rate used in the calculation from the full amount due on a statement. APR may reflect certain borrowing costs, but this calculator uses APR only as the periodic rate in the payment formula. It does not separately add fees or other charges, and it does not model taxes, insurance, or escrow. Check the lender’s quoted payment and written schedule for the amounts and timing that apply to a specific loan.

Rounding is another common difference. The displayed payment is rounded to cents before total paid and total interest are calculated. A lender may carry extra precision internally or adjust the last payment, so a calculated lifetime total can differ by a small amount. Extra payments can also change the payoff date and interest; those are not included here.

Frequently Asked Questions

What does payment schedule mean?
A payment schedule is a plan showing when payments are due and, for an amortizing loan, how much of each payment goes to interest and principal. This calculator reports summary totals for a regular monthly schedule.

Does the monthly payment include taxes and insurance?
No. The result estimates the loan’s scheduled principal-and-interest payment. Taxes, insurance, mortgage insurance, escrow, and fees are not inputs and are not included.

Why does more of an early payment go to interest?
Interest for a period is calculated on the balance at that time. The balance is usually highest near the start of a fully amortizing loan, so the interest share is larger then. As the balance falls, the interest amount generally falls too.

Can I use this for a variable-rate loan?
Not as a complete schedule. The formula assumes one fixed APR throughout the term. A changing rate requires recalculating payments or balances for each period using the applicable rate and contract terms.

Why might my lender’s payment differ?
The lender may use different timing, rounding, compounding, fees, or payment assumptions. Compare the same principal, rate, term, and included charges, then rely on the lender’s disclosure for the contractual figures.

This result is an estimate, and 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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2
out tot | Total paid | $ | pmt * yrs * 12 | 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 →