calculate-loan

01 Loan payments

Prepayment Schedule E12: Loan Payoff Calculator

Calculator No. 01-14649 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

“Prepayment schedule E12” is not a standard, universally defined loan term, so an “E12” label alone does not identify a particular payment schedule. This calculator estimates the monthly payment and total interest for a fixed-rate loan; enter the loan amount, APR, and term to see the baseline schedule before any extra payments.

Formula

This is a standard fixed-payment amortization calculation. It finds the payment that would repay the starting balance over the stated number of monthly periods, assuming a constant APR and no additional payments. Let:

  • P = starting loan principal, in dollars.
  • a = annual percentage rate (APR), entered as a percentage number, such as 8 for 8%.
  • r = monthly interest rate as a decimal, calculated as a / 1200.
  • y = loan term in years.
  • n = number of monthly payments, calculated as 12y.
  • M = calculated monthly payment, in dollars.

The unrounded payment formula is M = P × r / [1 − (1 + r)−n]. The calculator displays the payment to the nearest cent. Total interest is estimated as M × n − P, using the displayed, cent-rounded monthly payment. As a result, the total is an estimate and may differ slightly from a lender’s schedule, especially when the final payment is adjusted for rounding.

Worked Example

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

  1. Convert the APR to a monthly decimal rate: 8 / 1200 = 0.0066667, or about 0.66667% per month.
  2. Find the number of payments: 5 × 12 = 60.
  3. Substitute into the payment formula: $20,000 × 0.0066667 / [1 − (1.0066667)−60] ≈ $405.53 per month.
  4. Estimate total interest with the displayed payment: $405.53 × 60 − $20,000 = $4,331.80.

The calculator therefore shows a monthly payment of $405.53 and estimated total interest of $4,331.80 for these inputs.

Assumptions

  • The interest rate stays fixed for the full term.
  • Payments are made monthly, with the first payment one month after the loan begins.
  • Interest is modelled monthly at APR divided by 12.
  • The estimate excludes fees, taxes, insurance, PMI, and escrow, and assumes no missed or extra payments.

What “Prepayment Schedule E12” Might Mean

“Prepayment schedule” can refer generally to a plan for paying principal earlier than required, but “E12” does not have one standard meaning across loan products or documents. It might be an internal schedule code, a table reference, a field in a particular software system, or a label specific to a lender’s paperwork. Without the document or system that uses it, it would be inaccurate to assign E12 a precise definition.

If you saw the label on a loan statement, contract, servicing portal, spreadsheet, or calculator, check the nearby headings, footnotes, and glossary. The lender or document issuer can explain what that code denotes and whether it describes a repayment frequency, a payment option, a fee category, or something else. Do not assume that E12 means 12 payments, a 12-month schedule, or a particular prepayment penalty; those interpretations are not established by the label itself.

How to Read a Prepayment Schedule

A conventional amortization schedule breaks each scheduled payment into interest and principal. Early in a loan, more of a level payment generally goes toward interest because interest is calculated on a larger outstanding balance. As the balance declines, the interest portion tends to fall and the principal portion rises. A prepayment schedule adds extra principal payments or earlier payment dates to show how those changes affect the balance and payoff timing.

This calculator provides the baseline monthly payment and aggregate interest, not a month-by-month table and not an extra-payment payoff date. To evaluate an actual schedule, compare the scheduled payment, extra principal, payment date, interest charged, and remaining balance for each period. For example, an extra principal amount applied early may reduce later interest under a simple-interest amortization structure, but the exact outcome depends on how the loan accrues interest and how the servicer applies the payment.

Using the Estimate Carefully

  • Enter the APR as a percentage. Type 8 for 8%, not 0.08. The formula converts it to a monthly rate.
  • Use the full loan term in years. The calculation multiplies years by 12; it does not accept a number of months in this field.
  • Separate principal from total borrowing cost. If an amount financed includes fees or other charges, the calculator treats the entire entered amount as principal and does not identify the fee portion.
  • Do not treat the result as a statement quote. Daily interest, irregular first periods, payment dates, rounding conventions, and contract terms can change a real schedule.
  • Confirm payment application. A payment above the amount due may be handled differently depending on the loan’s instructions and servicing process. Ask the lender how to designate extra money as principal and whether any contractual limits or charges apply.

A frequent misconception is that making an extra payment automatically changes the required monthly payment. In many amortizing arrangements it may instead shorten the payoff period while the scheduled payment stays the same, but the contract and servicing treatment control. This calculator does not model either outcome for extra payments; it assumes the original level payment and term.

Limits and Related Calculations

The formula is designed for a fixed APR, regular monthly periods, and equal payments. It is not suitable as-is for a variable-rate loan, interest-only period, balloon payment, irregular payment calendar, or a loan with fees included in a separate APR calculation. A zero APR is not accepted because this calculator’s payment expression divides by a rate; a zero-interest loan can instead be calculated by dividing principal by the number of payments.

To model a true prepayment schedule, the calculation needs more information: the starting balance, rate convention, required payment, dates or intervals, extra-payment amount and timing, and any rules for how payments are credited. With those details, each period can be calculated by applying interest to the current balance, subtracting the payment allocated to interest, then reducing principal by the remainder and any extra principal. A lender’s own amortization or payoff statement is the source for contractual figures.

Frequently Asked Questions

Is E12 a standard prepayment schedule code?
No universal definition is established by the label alone. Its meaning depends on the document, lender, or software where it appears, so ask the issuer for its definition.

Does this calculator show when extra payments will pay off my loan?
No. It estimates the regular payment and interest for the original term. It does not accept extra-payment amounts or calculate a revised payoff date.

Does prepayment always reduce the monthly payment?
Not necessarily. An extra principal payment may reduce the balance and interest over time without changing the scheduled payment. The contract and the servicer’s payment treatment determine the actual result.

Why could my lender’s total interest differ?
The lender may use different payment dates, daily interest accrual, rounding, fees, or a final adjusted payment. This estimate assumes regular monthly periods and a cent-rounded level payment.

Where can I find what E12 means on my paperwork?
Look for a nearby definition, legend, or schedule notes, then contact the document issuer or loan servicer with the page and field label. The code should not be interpreted without that context.

This result is an estimate for educational purposes, and the lender’s disclosure gives 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 | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | 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

The whole Loan payments section →