An amortization schedule turns a loan's headline payment into a sequence of decisions and balances. Each row shows the payment, the interest charged for that period, the principal removed, and the balance left afterward. Our Amortization Calculator accepts a loan amount, annual interest rate, and term, then produces a summary and a month-by-month schedule. This guide focuses on reading and checking that schedule, rather than simply quoting a monthly payment.
The four columns that tell the story
The payment column is the scheduled amount for that month. Interest is usually the opening balance multiplied by the periodic interest rate. Principal is the payment minus that interest. The ending balance is the opening balance minus principal. In a standard fixed-payment loan, the scheduled payment is level while the interest portion gradually falls and the principal portion gradually rises.
A schedule is not the same thing as a payoff quote. A lender may calculate interest using daily accrual, apply payments on different dates, or include fees, escrow, and rounding rules. Use a schedule to understand the loan's structure and compare scenarios; use the servicer's statement or payoff quote for the exact amount due on a particular date.
Worked example: a 15-year, $250,000 loan
Consider a $250,000 fixed-rate loan at 6.5% for 15 years. There are 180 scheduled payments, and the monthly rate is 0.065 ÷ 12 = 0.0054167. The fixed-payment formula produces a monthly payment of approximately $2,177.77 before any taxes, insurance, or other charges.
- At the opening balance, one month's interest is $250,000 × 0.0054167 = $1,354.17.
- Principal in month one is $2,177.77 − $1,354.17 = $823.60.
- The month-one ending balance is $250,000 − $823.60 = approximately $249,176.40.
- Month-two interest is about $249,176.40 × 0.0054167 = $1,349.71, so roughly $828.06 of that payment reduces principal.
Across all 180 scheduled payments, the rounded model pays approximately $391,998.31, including about $141,998.31 of interest. Adding the principal and interest columns should reconcile to that total within small rounding differences. This is a useful check: if a hand-built table says otherwise, look first for a percentage-versus-decimal error or a missed payment period.
Why early payments feel interest-heavy
The loan does not decide to “front-load” interest as a separate penalty. Interest is larger early because the balance is largest early. In month one of the example, interest is about 62% of the payment. Near the end, the balance is small, so nearly all of the scheduled payment can go to principal. The payment remains steady only because the calculation intentionally shifts the split over time.
If you only need a monthly payment and not a full table, the Payment Calculator is a faster comparison tool. For a mortgage budget that also includes property tax and insurance, use the Mortgage Calculator. Keeping those purposes separate helps prevent a principal-and-interest schedule from being mistaken for a complete housing budget.
What an extra principal payment changes
An extra principal payment lowers the balance on which future interest is calculated. It does not automatically reduce the scheduled payment on every loan; often, it shortens the payoff time instead. Confirm with the servicer that an additional amount is applied to principal and check whether the loan has any prepayment terms. Payment timing also matters: money applied earlier has more future interest to avoid.
Using the example as a simple illustration, suppose the borrower pays $150 extra each month and the lender applies it directly to principal. A month-one payment of $2,327.77 would contain the same $1,354.17 of interest but about $973.60 of principal. Continuing that extra amount pays the modeled balance in roughly 162 months instead of 180 and reduces modeled interest from about $141,998 to about $125,605—a difference near $16,393. The final payment would be smaller than a full scheduled payment, so treat the totals as an estimate and verify the lender's rules.
How to use a schedule to test a plan
- Enter the original balance, annual rate, and term exactly as stated in the loan documents.
- Record the baseline payment, total interest, and balance after a chosen month, such as month 12 or month 60.
- Decide whether extra money is affordable after emergency savings and higher-cost debt are addressed.
- Ask the servicer how to designate an extra amount as principal-only and whether payment dates affect interest.
- Compare the expected time and interest saved with the loss of liquidity: money sent to a loan cannot always be retrieved easily.
The Consumer Financial Protection Bureau explanation of amortization describes why early loan payments can contain more interest. For mortgage-specific questions, its mortgage resource center is a better reference than assuming every loan follows the same servicing rules. Fannie Mae also documents how servicers process additional principal payments; the exact policy for your loan may differ.
Common schedule-reading mistakes
- Expecting the payment to equal the total housing bill: A loan schedule generally excludes escrow, association dues, and maintenance.
- Assuming rounding errors mean the formula failed: Currency is rounded for display, while the underlying balance may use more precision.
- Applying an extra payment to the next due date instead of principal: Ask the servicer how it will be allocated.
- Comparing loans by payment alone: Term length and total interest are equally important.
- Ignoring variable-rate terms: A fixed-rate schedule cannot predict every future payment for an adjustable-rate loan.
The takeaway
An amortization schedule is a map: opening balance, interest, principal, payment, and ending balance should connect in every row. Work through the first two rows to verify the math, compare total interest rather than just the payment, and treat extra-principal savings as a scenario that depends on lender processing. Used alongside a Refinance Calculator when rates change, the schedule gives you a clearer basis for deciding whether a new rate, shorter term, or extra payment actually fits your plan.
Frequently asked questions
What is an amortization schedule?
It is a table showing each scheduled loan payment and how it is divided between interest and principal, along with the balance remaining after the payment. It shows how the balance declines over the term.
Why does the principal portion increase over time?
Interest for each period is based on the remaining balance. As the balance falls, the interest charge falls too. With a level scheduled payment, the amount left over for principal therefore grows.
Does paying extra principal always lower the monthly payment?
No. On many fixed loans it shortens the payoff time while the required payment remains the same. Ask the servicer how extra payments are applied and whether a formal recast is available.
Why can a calculator differ from my lender's payoff amount?
A calculator models the inputs you provide and may round monthly values. A lender's payoff can include daily interest through a specific date, fees, escrow adjustments, and contract-specific servicing rules.
