calculate-loan

01 Loan payments

Payment Schedule Example: Loan Payments by Month

Calculator No. 01-14583 · 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.

A payment schedule example shows how each loan payment is divided between principal and interest, and how the balance changes over time. Use this calculator to enter a loan amount, APR, and term; it estimates the monthly payment and total interest for a fixed-rate loan with monthly payments.

Formula

The calculator uses the standard fixed-payment amortization formula. It finds a payment that, assuming the same monthly interest rate throughout the term, pays down the balance to zero after the final scheduled payment.

Monthly payment: M = P × r / [1 − (1 + r)−n].
Total interest: I = (M × n) − P.

  • P is the starting loan principal, in dollars.
  • APR is the annual percentage rate entered as a percent, such as 8 for 8%.
  • r is the monthly rate expressed as a decimal: APR ÷ 1,200.
  • n is the number of monthly payments: loan term in years × 12.
  • M is the calculated monthly payment, in dollars.
  • I is the estimated total interest paid over the full schedule, in dollars.

The formula assumes a level payment and a constant rate. The displayed payment is rounded to cents; actual lender calculations may use more detailed timing, rounding, and contract terms.

Worked Example

For the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term—first convert the annual rate and term:

  1. Monthly rate: r = 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
  2. Number of payments: n = 5 × 12 = 60.
  3. Substitute into the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
  4. Monthly payment, rounded to cents: $405.53.
  5. Total interest using the displayed payment: $405.53 × 60 − $20,000 = $4,331.80.

The final installment may differ slightly from the regular payment if a lender adjusts for rounding or the exact dates of payments. This example illustrates the formula; it is not a lender payoff quote.

Assumptions

  • The interest rate remains fixed for the entire term.
  • Payments are made monthly, with the first payment one month after the loan begins.
  • Interest is modelled monthly at APR ÷ 12; the APR is treated as a nominal annual rate for this calculation.
  • The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, and any optional products.

How to Read a Payment Schedule

A full amortization schedule lists each payment period, the payment amount, the interest portion, the principal portion, and the remaining balance. The monthly payment can stay level even though its components change. Early in a typical amortizing loan, the balance is larger, so the interest portion tends to be larger. As principal is repaid, the interest charged on the remaining balance falls, and more of each payment goes toward principal.

For the example, monthly interest in the first period is approximately $20,000 × 0.0066667, or $133.33. Subtracting that from the $405.53 payment leaves about $272.20 to reduce principal. The next month’s interest is calculated on the lower balance, so the split changes. The payment is not simply the original principal divided by 60, because interest accrues while the balance remains unpaid.

The calculator provides the scheduled payment and aggregate interest, not a month-by-month table. To build a schedule manually, repeat these steps each month: calculate interest on the current balance, subtract that interest from the payment to find principal repaid, then subtract principal repaid from the balance. Currency rounding and the last payment can create small differences.

When This Example Is Useful—and Its Limits

A payment schedule example can help explain the connection between amount borrowed, rate, and term. It can also provide a neutral arithmetic estimate for comparing possible input scenarios, such as changing the term while keeping the principal and APR the same. Use the rate and any loan-specific figures supplied by the lender rather than treating the example defaults as market information.

This formula is for a conventional fixed-rate loan repaid through equal monthly payments. It does not calculate a variable-rate schedule, interest-only period, balloon payment, deferred interest, or a payment plan with irregular dates. If the rate changes, payments are skipped, or extra principal is paid, the actual balance path will differ. An APR may also reflect costs in ways that are not captured by simply dividing it by 12, depending on the product and how its disclosures define the figures.

Common mistakes include entering 8 when a form expects 0.08, or entering a monthly rate where an annual APR is requested. Here, enter APR as a percentage number: use 8 for 8%. Also distinguish the loan term from the number of payments: a five-year term means 60 monthly payments under this example’s assumptions, not five payments. Do not interpret total interest as the total amount repaid; the latter is principal plus interest, before excluded costs.

Payment Schedule vs. Payment Amount

A payment amount is one figure: the scheduled amount due each month under the model. A payment schedule is the timeline showing how each payment is allocated and what balance remains afterward. The calculator’s monthly payment is therefore a useful starting point, but it is not a complete schedule or a statement of the amount due on a particular date.

For a more exact schedule, consult the loan agreement or request an amortization schedule from the lender. Check whether it includes fees, payment dates, rate adjustments, and any extra payments. A payoff figure can differ from the balance shown in a basic schedule because interest may accrue between the last scheduled payment and the payoff date.

Frequently Asked Questions

What is a payment schedule example?
It is a sample timeline showing each scheduled payment, how much goes to interest and principal, and the remaining loan balance. The example here uses a fixed rate and equal monthly payments.

How do I calculate a monthly loan payment?
Convert APR to a monthly decimal rate by dividing the percentage by 1,200, convert the term to months, and apply the fixed-payment formula shown above. A calculator can reduce arithmetic errors, but the result remains subject to the model’s assumptions.

Does a payment schedule show total interest?
A complete schedule can show interest for each payment; adding those amounts gives scheduled interest over the term. This calculator estimates the total by multiplying the rounded monthly payment by the number of payments and subtracting principal.

Why does more of a payment go to interest at the start?
Interest for a period is calculated on the outstanding balance. That balance is generally highest at the beginning, so the interest share tends to be larger then. As the balance declines, the interest share typically declines too.

Are fees and extra payments included?
No. Fees and other charges are excluded, and the calculator assumes only the regular scheduled payments. Extra principal payments or a changed rate alter the schedule and require a calculation that accounts for those events.

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 | $ | 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 →