This calculator checks whether a loan payment is out of date by comparing the payment amount you enter with the amount required to fully amortize the loan by its original maturity date. You enter the original loan amount, the annual interest rate (APR), the original term, and the number of payments already made; the calculator returns the remaining balance, the number of payments left, and whether the current payment is on track, behind, or ahead of schedule.
Formula
The core formula is the standard amortization payment equation. It calculates the level monthly payment needed to pay off a loan of principal P over N months at a monthly interest rate r (where r = APR / 1200).
Required monthly payment:
PMT = P × r / (1 − (1 + r)^(−N))
Where:
- P = original loan amount (in dollars)
- r = monthly interest rate = APR / 1200 (APR in percent per year)
- N = total number of payments in the original term (years × 12)
After k payments have been made, the remaining balance is:
Bk = P × (1 + r)k − PMT × ((1 + r)k − 1) / r
To find how many payments remain if you make a different payment M, solve for n in the amortization formula:
n = ⌈ −ln(1 − r × Bk / M) / ln(1 + r) ⌉
This gives the number of payments needed to bring the remaining balance to zero, rounded up to the next whole payment. If M is less than the monthly interest on the remaining balance (r × Bk), the loan will never be paid off, and the calculator shows “Cannot compute”.
Worked Example
Using the default values: loan amount $20,000, APR 8%, term 5 years, 24 payments already made, and actual payment $400.
- Monthly rate r = 8 / 1200 = 0.0066667
- Total payments N = 5 × 12 = 60
- Required payment = 20000 × 0.0066667 / (1 − (1.0066667)^(−60)) = 133.333 / (1 − 0.6712) = 133.333 / 0.3288 = 405.53 (rounded to $405.53)
- Remaining balance after 24 payments = 20000 × (1.0066667)^24 − 405.53 × ((1.0066667)^24 − 1) / 0.0066667 = 20000 × 1.1729 − 405.53 × (0.1729 / 0.0066667) = 23458 − 405.53 × 25.935 = 23458 − 10516 = $12,942
- Payments left at original term = 60 − 24 = 36
- With actual payment $400, n = ⌈ −ln(1 − 0.0066667 × 12942 / 400) / ln(1.0066667) ⌉ = ⌈ −ln(1 − 0.2157) / 0.006644 ⌉ = ⌈ −ln(0.7843) / 0.006644 ⌉ = ⌈ 0.2429 / 0.006644 ⌉ = ⌈36.56⌉ = 37
- Status = (400 − 405.53) × (37 − 36) = −5.53 × 1 = −5.53, which is negative, meaning you are behind schedule.
So with a $400 payment you will need 37 more payments instead of 36, and you will pay off the loan one month late.
Assumptions
- Fixed interest rate for the entire loan term.
- Payments are made monthly at the end of each period.
- Interest compounds monthly at APR / 12.
- The original payment is exactly the required amortization payment.
- No fees, penalties, taxes, or insurance are included.
When to Use This Calculator
This tool is useful when you want to know whether the payment you are currently making is enough to finish the loan by its original end date. Many borrowers make minimum payments, rounded amounts, or extra payments without realizing how those choices affect the payoff timeline. This calculator lets you compare your actual payment to the required payment and see how many extra payments (or early payments) you will have.
It is also helpful when you have missed a few payments or made a partial payment and want to know how far behind you are. Enter the number of payments you have actually made (not the number of months elapsed) and your current payment amount; the calculator will show the remaining balance and the number of payments left.
How to Read the Results
The first output, “Required payment”, is the amount you would need to pay every month to finish exactly on the original maturity date. If your actual payment is higher, you will finish early; if lower, you will finish late. The “Status” output is a simple indicator: a positive number means you are ahead of schedule, zero means on schedule, and a negative number means behind. The magnitude of the status number is not meaningful – only its sign matters.
The “Payments left at your actual payment” shows the total number of payments remaining, including partial final payments. For example, if it says 37, you will make 36 full payments and a smaller final payment. The difference between that number and “Payments remaining at original term” tells you how many extra payments you will make (or how many fewer).
Common Mistakes and Misconceptions
- Using the number of months elapsed instead of payments made. If you skipped a payment, the number of payments made is less than the number of months since the loan started. Always enter the actual count of payments you have made.
- Mixing up APR and monthly rate. The APR is a yearly rate; the formula divides by 1200 to get the monthly rate. Enter the APR as a percentage (e.g., 8 for 8%), not 0.08.
- Thinking a lower payment just means a slightly later payoff. If your payment is less than the monthly interest on the remaining balance, the loan will never be paid off – the balance grows forever. The calculator shows “Cannot compute” in that case, which is correct.
- Rounding too early. In the worked example, rounding the required payment to $405.53 before computing the balance introduces a small error. The calculator uses the exact unrounded value internally, then rounds the final display. For a precise result, do not round intermediate steps.
Limitations of the Formula
This calculator assumes a fixed rate and level payments. Real loans may have variable rates, fees, or payment changes. It also does not account for prepayment penalties, late fees, or any other charges that could affect the balance. The result is an estimate based on the inputs you provide; the lender’s disclosure gives the exact figures for your loan.
Frequently Asked Questions
What does “out of date” mean for a loan payment?
It means your payment is not enough to keep the loan on its original schedule. The loan will not be paid off by the original maturity date; you will need extra payments or a higher final payment.
How do I know if my payment is out of date?
Compare your actual payment to the required payment from this calculator. If your actual payment is lower, you are behind. You can also check the remaining balance and the number of payments left – if you have made 24 payments on a 60-month loan and the balance is higher than it should be, you are behind.
Can I catch up by making a larger payment later?
Yes. If you make a lump-sum payment, the remaining balance drops, and your regular payment will then cover more principal each month. The calculator can help you see how many payments remain after a lump sum if you enter the reduced balance as the “original loan amount” and adjust the number of payments made.
What if my payment is less than the monthly interest?
Then the loan balance will never decrease – it will grow over time. The calculator shows “Cannot compute” because there is no finite number of payments that will pay off the loan. You would need to increase your payment to at least cover the interest.
Does this calculator work for biweekly payments?
No. It assumes monthly payments. If you pay biweekly, you are effectively making 26 half-payments per year, which is more than 12 monthly payments, so you would pay off the loan faster. This calculator is for monthly payment schedules only.
This result is an estimate for educational purposes; your lender’s disclosure provides the exact figures for your loan.
Related
Formula used
in p | Original loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Original term | years | 5 | 0.0833 | 50 in n_paid | Payments already made | - | 24 | 0 | 600 in pmt_actual | Actual payment you are making | $ | 400 | 1 | 1000000 out pmt_required | Required payment to stay on schedule | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out bal_now | Remaining balance after n_paid payments | $ | p * (1 + apr / 1200) ^ n_paid - pmt_required * ((1 + apr / 1200) ^ n_paid - 1) / (apr / 1200) | 2 out n_left | Payments remaining at original term | - | yrs * 12 - n_paid | 0 out n_actual | Payments left at your actual payment | - | ceil(round(-log(1 - (apr / 1200) * bal_now / pmt_actual) / log(1 + apr / 1200), 6)) + 0 * sqrt(max(0, pmt_actual - (apr / 1200) * bal_now)) | 0 out status | Status vs. original schedule | - | (pmt_actual - pmt_required) * (n_actual - n_left) | 0
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 %
- Car Loan Calculator: Estimate Your Monthly Payment$405.53
- Calculate My Payoff Date: Loan Payoff Calculator
- Student Loan Interest Deduction Limit: 2025 Rules$405.53
- Car Loan EMI Calculator Month Wise$405.53