calculate-loan

01 Loan payments

Amortized Schedule of Payments: Formula and Example

Calculator No. 01-14499 · 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.

An amortized schedule of payments shows how each scheduled loan payment is divided between interest and principal, and how the remaining balance changes over time. Enter the loan amount, annual percentage rate (APR), and term below to calculate the fixed monthly payment and total interest; the schedule mechanics and a worked example explain how to read the results.

Formula

For a fixed-rate loan with equal monthly payments, the level-payment formula is M = P × r / (1 − (1 + r)−n). Here, M is the monthly payment in dollars, P is the starting principal or loan amount in dollars, r is the monthly interest rate as a decimal (APR ÷ 1,200), and n is the number of monthly payments (years × 12). Total interest in this calculator is I = M × n − P, using the payment rounded to cents.

The formula calculates the payment needed to repay the stated principal and interest over the stated term under its assumptions. It does not produce every row of the schedule by itself, but the rows follow a recurring calculation: interest for the period is based on the outstanding balance, and the remainder of that period’s payment reduces principal.

Worked Example

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

  1. Convert APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
  2. Find the payment count: 5 × 12 = 60 months.
  3. Substitute into the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60]. The unrounded result is about $405.53, so the monthly payment is $405.53.
  4. Calculate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The payment stays level in this simplified example, but the allocation changes. The first month’s interest is $20,000 × 0.0066667, or about $133.33. The rest of the $405.53 payment—about $272.20—reduces principal. After that payment, the balance is about $19,727.80. In the next month, interest is calculated on that lower balance, so a larger share of the same payment goes to principal.

How an Amortization Schedule Works

An amortization schedule is a dated or numbered list of payment periods. A standard row generally shows the starting balance, payment, interest charge, principal reduction, and ending balance. To build a row, multiply the balance at the start of the period by the periodic interest rate. Subtract that interest from the payment to find principal repaid, then subtract principal repaid from the balance.

For example, if a period begins with a $19,727.80 balance at a monthly rate of 0.0066667, its interest is approximately $131.52. With a $405.53 payment, about $274.01 goes to principal, leaving a balance of roughly $19,453.79. Small differences can appear if figures are rounded at each step; a lender’s system may retain more decimal places internally.

Early payments typically contain a larger interest portion because the balance is larger. As the balance declines, the interest charge generally declines too, leaving more of each level payment to reduce principal. The schedule reaches approximately zero after the final payment, subject to rounding and the lender’s actual calculation method.

Reading the Results and Using a Schedule

The calculator’s monthly payment is the modeled amount for principal and interest, while total interest is the sum of those payments minus the original principal. A schedule adds useful timing detail: it can show how much principal remains after a particular number of payments and how the interest-versus-principal split evolves.

People commonly use an amortization schedule to understand a loan’s repayment path, check a quoted payment, or estimate the effect of a payment date on the outstanding balance. For a real loan, use the lender’s disclosed amount, APR, term, payment frequency, and payment dates. If a quoted payment differs, check whether it includes fees or other charges, whether the term is expressed in whole months, and how the lender handles rounding and payment timing.

A standard schedule assumes payments arrive as planned. A late payment, skipped payment, variable rate, additional principal payment, or a change in the amount owed can alter later rows. The calculator here does not generate dates or an itemized schedule; it provides the level monthly payment and total interest for the inputs.

Common Misunderstandings and Limits

  • Payment is not the same as total borrowing cost. The calculated payment covers modeled principal and interest only. Fees, taxes, insurance, escrow, and other charges are not included.
  • APR is not entered as a decimal. Enter 8 for 8%, not 0.08; the formula divides the APR input by 1,200 to get the monthly decimal rate.
  • Interest is not a fixed share of every payment. In a level-payment loan, the interest component usually changes as the balance changes.
  • Rounding affects totals. This calculator rounds the monthly payment to cents and uses that rounded amount to calculate total interest. A lender may use more precise internal values, so its final figures can differ slightly.

The calculation uses a fixed APR and regular monthly periods. It does not model variable rates, irregular first periods, daily interest accrual, payment holidays, fees added to principal, or extra payments. If the loan’s terms use a different schedule or calculation convention, this estimate will not reproduce the lender’s complete ledger.

Assumptions

  • The interest rate is fixed for the entire modeled term.
  • Payments are equal, monthly, and made at the end of each monthly period.
  • Interest compounds monthly at APR ÷ 12, represented as APR ÷ 1,200 when APR is entered as a percentage.
  • Fees, taxes, insurance, PMI, and escrow are not included; no input for them is provided.

Frequently Asked Questions

What is an amortized schedule of payments?
An amortized payment schedule lists each installment and shows how much goes to interest, how much reduces principal, and what balance remains afterward.

How do I calculate the monthly payment on an amortizing loan?
Use the fixed-payment formula M = P × r / [1 − (1 + r)−n], where the monthly rate is APR divided by 1,200 and the number of payments is the term in years multiplied by 12.

Why does more of the payment go to interest at the beginning?
Interest for each period is calculated on the outstanding balance. The balance is largest at the start, so the interest charge generally falls as principal is repaid.

Does an amortization schedule include taxes and insurance?
Not necessarily. A principal-and-interest schedule excludes those costs unless they are separately added. This calculator includes only modeled principal and interest.

Can extra payments change the amortization schedule?
Yes. An extra amount applied to principal can reduce the balance and change later interest and repayment timing. This calculator assumes only the regular level payment, so it does not calculate that effect.

This result is an estimate; 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 →