An amortization schedule based on payment amount shows how each payment is divided between interest and principal, and how the loan balance changes over time. Enter the loan amount, APR, term, and—if you need to model a different payment—the payment amount; this calculator estimates a fixed monthly payment and totals for a standard fully amortizing loan.
Formula
This calculator produces the level monthly payment used to build a conventional amortization schedule. The payment formula is:
PMT = P × r ÷ [1 − (1 + r)−n]
- P is the starting principal, in dollars.
- r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
- n is the number of monthly payments, calculated as loan term in years × 12.
- PMT is the monthly payment in dollars, rounded to the nearest cent.
Total interest in the displayed estimate is PMT × n − P. The calculator assumes that the rounded monthly payment is made for every scheduled month. An actual lender’s schedule may differ because of payment dates, daily interest, fees, payment adjustments, or rounding rules.
Worked Example
Using the default inputs—$20,000 principal, 8% APR, and a five-year term—first convert the annual rate to a monthly rate and the term to months:
- Monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667%.
- Number of payments: 5 × 12 = 60.
- Payment: 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53 per month, rounded to cents.
- Total of scheduled payments: $405.53 × 60 = $24,331.80.
- Estimated total interest: $24,331.80 − $20,000 = $4,331.80.
The calculator’s headline result is a monthly payment of $405.53; its total-interest result is $4,331.80.
Assumptions
- The interest rate is fixed for the full term.
- Payments are equal, monthly, and made at the end of each period.
- Interest accrues monthly using APR divided by 12.
- Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.
How an Amortization Schedule Works
An amortization schedule is a month-by-month record of a loan’s opening balance, payment, interest charge, principal repaid, and closing balance. For each period, interest is calculated on the balance before the payment. The payment first covers that interest; the rest reduces principal.
For example, with a $20,000 balance and a monthly rate of 0.66667%, the first month’s interest is about $133.33. From a $405.53 payment, about $272.20 therefore reduces principal, leaving an estimated balance of $19,727.80. In later months, interest generally takes a smaller share because it is charged on a lower balance. The payment stays level under the assumptions, while its interest and principal portions change.
A schedule can be generated by repeating these steps for each month: multiply the opening balance by the periodic rate to find interest, subtract interest from the payment to find principal repaid, and subtract principal repaid from the opening balance. In practice, amounts are rounded according to the lender’s method, so the last payment may be adjusted slightly to clear the remaining balance.
Using a Payment Amount to Build a Schedule
The phrase “based on payment amount” can mean two different calculations. This page calculates the standard payment required to repay a stated principal over a stated term at a stated APR. If you already know the payment and want to see the resulting payoff time, the inputs must instead include that payment amount; this calculator does not infer a term or schedule from a custom payment.
To make a schedule for a known payment, use the balance-and-interest process above each month. Check that the payment is greater than that month’s interest. If it is equal to interest, the balance does not decline; if it is less, unpaid interest can cause the balance to grow, depending on the loan’s terms. A custom payment also needs a clear rule for how extra money is applied, since it might reduce principal, cover charges, or be treated as an early payment.
For a standard schedule using this calculator, enter the principal, APR supplied in the loan documents or by the lender, and the agreed term. The results are mathematical estimates, not a substitute for the lender’s payment schedule or disclosure.
Reading Results and Avoiding Common Errors
- APR versus monthly rate: Enter APR as a percentage such as 8, not as 0.08. The formula divides by 1,200 to obtain the monthly rate.
- Years versus months: The term field is in years. A five-year term means 60 monthly payments, not five payments.
- Principal versus total loan cost: Principal is the amount borrowed. Total scheduled payments include principal and interest; they do not necessarily include loan-related charges.
- Rounding: A displayed payment rounded to cents may produce a small difference from a schedule calculated with unrounded amounts. Lenders may use their own rounding and final-payment adjustments.
- Changing rates or payment dates: A variable rate or irregular payment timing does not fit the fixed-rate, equal-monthly-payment assumptions.
The payment is not the same as the principal reduction. Early in a fully amortizing loan, a larger share of each payment commonly goes to interest than in later periods. Comparing total interest also requires comparing the assumptions: a different term, rate, payment timing, or fee treatment can change the result.
Limits and Related Calculations
This calculation describes level-payment amortization, a common mathematical model for installment loans. It does not establish the amount a lender will charge or whether a loan will be approved. For an exact schedule, obtain the lender’s principal, APR, payment amount, due dates, and treatment of fees and extra payments. If you want to model additional principal payments, calculate each month from the actual opening balance and payment allocation rather than assuming the original schedule still applies.
The estimate also assumes the stated term runs for a whole number of monthly periods. Real contracts may use different day-count conventions, a first payment period that is longer or shorter than a month, or a final payment that differs from the regular payment. These details matter most when reconciling a calculator with a statement or payoff quote.
Frequently Asked Questions
How do I calculate an amortization schedule from a payment amount?
For each period, calculate interest as the opening balance multiplied by the periodic rate, subtract that interest from the payment to find principal repaid, then subtract principal from the opening balance. Repeat until the balance reaches zero, adjusting the final payment if needed.
Why does more of my payment go to interest at the beginning?
Interest is calculated on the outstanding balance. That balance is largest at the start, so the interest portion is usually larger; as principal is repaid, the interest portion generally falls.
Can a payment amount be too low to pay off the loan?
Yes. If a payment is no greater than the period’s interest, it may not reduce principal. The balance can remain level or increase, depending on how the loan handles unpaid interest.
Does an amortization schedule include fees and insurance?
Not in this calculator. It models principal and interest only; fees, taxes, insurance, PMI, and escrow require separate figures and may be handled differently by a lender.
Why is my lender’s schedule slightly different?
Differences can result from rounding, payment dates, daily rather than monthly interest calculations, fees, or a final-payment adjustment. Use the lender’s disclosed schedule for contract-specific figures.
This result is an estimate, 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
- Amortization Schedule by Month: Payment and Balance$405.53
- Amortization Schedule by Hand: Formula and Example$405.53
- Amortization Schedule Calculator: Payments and Balance$405.53
- Auto Loan Amortization Schedule Calculator$405.53
- Adjustable Rate Amortization Schedule Calculator$405.53
- Amortization Schedule: Annual Payments in Excel$5,009.13