Amortization Formula With Extra Payments: How It Works

An amortization formula with extra payments calculates how each scheduled payment and additional payment reduce a loan balance over time. Enter the loan amount, APR, term, and extra amount paid monthly to estimate the regular payment, payoff time, interest, and savings compared with making scheduled payments only.

Formula

For a fixed-rate loan with monthly payments, first calculate the scheduled payment from the principal, monthly interest rate, and number of payments:

r = APR / 1200
n = 12 × years
M = round[P × r / (1 − (1 + r)⁻ⁿ), 2]

Here, P is the original loan principal in dollars, APR is the annual percentage rate entered as a percentage, r is the monthly rate as a decimal, n is the scheduled number of monthly payments, and M is the monthly scheduled payment in dollars, rounded to cents.

An extra-payment schedule is calculated month by month. If E is the extra amount paid that month and B_t is the balance before payment t, then:

Interest_t = B_t × r
Principal paid_t = M + E − Interest_t
B_t+1 = B_t − Principal paid_t

The final payment must be limited to the amount actually due; otherwise, the schedule would show an overpayment. This calculator’s displayed formula provides the scheduled payment and baseline interest without extras. To model extra payments exactly, repeat the balance calculation for each month, use the actual final payment, and add the monthly interest amounts. The simple output is not a simulated extra-payment payoff schedule.

Worked Example

Using the calculator’s defaults—$20,000 principal, 8% APR, five years, and no extra-payment input—the standard amortized payment is:

1. Monthly rate: 8 / 1200 = 0.0066667.
2. Number of scheduled payments: 5 × 12 = 60.
3. Payment before rounding: 20,000 × 0.0066667 / [1 − (1.0066667)⁻⁶⁰] ≈ $405.53.
4. Payment rounded to cents: $405.53 per month.
5. Baseline total interest using the displayed formula: $405.53 × 60 − $20,000 = $4,331.80.

The example does not include extra payments: the calculator block has no extra-payment input, so its results are the scheduled-payment baseline. The amortization equations above explain how an extra amount changes the balance path, but do not claim a specific extra-payment payoff result.

Assumptions

• The APR is fixed for the full modeled term.
• Payments are made monthly, at the end of each period, with the first payment one month after borrowing.
• Interest compounds monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, payment-date variations, and lender-specific rounding are not included.

How Extra Payments Change Amortization

A scheduled payment covers that period’s interest first; the remainder reduces principal. An extra payment applied to principal lowers the balance on which future interest is calculated. As a result, later interest charges can fall and the loan may be paid off sooner, provided the lender applies the additional amount to principal and does not instead treat it as an advance payment of a future installment.

For a constant extra amount, calculate each period in order. Start with the opening balance, calculate interest, subtract that interest from the scheduled payment plus extra amount, and carry the remaining balance forward. In the last period, pay only the remaining balance plus that period’s interest. The total interest is the sum of the interest charges for all periods, not simply the scheduled payment multiplied by the original term minus principal.

Extra payments can be regular, occasional, or a one-time lump sum. For a variable pattern, use the actual extra amount in each period. The underlying method is the same, but a single closed-form payment formula does not capture an irregular sequence as conveniently as a month-by-month schedule.

When to Use the Calculation

Use the standard payment formula to check the scheduled monthly payment and baseline interest for a fixed-rate, fully amortizing loan. Use the recurrence equations when you want to understand how additional principal payments affect the balance over time. A spreadsheet can help: create one row per month with opening balance, interest, scheduled payment, extra payment, principal reduction, and closing balance.

For a spreadsheet or hand calculation, keep these details consistent:

• Use APR as a percentage in the calculator, then convert it to a monthly decimal by dividing by 1200.
• Apply any extra payment in the period it is actually made, rather than subtracting it from the original principal without accounting for timing.
• Do not let the last payment exceed the remaining balance and interest due.
• Round payments and interest according to the lender’s actual method when reconciling an estimate with a statement.

Common Mistakes and Limits

A frequent error is entering 8 for an 8% APR in a formula that expects 0.08. The calculator’s formula handles the percentage conversion with APR / 1200; in a manual formula using a decimal annual rate, the monthly rate is 0.08 / 12. Another error is using the APR as though it were the monthly rate, which greatly overstates interest.

Another misconception is that every “extra payment” automatically reduces principal immediately. Payment handling varies by loan and servicer. Check how an additional amount is credited, whether a separate principal-only instruction is needed, and whether the loan terms impose any relevant conditions. The calculator cannot determine these details.

The displayed calculator is a baseline calculation: it does not ask for an extra-payment amount, so its total-interest output is not the interest after extras. It also assumes a fixed rate and regular monthly timing. It does not model variable rates, skipped or late payments, daily interest accrual, fees, payment changes, or a lender’s exact payoff quote. A result is therefore useful for understanding the math, not for replacing an account-specific schedule.

Frequently Asked Questions

What is the amortization formula with extra payments?
Calculate monthly interest as the opening balance times the monthly rate, then subtract that interest from the scheduled payment plus the extra amount. The remaining balance becomes the next period’s opening balance; cap the final payment at the amount due.

Do extra payments reduce the monthly payment?
Not necessarily. In a typical fixed-payment amortization schedule, extra principal reduces the balance and can shorten the payoff period, while the scheduled payment stays unchanged. The actual treatment depends on the loan and how payments are applied.

Does this calculator include extra payments?
No. Its inputs calculate the scheduled payment and baseline interest for the original term. The block has no extra-payment input, so it cannot calculate an extra-payment payoff date or interest savings.

How do I calculate interest for each month?
Multiply the balance before that month’s payment by the monthly rate, APR divided by 1200. Subtract the interest from the payment amount to find the principal reduction, then update the balance.

Why might my lender’s figures differ?
Actual results may reflect payment dates, daily interest accrual, fees, rounding practices, rate changes, or how extra amounts are credited. Use the lender’s statement or payoff disclosure for account-specific figures.

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

Related

• Zelle First Payment? What to Expect and How It Works
• When Will I Get My First JSA Payment?
• When Is Interest Paid on T-Notes? Payment Dates 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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest with extra payments | $ | pmt * yrs * 12 - p | 2