calculate-loan

01 Loan payments

Repayment Schedule Sample: Monthly Loan Breakdown

Calculator No. 01-19024 · 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 repayment schedule sample shows each loan payment split between principal and interest, along with the balance left afterward. Use the calculator below to enter a loan amount, APR, and term; it estimates the monthly payment and total interest, while the sample schedule explains how the balance changes over time.

Formula

For a fixed-rate loan with equal monthly payments, the payment before rounding is principal times the monthly rate, divided by one minus one plus the monthly rate raised to the negative number of payments:

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

  • P is the starting loan principal, 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 number of monthly payments: years × 12.

The calculator displays the monthly payment to the nearest cent. Total interest is estimated as the displayed payment multiplied by the number of payments, minus the original principal. Because the monthly payment is rounded, a real lender’s final payment may differ slightly to bring the balance to zero.

Worked Example

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

  1. Convert APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667.
  2. Convert the term to payments: n = 5 × 12 = 60.
  3. Substitute into the payment formula: 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53 per month.
  4. Estimate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

These are model results, not a lender quote. The interest total assumes all 60 payments are exactly $405.53; the actual final payment can be adjusted for rounding or the lender’s payment schedule.

Assumptions

  • The interest rate remains fixed for the full term.
  • Payments are equal, made monthly, and assumed to occur at the end of each monthly period.
  • Interest compounds monthly at APR ÷ 12.
  • Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.

Sample Repayment Schedule

The following first-year illustration uses the default loan inputs. Each month, interest is calculated on the opening balance; the rest of the $405.53 payment reduces principal. Figures are rounded to cents, so displayed components or balances may show a one-cent rounding difference.

Payment Opening balance Payment Interest Principal Closing balance
1 $20,000.00 $405.53 $133.33 $272.20 $19,727.80
2 $19,727.80 $405.53 $131.52 $274.01 $19,453.79
3 $19,453.79 $405.53 $129.69 $275.84 $19,177.95
12 $16,914.14 $405.53 $112.76 $292.77 $16,621.37

In the first month, interest is $20,000 × 0.08 ÷ 12 = $133.33. Subtracting that from the payment leaves about $272.20 to reduce principal. The next month’s interest is lower because it is calculated on a smaller balance. This is why a standard amortizing schedule gradually shifts toward principal repayment.

How to Read and Use a Schedule

A complete repayment schedule applies the same steps to every payment date. It is useful for understanding the planned path of a fixed-rate loan and checking how much of a payment goes toward the debt itself.

  • Opening balance: Amount owed before that payment’s interest is applied.
  • Interest: Opening balance multiplied by the periodic rate, subject to the lender’s calculation and rounding method.
  • Principal: Payment minus interest. This is the portion that reduces the balance.
  • Closing balance: Opening balance plus interest, minus payment. It becomes the next period’s opening balance.

To build the remaining rows, repeat the calculation for each month. The final balance should approach zero after the scheduled number of payments. If it does not, check the APR conversion, payment count, payment rounding, and whether the schedule includes fees or a different payment timing.

Common Errors and Limits

A repayment schedule is only as accurate as its inputs and assumptions. A quoted payment may not match this sample if the lender uses a different day-count convention, charges financed fees, changes the rate, or sets a different first payment date. The calculator models a fixed APR and regular monthly payments, not every contract detail.

  • Confusing APR and monthly rate: Enter the annual percentage as a percentage, such as 8, not 0.08. The formula converts it to a monthly decimal.
  • Using the wrong term unit: Enter years in the term field; the formula multiplies by 12 to get months.
  • Assuming all payments reduce principal equally: They do not. With a fixed payment and positive interest, the interest share generally declines as the balance falls.
  • Ignoring extra payments: Additional principal payments can change the payoff timeline and interest. They are not included in this calculator’s output.
  • Treating a sample as a statement: The schedule is a mathematical estimate, not an account ledger or a promise of the lender’s exact amounts.

For an adjustable-rate loan, a schedule based on one APR cannot reliably show future payments after a rate change. A variable rate requires updated inputs for the periods when the rate changes. Likewise, a schedule does not determine what rate, fees, or payment dates apply to a particular loan; obtain those figures from the lender’s disclosures.

Frequently Asked Questions

What is a repayment schedule?
A repayment schedule is a period-by-period list of payments, interest, principal reduction, and remaining balance over a loan’s term.

How do I calculate a monthly loan payment?
Convert APR to a monthly decimal rate, calculate the number of monthly payments, then use the fixed-payment formula shown above. The calculator performs these steps for the entered values.

Why does the interest portion go down each month?
For a fixed-rate amortizing loan, periodic interest is based on the outstanding balance. As principal is repaid, the balance falls, so the next interest charge usually falls too.

Does this sample include fees or extra payments?
No. It models principal and interest only, with no fees, insurance, escrow, or additional principal payments.

Why might my lender’s schedule differ by a few cents?
Rounding rules, payment dates, accrued-interest methods, fees, and the final-payment adjustment can create small differences from a calculator illustration.

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 →