calculate-loan

01 Loan payments

Student Loan Payoff Schedule: How It Works

Calculator No. 01-21448 · 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 student loan payoff schedule is a table that shows each monthly payment, how much goes to interest versus principal, and the remaining balance over the life of the loan. You can generate one by entering your loan amount, interest rate, and term into a standard amortization formula, which is exactly what the calculator below does.

Formula

The monthly payment for a fixed-rate student loan is calculated with the standard amortization formula:

M = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

  • M = monthly payment (in dollars)
  • P = principal loan amount (in dollars)
  • r = monthly interest rate = annual APR ÷ 12 (as a decimal, e.g., 6.5% ÷ 12 = 0.0054167)
  • n = total number of monthly payments = term in years × 12

The payoff schedule itself is built by applying the payment each month: interest for that month is the current balance times the monthly rate, the rest of the payment reduces principal, and the new balance becomes the starting point for the next month.

Worked Example

Using the calculator defaults: $35,000 loan, 6.5% APR, 10-year term.

  1. Convert APR to monthly rate: r = 6.5 / 1200 = 0.0054167
  2. Number of payments: n = 10 × 12 = 120
  3. Plug into the formula: M = 35000 × (0.0054167 × (1.0054167)^120) / ((1.0054167)^120 − 1)
  4. (1.0054167)^120 ≈ 1.9106
  5. M = 35000 × (0.0054167 × 1.9106) / (1.9106 − 1) = 35000 × 0.010349 / 0.9106 ≈ 397.81

The monthly payment rounds to $397.81. Total paid = 397.81 × 120 = $47,737.20. Total interest = 47,737.20 − 35,000 = $12,737.20. These match the calculator outputs.

Assumptions

  • Fixed interest rate for the entire term (no variable-rate changes).
  • Payments are made monthly, on time, starting one month after disbursement.
  • Interest is compounded monthly at APR ÷ 12.
  • No fees, late penalties, deferment, forbearance, or loan forgiveness are included.
  • The payment is rounded to the cent; the schedule uses that exact rounded payment.

How to Read Your Payoff Schedule

Each row of a payoff schedule shows four key numbers: the payment number, the payment amount, the interest portion, and the principal portion. Early in the schedule, interest makes up a large share of the payment. For the example above, the first payment of $397.81 has about $189.58 in interest and $208.23 in principal. By the final payment, interest is only a few dollars and nearly the entire payment goes to principal.

The remaining balance column is what you would owe if you paid off the loan in full after that payment. This is the number a lender uses to give you a payoff quote, which may include a small per-diem interest adjustment because you are paying on a date between scheduled payments.

How to Build Your Own Schedule

You can create a payoff schedule in a spreadsheet with these steps:

  1. Write the starting balance in cell A1.
  2. For each month, compute interest = balance × (APR/12).
  3. Principal paid = monthly payment − interest.
  4. New balance = old balance − principal paid.
  5. Repeat for all months until the balance reaches zero.

For the example, month 1: interest = 35000 × 0.0054167 = 189.58, principal = 397.81 − 189.58 = 208.23, new balance = 35000 − 208.23 = 34,791.77. Continue for 120 rows. The final balance should be within a few cents of zero due to rounding.

Common Mistakes and Misconceptions

  • Using the APR as a monthly rate: Always divide by 12. Using 6.5% instead of 0.5417% per month would produce a payment of about $1,900, not $398.
  • Ignoring rounding: Lenders round payments to the cent. A schedule that uses an unrounded payment will differ slightly from the actual amortization.
  • Assuming a payoff schedule shows the same payment every month: It does, but only if the rate is fixed and you never miss a payment. Variable-rate loans change the schedule whenever the rate changes.
  • Thinking interest is calculated on the original balance: It is calculated on the remaining balance, which is why the interest portion declines over time.

How Extra Payments Change the Schedule

If you pay extra each month, the additional amount goes entirely to principal (unless your lender applies it to future payments, which you should confirm). That reduces the balance faster, which means less interest accrues in later months, and the loan is paid off before the original term ends.

For example, on the $35,000 loan above, adding $50 per month (total payment $447.81) reduces the payoff time from 120 months to about 105 months and saves roughly $1,900 in interest. Adding $100 per month cuts the term to about 93 months and saves about $3,400. The exact numbers depend on when the extra payment is applied.

Federal vs. Private Student Loans

Federal student loans typically offer fixed rates and income-driven repayment plans, which recalculate your payment based on income and family size. Those plans have their own rules for interest subsidies and eventual forgiveness, but they do not follow the standard amortization schedule above. Private student loans almost always use standard amortization, but may offer variable rates or different deferment options.

The calculator here models only the standard fixed-rate amortization. If you have an income-driven plan or a variable-rate loan, the schedule will differ. Contact your loan servicer for the exact terms and to get a personalized payoff projection.

Frequently Asked Questions

What is the difference between a payoff schedule and an amortization table?

They are the same thing. An amortization table is the formal name for the schedule that breaks each payment into interest and principal and shows the remaining balance. Lenders use the terms interchangeably.

Why does my payoff amount differ from my remaining balance?

Your remaining balance is the principal plus accrued interest as of your last statement. A payoff quote adds interest that accrues between that statement date and the actual payoff date, often a few days’ worth. It may also include fees if you are paying off a private loan early.

Can I request a payoff schedule from my lender?

Yes, most servicers provide an amortization schedule online or by request. You can also generate one yourself using the formula above. The lender’s schedule is authoritative because it reflects their exact rounding and payment application rules.

Does making extra payments always reduce the term?

Yes, if the extra amount is applied to principal and you continue making at least the regular payment. Some lenders apply extra payments to future installments unless you specify otherwise, which would not reduce the term. Always indicate that extra payments should go to principal.

What happens if I miss a payment?

Missing a payment typically triggers a late fee and may capitalize unpaid interest, meaning it is added to your principal balance. That increases the balance and the interest charged in future months, so your schedule will be recalculated. Federal loans have specific deferment and forbearance options that can pause payments without defaulting.

This calculator gives an estimate based on standard amortization. Your lender’s disclosure and servicing statement provide the exact figures for your loan.

Related

Formula used
in p | Loan amount | $ | 35000 | 1 | 100000000
in apr | Interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Loan term | years | 10 | 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
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 →