This calculator works out the date your student loan will be fully paid off based on your current balance, interest rate, and monthly payment. You enter the amount you owe, the annual percentage rate (APR), and your planned monthly payment, and it returns the number of months remaining and the exact payoff date.
Formula
The number of months to pay off a loan with a fixed payment is calculated using the natural logarithm (ln):
n = ⌈ -ln(1 – r × P / M) / ln(1 + r) ⌉
Where:
- P = current loan balance (in dollars)
- r = monthly interest rate = APR / 12 / 100 (as a decimal)
- M = monthly payment (in dollars)
- n = number of months to pay off the loan (rounded up to the next whole month)
The formula comes from the present value of an annuity. It assumes you make the same payment every month, the interest rate never changes, and the payment is at least enough to cover the interest for that month.
Worked Example
Using the default values: balance = $30,000, APR = 6%, monthly payment = $350.
- Convert APR to monthly rate: r = 6 / 100 / 12 = 0.005
- Calculate 1 – r × P / M = 1 – (0.005 × 30000) / 350 = 1 – 150 / 350 = 1 – 0.428571 = 0.571429
- Take the natural log: ln(0.571429) = -0.559616
- Calculate ln(1 + r) = ln(1.005) = 0.0049875
- Divide: -(-0.559616) / 0.0049875 = 112.21
- Round up to the next whole month: 113 months
- Payoff date: if today is 2025-01-01, 113 months later is 2025-01-01 + 113 months = 2034-06-01 (approximately).
The calculator shows 113 months and the corresponding date.
Assumptions
- Fixed interest rate for the entire repayment period.
- Payments are made monthly at the same time each month.
- Interest is compounded monthly at APR/12.
- No additional fees, penalties, or capitalized interest are included.
- The monthly payment is constant and at least covers the monthly interest.
When to Use This Calculation
Use this calculator to see how long it will take to pay off your student loan with your current payment, or to compare the effect of making extra payments. It works for any fixed-rate loan, not just student loans. The result helps you understand the timeline, but it is not a substitute for your loan servicer’s official payoff statement.
How to Read the Result
The number of months is rounded up to the next full month because you cannot make a partial payment in the middle of a month. The payoff date is an estimate based on the current date. If you make extra payments or change your payment amount, the date will move earlier.
Common Mistakes
- Using the annual rate instead of monthly: Always divide the APR by 12 and by 100 to get the decimal monthly rate.
- Rounding too early: Round the final number of months, not intermediate values, to avoid errors.
- Ignoring the minimum payment requirement: If your payment is less than the monthly interest, the formula gives a negative or undefined result, meaning the balance grows.
- Assuming the payoff date is exact: The actual date depends on your first payment date and how your servicer applies payments.
Tips
- Use the exact payoff amount from your servicer, not just the principal balance, if you want a precise date.
- If you make extra payments, recalculate with the new balance and payment amount.
- Remember that some loans have variable rates; this calculation assumes a fixed rate.
- Check your loan statements to see if interest is capitalized (added to principal) at certain times, which would change the result.
Troubleshooting
If the result shows “Cannot compute”: This means your monthly payment is not enough to cover the interest. Increase the payment amount to at least the monthly interest (balance × APR / 1200). For example, on a $30,000 loan at 6% APR, the monthly interest is $150, so the payment must be above $150.
If the payoff date seems too far in the future: Check that you entered the APR as a percentage (e.g., 6 for 6%) and the payment as a dollar amount. Also verify the balance is the current outstanding amount, not the original loan amount.
If the number of months looks too low: Make sure you are not entering the payment as cents (e.g., 350 instead of 3.50). The payment should be the full monthly amount.
Frequently Asked Questions
Q: What if I make extra payments?
A: Extra payments reduce the principal faster, which shortens the payoff time. You can recalculate with your new balance and payment to see the updated date.
Q: Does this work for variable-rate loans?
A: No, it assumes a fixed rate. For variable rates, you would need to estimate the average rate over the life of the loan.
Q: Why is the payoff date rounded up?
A: Because you make payments monthly, so the final month is a full month. Rounding up gives the actual month when the last payment is made.
Q: Can I use this for other loans?
A: Yes, the formula works for any fixed-rate installment loan, such as auto or personal loans.
Q: What if my payment is less than the monthly interest?
A: Then the loan balance will grow, and you will never pay it off. The calculator will show “Cannot compute” to indicate this.
Q: How do I get the exact payoff amount?
A: Contact your loan servicer for a payoff quote, which includes interest up to a specific date and any fees. This calculation is an estimate.
This result is an estimate; your lender’s disclosure provides the exact figures.
Related
Formula used
in p | Current loan balance | $ | 30000 | 0 | 100000000 in apr | Interest rate (APR) | % | 6 | 0.01 | 100 in pmt | Monthly payment | $ | 350 | 1 | 100000000 out months | Months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * p / pmt) / ln(1 + apr / 1200), 6)) | 0 out date | Payoff date | date | months | time
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
- Debt Ratio Benchmarks: What Is a Good Debt Ratio?24.0 %
- Debt Ratio Calculation Formula & How to Use It25.00 %
- Calculate My Payoff Date: Loan Payoff Calculator
- Car Loan Calculator: Estimate Your Monthly Payment$405.53
- Student Loan Interest Deduction Limit: 2025 Rules$405.53
- Car Loan EMI Calculator Month Wise$405.53