Loan Amortization Table With Extra Payments

A loan amortization table with extra payments shows how each scheduled payment and additional payment changes the balance, interest, and payoff date over time. Enter the original loan amount, APR, term, and extra amount per month to see an estimated month-by-month schedule.

Formula

Important limitation: the required calculator inputs above calculate the regular level monthly payment and total interest for a fixed-rate loan with no extra payments. They do not accept an extra-payment amount or produce an amortization table, so they cannot calculate the changing balance or payoff date after extra payments. A true extra-payment schedule needs at least one more input: the extra amount and when it is applied. The results below show the base loan before extra payments.

The monthly payment formula is M = P × r / [1 − (1 + r)⁻ⁿ]. Here, M is the scheduled monthly payment in dollars, P is the starting principal in dollars, r is the monthly interest rate as a decimal, and n is the number of monthly payments. The calculator converts APR to a monthly rate using r = APR / 1200, and converts years to months using n = 12 × years. Its total-interest output is I = M × n − P, using the displayed payment rounded to cents.

Worked Example

Using the calculator defaults, the loan principal is $20,000, APR is 8%, and the term is 5 years.

1. Convert the APR to a monthly decimal rate: r = 8 / 1200 = 0.0066667.
2. Convert the term to monthly payments: n = 5 × 12 = 60.
3. Apply the payment formula: M = 20,000 × 0.0066667 / [1 − (1.0066667)⁻⁶⁰], which is $405.53 per month rounded to cents.
4. Calculate total interest using the displayed monthly payment: I = $405.53 × 60 − $20,000 = $4,331.80.

These figures describe the scheduled-payment loan only. They are not the result of adding extra payments.

Assumptions

• The rate is fixed for the full stated term.
• Payments are monthly and made at the end of each period, as in the standard amortization formula.
• Interest compounds monthly at APR divided by 12.
• The calculation excludes extra payments, fees, taxes, insurance, PMI, and escrow.

How an Extra-Payment Amortization Table Works

A conventional amortization table has a row for each payment period. Common columns include the beginning balance, scheduled payment, extra principal, interest, principal repaid, and ending balance. For a monthly schedule with a fixed rate, interest for a period is generally calculated on the balance before that period’s payment: interest = beginning balance × monthly rate. The amount left from the scheduled payment after interest reduces principal. An eligible extra payment reduces principal further.

For example, if a period begins with a $20,000 balance and the monthly rate is 0.0066667, the estimated interest for that period is about $133.33. From a $405.53 scheduled payment, about $272.20 goes toward principal, before any extra payment. If an additional $100 is applied directly to principal that month, the ending balance is reduced by a further $100. Later interest is then calculated on a lower balance.

That lower balance is why extra principal can reduce the total interest and may shorten the time until payoff. The exact result depends on the extra amount, its timing, payment posting rules, and how the loan handles a final payment smaller than the usual amount.

How to Read and Build the Schedule

To make an accurate table, use the lender’s actual principal balance, APR, required payment, and the planned extra-payment pattern. Apply each payment in the order specified for the loan. A basic month-by-month calculation follows this sequence:

1. Start with the balance entering the period.
2. Calculate that period’s interest using the applicable rate and timing.
3. Apply the scheduled payment to interest and principal.
4. Apply any extra amount that is actually credited to principal.
5. Record the resulting balance and use it as the next period’s starting balance.

In a real schedule, the final payment is usually limited to the amount still owed, including accrued interest; it should not blindly repeat a full scheduled payment if that would overpay the balance. A table may also need to account for dates, daily interest, irregular payments, or rounding rules. The simple calculator above does none of these and cannot create the requested extra-payment schedule by itself.

What to Check Before Relying on an Extra-Payment Estimate

Find out how the servicer applies additional money. An extra amount may need to be designated for principal rather than treated as an advance payment of a future installment. Check whether extra principal can be paid at any time and whether any applicable loan terms or processing rules affect posting. Do not assume that sending more than the regular amount automatically changes the principal in the way a spreadsheet expects.

Also distinguish a recurring extra payment from a one-time lump sum. A recurring amount affects every modeled month; a lump sum affects only the period when it is paid. If payments are made twice a month, vary, or arrive on dates different from the schedule, a monthly model may not match the actual accrual of interest. Small differences in cents can accumulate because lenders may round interest and payments by period.

Common Misconceptions and Limits

An extra payment does not necessarily lower the required monthly payment. In many standard amortization arrangements, it reduces principal and therefore can shorten the payoff timeline while the required installment remains unchanged. A recast or other payment recalculation is a separate process and is not represented here. Whether a loan permits or offers such a process depends on its terms, so verify details with the servicer.

Another common mistake is using the interest rate where the formula requires APR or mixing annual and monthly units. The calculator assumes APR is entered as a percentage per year and divides it by 1,200. It also assumes a fixed rate and equal monthly payments. It is not suitable as an exact payoff quote, and it does not model variable rates, payment holidays, fees, missed payments, or extra principal.

Frequently Asked Questions

How do I calculate a loan amortization table with extra payments?
Calculate each period’s interest from the current balance, subtract the principal portion of the scheduled payment, then subtract any extra payment credited to principal. Repeat with the new balance. This page’s calculator does not include an extra-payment input, so it cannot generate that table.

Does paying extra reduce interest or the monthly payment?
When extra money is applied to principal, the lower balance generally means less interest accrues afterward. It does not automatically change the required installment; the effect on payment amount depends on the loan’s terms and any separate recalculation process.

Should extra payments be marked for principal?
Check the servicer’s instructions for how to ensure additional money is applied as intended. Payment allocation procedures can differ, and this calculation cannot confirm how a particular payment will be processed.

Can I use this calculator for a one-time extra payment?
No. Its inputs cover principal, APR, and term only. A one-time payment needs its amount and timing modeled in a period-by-period schedule.

Why might my lender’s payoff amount differ from a table?
A table is an estimate based on assumptions and rounded figures. The actual payoff can reflect payment dates, interest accrued since the last installment, posting practices, and other account-specific amounts. Request an exact payoff figure from the servicer.

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

Related

• Amortization Table Using EL-738 in Excel
• Simple Interest Loan Amortization Table Calculator
• Amortization Table Software: Calculate Loan Payments

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