Loan Amortization Schedule: What It Shows

A loan amortization schedule shows how each scheduled payment is divided between interest and principal, and how the remaining balance changes over time. This calculator uses the loan amount, annual APR, and term to estimate the monthly payment and total interest for a fixed-rate loan with equal monthly payments.

Formula

The schedule is built by calculating a level monthly payment, then applying that payment period by period. The payment formula is:

Monthly payment = P × r / [1 − (1 + r)⁻ⁿ]

• P is the starting loan principal, in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. For example, 8% APR gives a monthly rate of 0.0066667.
• n is the total number of monthly payments: loan term in years × 12.

For each month, interest is generally calculated on the balance at the start of that period: interest = starting balance × r. The principal paid is the monthly payment minus that period’s interest. The new balance is the starting balance minus principal paid. Total interest in this calculator is the rounded monthly payment multiplied by the number of payments, minus the original principal.

Worked Example

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

1. Convert APR to a monthly rate: 8 ÷ 1,200 = 0.0066667.
2. Find the number of payments: 5 × 12 = 60.
3. Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = approximately $405.53 per month, rounded to the cent.
4. Calculate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

Thus, the calculator’s headline result is a monthly payment of $405.53; its second result is estimated total interest of $4,331.80. Actual schedules may show a small final-payment adjustment because lenders handle cents and payment dates according to their own accounting and disclosures.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal, made monthly, and treated as occurring at the end of each payment period.
• Interest compounds monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, late charges, and optional extra payments are not included.

What Each Schedule Entry Shows

A full amortization table usually has one row for each payment date or period. Typical columns include the payment number, amount paid, interest portion, principal portion, and balance after payment. Some tables also show cumulative interest and cumulative principal. The figures let a borrower see the progression that a single monthly-payment amount hides.

At the beginning of a level-payment loan, the balance is relatively high, so the interest portion is usually larger. As principal is repaid, interest is calculated on a smaller balance. If the payment amount and rate stay fixed, more of each later payment generally goes toward principal. This does not mean the lender charges a higher interest rate early on; it reflects the changing balance on which interest is calculated.

For the example, the first month’s approximate interest is $20,000 × 0.0066667, or $133.33. Of the $405.53 payment, about $272.20 therefore reduces principal, leaving a balance near $19,727.80. Subsequent rows repeat the calculation using the updated balance. Exact cents can vary with the lender’s payment-date and rounding method.

How to Read and Use the Results

The monthly payment is the scheduled principal-and-interest amount under the stated assumptions—not necessarily the complete amount due on a mortgage or other loan. A bill may include separate items such as insurance, taxes, or fees. Check the loan’s payment breakdown rather than treating this estimate as a full bill quote.

Total interest is the sum of the interest portions over the modeled term. It is not the total amount paid: the total scheduled payments equal principal plus interest in this simplified calculation. The balance column is useful for estimating how much principal remains after a given number of payments, but this calculator does not generate an individual month-by-month table.

An amortization schedule can help with tasks such as:

• Understanding how the payment is split between interest and principal.
• Tracing the modeled balance at different points in a loan term.
• Checking how term length and APR inputs affect payment and total interest estimates.
• Comparing the schedule’s assumptions with a lender’s payment disclosure.

Common Misunderstandings and Limits

A common misconception is that the entire payment reduces the loan balance. In a standard amortizing loan, the interest due for the period is paid first in the schedule calculation; only the remainder reduces principal. Another misconception is that a schedule predicts the exact amount on every future statement. It does not account for changes or events outside its inputs.

This formula is for a fixed-rate loan with equal monthly payments and a positive APR. It does not model variable rates, irregular payment dates, interest-only periods, deferred payments, balloon payments, daily simple-interest methods, or fees financed into the balance unless those amounts are included in the principal input. Extra principal payments would change later balances and generally require recalculating the schedule. APR may also include costs or be defined in a way that does not match the simple monthly rate assumption used here, so use the lender’s stated rate and payment details when checking a real loan.

Inputs and outputs are rounded for display. Rounding the monthly payment to cents before calculating total interest can produce a slightly different total from a schedule that carries more precision internally and adjusts the last payment. The calculator is an educational estimate, not a replacement for a loan contract, statement, or lender-provided amortization table.

Frequently Asked Questions

What does an amortization schedule show?
It shows each planned payment’s interest and principal portions, along with the loan balance after that payment. A schedule may also total principal and interest over time.

Why does more of the payment go to interest at first?
Interest is calculated on the outstanding balance. The balance is largest near the start of the loan, so the interest portion is generally larger then; as principal falls, the interest portion usually falls too.

Does the monthly payment include taxes and insurance?
Not in this calculator. It estimates scheduled principal and interest only. Taxes, insurance, escrow, PMI, and other charges can be separate parts of an actual bill.

Does paying extra change an amortization schedule?
Yes. An extra principal payment reduces the balance faster than the original schedule assumes, so later interest and balances change. This calculator does not include extra payments.

Why might my lender’s numbers differ?
The lender may use different APR details, payment dates, compounding or day-count conventions, fees, and rounding rules. Compare the loan’s disclosed terms and payment schedule for the exact figures.

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

Related

• Term Loan EMI Calculator in Excel: Formula and Example
• Revolving Term Loan Calculator: Payments and Interest
• Rupee Term Loan Calculator: Monthly EMI and Interest

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