An amortization schedule shows how a fixed monthly loan payment is divided between interest and principal over time. Enter the loan amount, annual APR, and term to calculate the monthly payment and estimated total interest; this calculator gives the payment amount, not a month-by-month schedule.
Formula
The calculator uses the standard fixed-payment amortization formula. It first calculates an unrounded level payment from the loan principal and monthly interest rate, then displays the payment to the nearest cent.
Monthly payment: M = P × r ÷ [1 − (1 + r)−n]
- M is the calculated monthly principal-and-interest payment, in dollars.
- P is the starting loan principal, in dollars.
- r is the monthly interest rate as a decimal, calculated as APR ÷ 1,200. For an APR of 8%, r = 8 ÷ 1,200.
- n is the number of monthly payments, calculated as the loan term in years × 12.
Total interest: I = Mc × n − P, where Mc is the monthly payment rounded to cents. Using the rounded payment here means the displayed total follows the payment amount shown. Actual lender accounting may produce a slightly different final payment or total because of rounding and payment dates.
Worked Example
Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term:
- Convert APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667.
- Convert the term to monthly payments: n = 5 × 12 = 60.
- Substitute into the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
- The payment is about $405.53 per month when rounded to cents.
- Total interest using the displayed payment is $405.53 × 60 − $20,000 = $4,331.80.
Assumptions
- The interest rate stays fixed for the full term.
- Payments are equal monthly payments made at the end of each monthly period.
- Interest accrues monthly using APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, and escrow because none are calculator inputs.
How an Amortization Schedule Works
Each scheduled payment covers interest accrued since the previous payment and reduces the remaining principal by whatever is left. Early in a typical fully amortizing loan, the balance is large, so the interest portion tends to be larger. As principal is paid down, later payments generally contain less interest and more principal. With a fixed rate and unchanged payment timing, the total scheduled payment remains level, although the split changes.
A full schedule lists each payment period, the opening balance, interest charged, principal repaid, and closing balance. This calculator summarizes the regular payment and estimated total interest for the whole term. It does not generate the individual rows, so it cannot show a particular month’s balance or interest amount.
When to Use the Estimate
Use the calculation to understand the basic payment implied by a principal, APR, and term, or to see how changing one of those inputs changes the mathematical result. Enter the principal amount being financed, rather than a property or vehicle price if a down payment or other amount changes what is borrowed. Use the APR supplied for the loan estimate or disclosure; do not assume a sample rate is an offer.
The result is principal and interest only. If a lender collects other amounts with a monthly bill, the total cash payment can be higher. For a real loan, compare the calculator’s assumptions with the lender’s stated payment, APR, amount financed, payment count, and any separate charges.
Common Mistakes and Limits
- Mixing annual and monthly rates: The input is an annual percentage rate. The formula divides it by 1,200 to obtain a monthly decimal rate; entering 0.08 to represent 8% would instead mean 0.08% APR.
- Confusing term units: This calculator asks for years and converts them to months. A five-year term means 60 scheduled monthly payments.
- Expecting total cost in the payment: The calculated amount excludes taxes, insurance, escrow, and fees. It is not necessarily the amount due each month.
- Assuming every loan amortizes evenly: Variable-rate loans, interest-only periods, balloon payments, irregular payment dates, and additional payments do not follow this simple fixed-payment pattern throughout.
- Ignoring rounding: The formula’s theoretical payment is rounded to cents. A lender may adjust a final payment or calculate interest using specific dates and its own rounding conventions.
The formula assumes the payment is enough to repay principal and interest over the stated number of periods. It does not model a changing rate, late payments, missed payments, fees added to the balance, or extra principal payments. For those situations, a lender’s detailed amortization schedule is more informative.
Frequently Asked Questions
Is the monthly payment on an amortization schedule known?
For a fixed-rate, fully amortizing loan with a known principal, APR, and term, the scheduled principal-and-interest payment can be calculated in advance. The payment amount may differ if the rate, balance, payment timing, or loan terms change.
Does the monthly payment include interest?
Yes. The calculated payment includes both principal repayment and interest. It does not include costs such as insurance, taxes, escrow, or fees unless those are separately included in a lender’s quoted payment.
Why does more of the payment go to interest at the beginning?
Interest for each period is based on the outstanding principal. The initial balance is highest, so the interest portion is usually greatest near the start. As principal falls, the interest portion generally declines.
Does making an extra payment change the schedule?
Extra principal payments can reduce the balance faster and change how much interest accrues later. The effect on the loan’s term or required payment depends on the loan terms and how the lender applies the extra amount; this calculator does not model extra payments.
Why might a lender’s payment differ from this result?
The lender may use different timing, rounding, fees, or loan terms, or may include other monthly charges in the quoted amount. Check the payment breakdown and assumptions in the lender’s disclosure.
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
- Weekly Payment Sheet: Calculate Loan Payments$93.39
- Weekly Payment Schedule Calculator$93.39
- Weekly Loan Payment Calculator and Formula$93.39
- Weekly Payment Run: Meaning and How It Works
- DXC Weekly Payment Reimbursement Request Form
- Weekly Payment Reimbursement Request Form Explained