Amortization Schedule Calculator

Background.

An amortization schedule is a complete table of every periodic loan payment, showing exactly how much goes toward interest and how much reduces the principal balance. Homebuyers, real estate investors, and loan officers rely on this schedule to understand the true cost of borrowing over time. Unlike a simple payment calculator that returns only the monthly amount, an amortization schedule reveals the front-loaded nature of interest: in the early years of a 30-year mortgage, most of each payment covers interest, while only a small fraction reduces the principal. This pattern reverses in the final years, when principal dominates.

The mathematics behind amortization comes from the present value of an ordinary annuity. Lenders use this formula because it ensures each payment is identical, making budgeting predictable for borrowers. The schedule is also a critical tool for comparing loan offers. Two mortgages with the same monthly payment can have dramatically different total interest costs if their terms or rates differ. For example, a 15-year mortgage at the same interest rate as a 30-year mortgage will have a higher monthly payment but substantially lower total interest.

Amortization schedules are not limited to home loans. Auto loans, student loans, and business term loans all use the same mathematics. Some loans, such as adjustable-rate mortgages, require a recast schedule whenever the rate changes. The Consumer Financial Protection Bureau (CFPB) requires lenders to provide amortization disclosures under the Truth in Lending Act (TILA) and the Real Estate Settlement Procedures Act (RESPA), ensuring borrowers see the full cost before closing. Understanding the schedule empowers borrowers to evaluate prepayment strategies in practice, such as making extra principal payments in year one to reduce lifetime interest. Biweekly payment plans, which make 26 half-payments per year instead of 12 full payments, can shorten a 30-year mortgage by four to five years and save tens of thousands in interest. The schedule also helps borrowers identify the optimal time to refinance: when the remaining balance has declined sufficiently that a lower rate produces meaningful savings.

The history of amortization traces back to the development of actuarial mathematics in the 18th century. The annuity formula used today was formalized in the early 20th century and became standard for mortgage lending after the Great Depression, when the federal government sought to replace risky balloon mortgages with fully amortizing loans. The modern 30-year fixed-rate mortgage, with its level payments and declining balance, was a revolutionary innovation that made homeownership accessible to millions of Americans. Today, amortization schedules are generated automatically by lending software, but understanding the underlying mathematics remains essential for financial literacy and informed decision-making. Borrowers who can read their schedule know exactly how much equity they have at any point in time, which is critical for decisions about selling, refinancing, or taking out a home equity loan. The schedule also reveals the point at which principal exceeds interest, typically around month 180 for a 30-year mortgage at 6%, giving borrowers a milestone to track their progress. This milestone, known as the crossover point, marks when equity accumulation accelerates meaningfully. Lenders and financial planners use amortization schedules to model prepayment strategies, refinance timing, and the long-term wealth impact of different loan structures.

What is amortization schedule?

Amortization is the process of paying off a debt over time through regular, equal payments. Each payment covers the interest accrued since the last payment plus a portion of the original principal. An amortization schedule is the detailed table listing every payment, its interest and principal components, and the remaining balance. The schedule is fully determined by four variables: the loan amount, the interest rate, the number of payments, and the payment frequency. For fixed-rate loans, the schedule never changes unless the borrower makes additional principal payments or refinances. Adjustable-rate mortgages, interest-only loans, and graduated-payment mortgages require modified schedules that account for changing payments or rates.

Amortization differs from simple interest, where the total interest is calculated upfront and divided equally across payments. In simple interest loans, early payments do not reduce principal faster than later payments. Amortization, by contrast, front-loads interest and back-loads principal, creating the characteristic declining balance curve. This structural difference means that amortizing loans always cost less in total interest than simple interest loans of the same amount, rate, and term, because principal reduction compounds over time. The amortization process is also distinct from balloon loans, where the borrower makes small periodic payments and then pays a large lump sum at maturity. Balloon loans do not fully amortize and therefore carry refinancing risk at the end of the term.

How to use this calculator.

1. 01Enter the total loan amount you borrowed or plan to borrow.
2. 02Input the annual interest rate as a percentage (APR).
3. 03Select the loan term in years—30 and 15 are common for mortgages.
4. 04Optionally set the start date to see calendar-specific payoff dates.
5. 05Click calculate to generate the full payment-by-payment schedule.
6. 06Review the monthly payment, total interest, and total cost summary.
7. 07Scroll through the schedule table to see principal and interest for any month.

The formula.

The monthly payment formula derives from equating the loan principal to the present value of all future payments. For an ordinary annuity—payments at the end of each period—the present value factor is [1 − (1 + r)⁻ⁿ] / r. Solving for payment M gives M = P × r / [1 − (1 + r)⁻ⁿ], which algebraically rearranges to the more common form M = P × [r(1 + r)ⁿ] / [(1 + r)ⁿ − 1]. Both forms are mathematically identical.

The interest portion of any payment is always the prior balance multiplied by the periodic rate. This is why early payments are interest-heavy: the balance is largest at the start. As the balance declines, so does the interest charge, leaving more of each fixed payment for principal reduction. This creates the characteristic convex curve of an amortization schedule.

Dimensional analysis confirms the formula's validity: P is in dollars, r is dimensionless (rate per period), and the bracketed term is dimensionless, so M is in dollars. The exponent n must be dimensionless, which it is because it counts periods. The formula fails only when r = 0, which is excluded by validation.

The schedule generation process iterates through each payment period. For month k, the interest charge is the prior balance multiplied by r, the principal portion is M minus the interest charge, and the new balance is the prior balance minus the principal portion. This iterative process continues until the balance reaches zero. Numerical precision matters: using floating-point arithmetic with at least six decimal places prevents rounding errors that could accumulate over hundreds of payments. The total interest is the sum of all interest charges, and the total cost is the sum of all payments plus any fees. All calculations should use consistent rounding conventions, typically rounding to the nearest cent at each step.

A worked example.

Frequently asked questions.

References& sources.

1. [1]CFPB (2023). "What is an amortization schedule?" Consumer Financial Protection Bureau.
2. [2]Federal Reserve (2023). "Consumer Handbook on Adjustable-Rate Mortgages."
3. [3]Bodie, Z., Kane, A., & Marcus, A.J. (2021). Investments, 12th ed. New York: McGraw-Hill. ISBN 978-1264118393.
4. [4]OCC (2023). "Truth in Lending Act — Regulation Z." 12 CFR Part 1026.
5. [5]CFPB (2015). "TILA-RESPA Integrated Disclosure Rule." 12 CFR Part 1026.
6. [6]HUD (2023). "Amortization Basics." U.S. Department of Housing and Urban Development.