Prepayment Amortization Calculator: Extra Loan Payments

A prepayment amortization calculator shows how extra payments toward loan principal can change the payoff schedule and reduce interest. Enter the loan balance, APR, term, and additional monthly principal amount to estimate the revised payment schedule, payoff time, and interest savings.

Formula

The calculator block above calculates the scheduled monthly payment and the interest over the original full term. It does not calculate prepayment: its inputs contain no extra-payment amount, and its output formulas do not adjust the balance or schedule. A true prepayment amortization calculator needs an additional input and outputs for the revised payoff date and interest; this block cannot provide those results.

For the standard fixed-payment calculation shown, the monthly payment formula is:

M = P × r ÷ [1 − (1 + r)−n]

• P is the starting loan principal, in dollars.
• APR is the annual percentage 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 level monthly payment, in dollars.

Total interest under this simplified schedule is M × n − P. The given block does not round the payment to cents within its expression, nor does it allow for a final payment adjusted to clear a cent-rounded balance. Its interest figure is therefore a formula estimate, not a lender payoff quote.

Worked Example

Using the calculator block’s exact defaults—$20,000 principal, 8% APR, and a five-year term:

1. Convert the annual rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066667.
2. Count the monthly payments: n = 5 × 12 = 60.
3. Apply the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53.
4. Using the unrounded formula payment, total interest is approximately M × 60 − 20,000 = $4,331.06.

The block displays amounts to two decimal places, so its displayed payment is $405.53 and its displayed interest is about $4,331.06. Multiplying the displayed payment by 60 can differ by a few cents from a total based on the unrounded payment; actual schedules commonly account for rounding and may adjust the last payment.

Assumptions

• The rate remains fixed for the entire term.
• Payments are made monthly, with the first payment one month after the loan begins.
• Interest is modelled monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, lender-specific rounding, and payment-date effects are not included.
• No extra principal payments are included: the specified calculator block models only the scheduled amortization.

What Prepayment Amortization Means

An amortizing loan is repaid through scheduled installments. Each installment covers interest accrued for the period and reduces principal by the remainder. Early in a level-payment schedule, the outstanding balance is larger, so the interest portion tends to be larger. As principal falls, less interest accrues and more of each scheduled payment goes toward principal.

A prepayment is an amount paid in addition to the scheduled payment and applied to principal. If it is accepted and credited that way, the lower balance generally produces less interest in later periods. With the regular payment unchanged, the borrower may reach a zero balance sooner. But the exact result depends on the contract and how the servicer handles the extra amount; some arrangements may treat extra money as future scheduled payments rather than principal reduction unless directed otherwise.

How a True Prepayment Calculator Works

A complete calculator needs at least the starting balance, rate, scheduled payment or remaining term, and extra-payment amount and frequency. It then repeats the monthly balance calculation. In a simplified monthly model, interest for a period is the opening balance multiplied by the monthly rate; principal reduction is the payment minus that interest; and the closing balance is the opening balance minus principal reduction. An extra principal payment is subtracted from that closing balance, subject to the balance not falling below zero.

The calculation continues until the balance is paid, then compares the revised schedule with the no-prepayment schedule. Useful results include the number of payments remaining, the final payment amount, total interest under each schedule, and the difference in interest. For irregular extra payments, the calculator needs their dates or amounts by period; a constant monthly-extra assumption will not represent a one-time lump sum or changing contributions accurately.

How to Use and Read the Estimate

For a prepayment estimate, use the current principal balance—not necessarily the original amount borrowed—and the current rate and remaining term. Enter extra principal separately from the required payment. Check that the extra amount is applied to principal and confirm whether the input is monthly, annual, or one-time. If the loan has a variable rate, the estimate can only model the rate assumption selected; future changes are unknown.

Compare scenarios using the same starting balance, rate, and timing. Interest savings are the estimated interest in the baseline schedule minus estimated interest in the extra-payment schedule. A shorter payoff period does not mean that each required monthly payment has fallen: in many schedules, the regular installment stays the same and the loan ends earlier. Some lenders may instead recast or recalculate payments, which is a different scenario.

Common Problems and Limits

• Wrong balance: An original loan amount overstates the current principal after payments have already been made.
• Payment allocation: An extra payment only reduces principal as modelled if it is credited to principal; check the payment instructions and account history.
• Rounding and dates: Real interest can depend on daily balances, payment dates, and rounding. A monthly formula is an approximation.
• Other charges or terms: Fees, changing rates, deferred amounts, missed payments, and payment caps are outside a basic amortization calculation.
• Overpayment in the last period: The final payment should be limited to the amount due; a formula that keeps adding the full extra payment can produce a negative balance.

Do not interpret the simple calculator block on this page as an extra-payment tool: it has no extra-payment input, so it cannot show prepayment savings. Use a calculator whose inputs and outputs explicitly model extra principal and a revised schedule, and compare its assumptions with the loan statement or servicer’s figures.

Frequently Asked Questions

Does an extra payment go directly to principal?
Not necessarily. Allocation depends on how the payment is submitted and processed. Check the account instructions or ask the servicer how to designate an extra amount for principal.

Does prepayment reduce the monthly payment?
Often, a basic extra-payment schedule keeps the required installment unchanged and pays the loan off sooner. A recalculation or recast can change the required payment, but that is a separate feature and is not modelled by the block above.

How do I calculate interest savings from extra payments?
Calculate total interest in a baseline schedule and in a schedule with the extra principal payments, then subtract the latter from the former. Both schedules must use consistent rate, payment timing, and rounding assumptions.

Can I use the original loan amount?
Only if the loan has not yet been paid down. For an in-progress loan, use the current principal balance and remaining term for a forward-looking estimate.

Why is a calculator result different from my payoff quote?
A payoff quote can reflect the exact payoff date, accrued interest, payment processing, fees, and contract terms. A general monthly amortization formula does not include all those details.

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

Related

• Amortization Schedule With Extra Principal Payments
• Amortization Schedule Monthly Payment Calculator
• Amortization Calculator: How Loan Payments Work

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