calculate-loan

01 Loan payments

Payment Schedule Calculator: Build a Loan Timeline

Calculator No. 01-14571 · 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 shows when loan payments are due and how each payment is divided between principal and interest. Enter a loan amount, annual percentage rate (APR), and term to estimate the monthly payment, total interest, and total paid over the schedule.

Formula

This calculator uses the standard fixed-payment loan formula. It estimates the monthly payment from the principal, monthly interest rate, and number of monthly payments:

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

  • P is the amount borrowed, 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 total number of monthly payments: loan term in years × 12.

Total interest is calculated as the monthly payment multiplied by the number of payments, minus the original principal: Total interest = payment × n − P. The payment is rounded to cents before this total is calculated, so the result reflects a schedule of equal, cent-rounded payments. A real lender may adjust the final payment to account for rounding or its precise payment dates.

Worked Example

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

  1. Convert the annual rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066667.
  2. Find the payment count: n = 5 × 12 = 60 months.
  3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60].
  4. The monthly payment is approximately $405.53, rounded to cents.
  5. Total interest is $405.53 × 60 − $20,000 = $4,331.80.

Assumptions

  • The interest rate stays fixed throughout the term.
  • Payments are equal, monthly, and made at the end of each period.
  • Interest is modelled monthly using APR ÷ 12.
  • Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.

What a Payment Schedule Shows

A full amortization schedule lists each payment period and tracks how the loan balance changes. A typical row may show the payment number or due date, starting balance, payment amount, interest charged, principal repaid, and remaining balance. The payment can stay level while its components change: early in a standard amortizing loan, more of the payment generally goes to interest; later, more goes to principal.

For example, the first month’s interest in this estimate is $20,000 × 0.08 ÷ 12, or about $133.33. From a $405.53 payment, about $272.20 therefore reduces principal, leaving an estimated balance of $19,727.80. In the next month, interest is calculated on that lower balance, so the interest portion falls slightly and the principal portion rises. Actual statements may differ because of payment dates, daily interest calculations, rounding, or loan-specific terms.

How to Construct and Check a Schedule

  1. Gather the loan figures. Use the amount actually financed, the APR or applicable rate, the payment frequency, and the repayment term. Get exact figures from the lender’s disclosure; do not substitute an advertised rate for the rate on the loan.
  2. Convert units consistently. This calculator assumes monthly payments and an APR expressed as a percentage per year. It converts the APR to a monthly decimal and years to months. A term of five years means 60 payments, not five.
  3. Calculate the level payment. Apply the formula above, then round the periodic payment to cents. Confirm whether the lender’s schedule uses a level payment or another arrangement.
  4. Calculate each row. For a monthly schedule, find the period’s interest from the starting balance and monthly rate. Subtract that interest from the payment to find principal repaid; subtract the principal portion from the starting balance to find the new balance. Repeat using the new balance.
  5. Reconcile the totals. Across a conventional fully amortizing schedule, principal repaid should add up to the original amount borrowed, subject to rounding. Total payments minus principal equals total interest when there are no added charges or extra payments.

The calculator provides the payment and overall interest estimate, not a month-by-month table. To create individual rows, the recurrence is: interest for a period = starting balance × periodic rate; principal repaid = payment − interest; ending balance = starting balance − principal repaid. A spreadsheet can repeat those calculations for each payment date.

Choosing Inputs and Understanding Limits

Use the financed principal rather than the amount you intend to spend if the loan includes amounts rolled into the balance. Enter the loan’s stated APR as a percentage—for example, 8, not 0.08—and check that the term matches the payment frequency. This formula is for a fixed-rate, level-payment loan that is fully repaid by the end of the stated term.

It does not model variable rates, interest-only periods, balloon payments, skipped payments, payment holidays, irregular payment dates, or extra principal payments. It also does not calculate an APR from fees or show the effect of fees separately. Such terms can change the schedule and the amount paid. Ask the lender for an itemized repayment schedule when the contract’s calculation method differs from these assumptions.

Common Mistakes

  • Mixing up APR and monthly rate: Enter the annual percentage in the APR field; the calculator performs the conversion.
  • Using the wrong term unit: Enter years, not months, in the term field. The formula multiplies years by 12.
  • Treating estimated totals as exact contract figures: Rounding each payment to cents, payment timing, and lender methods can affect the final balance or last payment.
  • Assuming the payment includes every borrowing cost: The estimate excludes fees and other charges unless they are included in the principal entered.

A payment schedule is a projection, not a promise that every statement will match it. The result is an estimate, and the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What is a payment schedule?
A payment schedule sets out when payments are due and, in an amortization schedule, how much of each payment goes to principal and interest and what balance remains.

How do I calculate a monthly loan payment?
Convert APR to a monthly decimal by dividing by 1,200, convert the term to months, then use the fixed-payment formula shown above. The calculator performs those steps and rounds the payment to cents.

Why does the interest portion change over time?
For a fixed-rate amortizing loan, interest is calculated on the outstanding balance. As principal is repaid, the balance falls, so less interest accrues per period and more of a level payment reduces principal.

Does this schedule include fees or insurance?
No. It estimates principal-and-interest payments from the inputs and excludes fees, taxes, insurance, PMI, and escrow. Check the lender’s disclosure for charges that apply to a specific loan.

Why might my lender’s payment differ?
The lender may use different payment dates, daily interest accrual, fees included in the financed amount, or a different rounding method. Compare the calculator’s assumptions with the loan disclosure and payment schedule.

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 →