This calculator estimates how much interest remains on a fixed-rate loan after you make a specified number of regular monthly payments, which helps show the interest you may avoid by paying the balance off early. Enter the original loan amount, APR, term, and payments already made; the results are an estimated balance and the interest remaining under the formula, not a lender’s payoff quote or a calculation of any penalty.
Formula
The calculator uses a standard fixed-rate, fully amortizing loan formula. It first finds the monthly payment, then estimates the balance after 12 monthly payments. The final output is total scheduled interest across the original term, not a lender’s early payoff penalty or a quote for the interest saved by paying off on a particular date.
- Monthly payment: M = round(P × r ÷ [1 − (1 + r)−n], 2)
- Estimated balance after k payments: Bk = P × (1 + r)k − M × [(1 + r)k − 1] ÷ r
- Scheduled interest over the term: I = M × n − P
P is the starting principal in dollars; APR is the annual percentage rate entered as a percentage; r is the monthly rate, APR ÷ 1,200; n is the number of monthly payments, loan term in years × 12; M is the monthly payment in dollars rounded to cents; B is the estimated balance in dollars; and k is the number of payments. This version reports the balance after 12 payments. The interest output uses the rounded monthly payment, so small rounding effects can occur.
Worked Example
Using the calculator’s defaults—$20,000 principal, 8% APR, and a five-year term—n = 5 × 12 = 60 monthly payments and r = 8 ÷ 1,200 = 0.0066667 per month.
- Payment: M = round(20,000 × 0.0066667 ÷ [1 − (1.0066667)−60], 2) = $405.53 per month.
- Balance after 12 payments: B12 = 20,000 × (1.0066667)12 − 405.53 × [(1.0066667)12 − 1] ÷ 0.0066667 = $16,412.61.
- Scheduled interest: I = $405.53 × 60 − $20,000 = $4,331.80.
The balance is an estimate based on monthly payments and rounding. A real lender’s balance can differ because of payment dates, daily interest, fees, payment allocation, or other contract terms.
Assumptions
- The interest rate is fixed for the entire term.
- Payments are equal, made monthly, and applied at the end of each period.
- Interest compounds monthly at APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, and any payoff or prepayment charge.
What an Early Payoff Penalty Means
A loan early payoff penalty, also called a prepayment penalty, is a charge a lender may impose under the loan agreement when the borrower pays some or all of the debt before a specified time. Whether one applies, how it is calculated, and which payments trigger it depend on the particular contract and applicable rules. This calculator does not determine those terms; check the loan disclosure or ask the servicer for the exact payoff amount and any applicable charge.
Paying early can also change the interest paid because interest generally accrues on the outstanding principal under the loan’s calculation method. A penalty and interest are separate things: a payoff quote may include principal still owed, interest accrued through the payoff date, and other contractually specified amounts. It is not necessarily the same as the balance shown on a monthly statement.
How to Read the Results
The monthly payment is a level-payment estimate for the inputs. The balance output is specifically an estimate after 12 payments, not after any number you choose. To estimate a different point in the schedule, replace 12 in the balance expression with the number of payments completed. The scheduled-interest output describes the full original repayment schedule; it does not say how much interest remains after month 12.
For a rough comparison, a borrower can compare scheduled payments remaining under the original schedule with the lender’s written payoff quote. That comparison is not a penalty calculation: it must account for the actual payment date, accrued interest, any fees, and the precise contract. Ask the servicer for an itemized payoff quote with a valid-through date before relying on a figure.
Common Mistakes and Limits
- Confusing APR with a monthly rate: APR is entered as a percentage per year. The formula divides it by 1,200 to obtain a monthly decimal rate.
- Treating the estimate as a payoff quote: The calculator assumes regular monthly payments and does not know the lender’s balance, exact date, or contract charges.
- Assuming every early payment triggers a penalty: Penalty terms vary. A partial extra payment and a full payoff may be treated differently by a particular agreement.
- Ignoring rounding: The payment is rounded to cents. Actual servicing may round each period differently, creating small balance differences over time.
The formula is not suitable without adjustment for variable rates, interest-only periods, irregular payment schedules, balloon payments, skipped or late payments, or loans with fees financed into the balance. It also cannot determine whether a payoff charge is permitted or applicable; that requires checking the loan documents and obtaining the lender’s figures.
Frequently Asked Questions
Is there always a penalty for paying off a loan early?
No. Whether a charge applies depends on the specific loan agreement and relevant rules. Review the contract and request confirmation from the servicer.
Does this calculator show my early payoff penalty?
No. It estimates a monthly payment, a balance after 12 payments, and scheduled interest over the original term. It has no input for penalty terms or lender fees.
Is the balance shown the amount I need to pay today?
No. It is a formula estimate after 12 payments. A lender’s payoff quote can include interest through a particular date and other amounts not represented here.
Does paying extra reduce the monthly payment?
Not necessarily. The effect depends on the loan terms and how the servicer applies extra money. It may reduce principal or affect the schedule without changing the required payment; ask the servicer how it will be handled.
How can I find out whether my loan has a prepayment charge?
Check the signed loan agreement and disclosure for prepayment or early payoff language, then ask the servicer to confirm whether it applies to your planned payment and request an itemized quote.
This result is an estimate for educational purposes; the lender’s disclosure and payoff quote give the exact figures.
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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2 out bal | Estimated balance after 12 months | $ | p * (1 + apr / 1200) ^ 12 - pmt * ((1 + apr / 1200) ^ 12 - 1) / (apr / 1200) | 2 out int | Interest remaining over scheduled term | $ | 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
- Cash-Out Refinance at U.S. Bank: Estimate the Cash$62,000.00
- VA Cash-Out Refinance Calculator and How It Works$405.53
- Cash-Out Refinance on a Second Home: Rules and Costs$405.53
- Cash-Out Refinance With a Second Lien?$405.53
- Cash-Out Refinance on a Second Home: Costs and Options$405.53
- Cash-Out Refinance Second Home Rates Explained$1,330.60