calculate-loan

01 Loan payments

Personal Loan Payment Schedule Explained

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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 personal loan payment schedule shows each monthly payment, how much goes to interest versus principal, and your remaining balance over the loan term. You enter the loan amount, APR, and term to get the full breakdown, including the fixed monthly payment and total interest. This page provides a calculator and a clear explanation of how the schedule is built and how to read it.

Formula

The payment schedule is based on the standard amortization formula for a fixed-rate loan. Each month, the same payment is made, but the split between interest and principal changes over time.

Monthly payment = P × (r / (1 – (1 + r)^(-n)))

  • P = loan amount (principal) in dollars
  • r = monthly interest rate = APR / 1200 (APR is the annual percentage rate, divided by 12 months and by 100 to convert from percent to a decimal)
  • n = total number of monthly payments = loan term in years × 12

For each payment k (from 1 to n), the interest portion is the current balance times r, and the principal portion is the payment minus that interest. The balance after each payment is the previous balance minus the principal portion.

Worked Example

Using the default values: loan amount = $20,000, APR = 8%, term = 5 years.

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Number of payments n = 5 × 12 = 60
  3. Payment = 20000 × (0.0066667 / (1 – (1 + 0.0066667)^(-60)))
  4. Calculate (1 + 0.0066667)^(-60) = (1.0066667)^(-60) ≈ 0.67121
  5. 1 – 0.67121 = 0.32879
  6. 0.0066667 / 0.32879 = 0.020276
  7. Payment = 20000 × 0.020276 = 405.52 (rounded to the nearest cent)

So the monthly payment is $405.52. Over 60 payments, you pay 60 × 405.52 = $24,331.20. Total interest = 24,331.20 – 20,000 = $4,331.20.

The first payment: interest = 20,000 × 0.0066667 = $133.33, principal = 405.52 – 133.33 = $272.19, new balance = 20,000 – 272.19 = $19,727.81. The last payment reduces the balance to zero.

Assumptions

  • Fixed interest rate for the entire loan term (no rate changes).
  • Payments are made at the end of each month, starting one month after the loan is issued.
  • Interest is compounded monthly at the APR divided by 12.
  • No fees, origination charges, late fees, or prepayment penalties are included. If your loan has these, the actual schedule will differ.
  • No extra payments or lump sums are considered; the schedule assumes exactly the required payment each month.

How to Read Your Payment Schedule

Lenders provide an amortization schedule with each payment row. Columns typically show payment number, payment amount, interest paid, principal paid, and remaining balance. Early in the term, a larger share of each payment goes to interest because the balance is high. As the balance drops, the interest portion shrinks and more of your payment reduces principal. This is called front-loaded interest.

For example, with the $20,000 loan above, the first payment includes $133.33 in interest and $272.19 in principal. By payment 30, the balance is around $11,000, so interest is about $73, and principal is about $332. By the final payment, interest is just a few dollars.

Why the Payment Schedule Matters

Knowing your schedule helps you plan your budget and understand how much you will actually pay over time. The total interest figure is often much larger than people expect, especially for longer terms. A 5-year loan at 8% on $20,000 costs $4,331 in interest, but a 10-year loan at the same rate would cost about $9,300 in interest, even though the monthly payment is lower.

Your payment schedule also shows your remaining balance at any point, which is useful if you want to pay off the loan early or refinance. The payoff amount is not just the remaining principal; it is the current balance plus any accrued interest and fees, which the lender will quote.

Common Mistakes and Misconceptions

  • Mistaking APR for the monthly rate: APR is annual, so always divide by 12 (and by 100) to get the monthly rate.
  • Assuming equal interest and principal portions: early payments are mostly interest, not principal.
  • Ignoring fees: an origination fee reduces the amount you actually receive, which effectively raises your APR. The schedule shown by the lender reflects the fee-adjusted rate.
  • Rounding too early: if you round the monthly rate or payment to fewer decimals, the final balance may not reach zero. Lenders use exact calculations and round only the final payment.
  • Thinking extra payments automatically shorten the term: unless you specify that extra payments go to principal, the lender may apply them to future payments or interest.

How to Use the Calculator

Enter your loan amount, APR, and term in years. The calculator returns the fixed monthly payment and total interest. To see the full schedule, you would need a table, but the formula above lets you compute any row yourself. For a more detailed schedule, many spreadsheet programs have built-in amortization functions (like PMT and IPMT) that replicate this calculation.

To find your balance after a certain number of payments, use the balance formula: Balance = P × (1 + r)^k – payment × (((1 + r)^k – 1) / r), where k is the number of payments made. For example, after 12 payments on the $20,000 loan, the balance is approximately $16,500.

Frequently Asked Questions

Can I pay off a personal loan early without penalty?

Some lenders charge a prepayment penalty, but many do not. Check your loan agreement or ask your lender. If there is no penalty, paying extra reduces your balance faster and saves interest, but the payment schedule will be recalculated.

What happens if I miss a payment?

Missing a payment typically results in a late fee and may affect your credit score. The loan does not forgive the payment; it becomes past due, and interest continues to accrue. Contact your lender immediately to discuss options.

How is the payment schedule different from a credit card minimum payment?

A personal loan has a fixed payment and a defined end date. Credit card minimum payments are usually a percentage of the balance and can vary, leading to a much longer payoff period and more interest if you only pay the minimum.

Does the payment schedule change if I make extra payments?

If you make an extra payment and direct it to principal, your remaining balance drops faster. The lender will either shorten your term (keeping the same monthly payment) or lower your monthly payment (keeping the same term). The schedule is recalculated accordingly.

What is the difference between APR and interest rate?

The interest rate is the cost of borrowing the principal. The APR includes the interest rate plus certain fees and costs, expressed as a yearly rate. For the payment schedule, lenders use the APR to calculate the payment, but the actual interest charged each month is based on the interest rate and the daily balance.

Why is my first payment higher than the scheduled payment?

Sometimes the first payment includes interest that accrued between the loan disbursement and the first payment date, especially if the first payment is more or less than a full month away. This is called odd-day interest and is disclosed in your loan documents.

This calculator provides an estimate based on the standard amortization formula. Your lender’s official payment schedule, including any fees or adjustments, will be shown in your loan disclosure.

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 →