Student Loan Repayment Amortization Schedule

A student loan repayment amortization schedule shows how each payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual interest rate, and repayment term to estimate a fixed monthly payment and total interest; the schedule itself can be built by applying the same monthly calculation repeatedly.

Formula

The calculator uses the standard fixed-payment amortization formula. It converts the annual percentage rate (APR) to a monthly rate, then finds the equal payment that reduces the balance to zero over the selected number of monthly payments.

• P is the starting loan principal, in dollars.
• APR is the annual interest rate entered as a percentage.
• r is the monthly rate, calculated as APR ÷ 1,200.
• n is the number of monthly payments, calculated as years × 12.
• M is the monthly payment, in dollars.

Monthly payment: M = P × r ÷ [1 − (1 + r)⁻ⁿ]. The displayed payment is rounded to the nearest cent. Total interest: displayed monthly payment × n − P. Because the payment is rounded, the total is an estimate based on paying that same rounded amount each month.

Worked Example

Using the defaults—$20,000 principal, 8% APR, and a 5-year term—the monthly rate is 0.08 ÷ 12 = 0.0066667, and the number of payments is 5 × 12 = 60.

1. Substitute into the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
2. The unrounded payment is about $405.53; rounded to cents, the monthly payment is $405.53.
3. Total of the 60 rounded payments: $405.53 × 60 = $24,331.80.
4. Estimated total interest: $24,331.80 − $20,000 = $4,331.80.

Assumptions

• The interest rate remains fixed for the entire term.
• Payments are equal, made monthly, with the first payment one month after the loan begins.
• Interest compounds monthly at APR ÷ 12.
• Fees, taxes, insurance, payment pauses, changing rates, and other loan charges are not included.

How an Amortization Schedule Works

For each month, interest is calculated on the balance at the start of that period. The payment first covers that interest; whatever remains reduces principal. As the balance falls, the interest portion generally becomes smaller, leaving more of a level payment to reduce principal. The final payment may differ slightly because of cent rounding or the lender’s method for handling accrued interest.

For the example, the first month’s interest is approximately $20,000 × 0.08 ÷ 12 = $133.33. Subtracting it from the $405.53 payment leaves about $272.20 to reduce principal, so the balance becomes about $19,727.80. In the next month, interest is calculated on that lower balance. This process repeats until the balance is paid off.

A schedule typically contains the payment number or date, opening balance, payment, interest charged, principal repaid, and closing balance. It can be prepared by hand, in a spreadsheet, or with a calculator that displays every period. This page calculates the level payment and estimated total interest; it does not display a dated, row-by-row schedule.

Using the Estimate for a Student Loan

Use the current principal that is actually subject to repayment, rather than the original amount borrowed if the balance has since changed. Enter the rate and term supplied by the loan servicer or shown in the relevant loan documents. The calculator accepts a single loan and a single fixed rate. If several loans have different rates, balances, or remaining terms, calculate each separately; adding the balances and using one blended rate can hide differences in their repayment paths.

The result is useful for understanding the arithmetic of a standard level-payment loan, but it may not reproduce a student loan account statement. A servicer’s schedule can reflect the actual payment due date, daily interest accrual, unpaid interest, fees, rate changes, payment allocation, or account-specific repayment arrangements. Repayment plans with changing payments or eligibility-based terms do not follow this fixed-payment formula. Check the applicable loan documents or ask the servicer for figures specific to the account.

Reading Results and Avoiding Common Errors

• APR versus monthly rate: Enter the annual percentage as a percentage—for example, 8, not 0.08. The formula divides it by 1,200 to get a monthly decimal rate.
• Years versus months: The term field is in years. Five means 60 monthly payments, not five payments.
• Different balances: Interest is calculated on the outstanding principal, not the original balance forever. A schedule that applies interest to the original amount each month will overstate interest.
• Rounding: Displayed payments are rounded to cents. Repeated monthly rounding and a lender’s final-payment adjustment can create a small difference from an estimate calculated using unrounded values.
• Extra or missed payments: Additional payments can change the payoff timeline, depending on how they are applied. Missed or delayed payments can also change accrued interest and the balance. Neither is included here.

A lower monthly payment can result from a longer term while increasing the number of months over which interest accrues. The calculator reports the payment and estimated total interest for the selected inputs; it does not account for other costs or evaluate which repayment arrangement fits an individual situation.

Frequently Asked Questions

What does a student loan amortization schedule show?
It lays out each payment period’s opening balance, payment, interest, principal reduction, and remaining balance. It illustrates how a loan is paid down under the schedule’s assumptions.

How do I calculate the interest portion of a monthly payment?
For this monthly-rate estimate, multiply the balance at the start of the month by APR ÷ 1,200. Subtract that interest from the payment to estimate the amount applied to principal.

Why does my servicer’s payment differ from this estimate?
The account may use a different balance, payment date, accrual method, rate, term, or payment arrangement. Fees, unpaid interest, and rounding can also affect the quoted amount; compare the calculator inputs with the loan statement.

Does this calculation include extra payments or forgiveness?
No. It models equal monthly payments on one fixed-rate loan. Extra payments, payment pauses, changing payments, and program-specific terms are not represented.

Can I combine multiple student loans in one calculation?
You can enter a combined balance for a rough estimate only if one rate and one term reasonably represent the entire amount. For loans with different terms or rates, calculate each separately for a clearer result.

This result is an estimate for educational arithmetic, and the lender’s disclosure gives the exact figures.

Related

• Loan Repayment Schedule Calculator and Oracle BI Publisher
• Loan Payment Schedule in Google Sheets: Formula & Example
• Loan Payment Schedule With Amortization Explained

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