How to Use the Amortization Calculator
Follow these four steps to model your loan repayment schedule, analyze payment splits, and evaluate early payoff strategies:
Enter Loan Terms
Input the loan principal amount, the annual interest rate (%), and the repayment term in years and additional months.
Select Start Month and Year
Choose the first payment month and year to map the schedule onto exact calendar dates for each billing cycle.
Add Optional Extra Payments
Check the extra payments box to test extra monthly, extra yearly, or one-time lump-sum principal prepayments and set their start dates.
Calculate and Review Results
Inspect the monthly payment, total interest, payoff date, visual charts, and export the annual or monthly schedule to CSV, Excel, or PDF.
What an Amortization Schedule Shows
An amortization schedule is an itemized table that tracks each scheduled payment across the life of a loan from origination to a zero ending balance. For loan repayment, the schedule displays the exact distribution of every scheduled payment across the life of the loan:
The sequential installment index (from payment 1 through payment n) and the corresponding calendar month and year.
The outstanding principal debt remaining at the start of the billing period before the scheduled payment is applied.
The total periodic installment due, consisting of scheduled principal and accrued interest, plus any optional extra prepayment made in that cycle.
The exact mathematical allocation showing how much goes toward satisfying borrowing costs (interest) and how much reduces the loan balance (principal).
Any additional money applied directly toward balance reduction beyond the required scheduled monthly installment.
The remaining principal at the end of the period, which carries over directly as the beginning balance for the subsequent billing cycle.
The calculator offers two synchronized views: an Annual Schedule summarizing principal paid, interest paid, and year-end balance for each 12-month period, and a Monthly Schedule detailing every individual billing cycle with interactive search, sorting, and pagination.
How Loan Payments Split Between Principal and Interest
For a standard fixed-rate loan, the scheduled principal-and-interest payment is generally constant throughout the repayment term. The portion allocated to interest decreases as the principal balance falls, while the portion allocated to principal increases. The final payment can be adjusted to clear the remaining balance, and additional payments can change the payoff date and remaining schedule.
Because periodic interest is calculated directly from the outstanding debt balance (Interest = Balance × Monthly Rate), interest charges are highest during early payments when the principal balance is at its peak. As each monthly payment satisfies the accrued interest and applies the remainder toward principal reduction, the outstanding balance decreases. In each subsequent month, interest is calculated on that smaller remaining balance, accelerating equity growth over the life of the loan.
Start Date Distinction: This educational reference example explicitly fixes the loan origination date to January 2026, resulting in a scheduled payoff in December 2040 (180 months). By contrast, the live interactive calculator above automatically defaults to your current calendar month and year upon load, computing an initial payoff date 15 years forward from today unless you manually select January 2026.
Rounding Policy: The monthly installment is rounded for display to the nearest cent ($1,687.71). Multiplying $1,687.71 × 180 equals $303,787.80. The actual accumulated total paid modeled by the amortization engine is $303,788.46 (a difference of 66 cents) because the engine tracks full floating-point precision throughout the schedule and applies an exact reconciliation adjustment in the 180th month (final payment of $1,687.71 split as $1,679.31 principal and $8.40 interest) so the ending balance terminates at exactly $0.00.
| Period | Beginning Balance | Payment | Interest Paid | Principal Paid | Ending Balance |
|---|---|---|---|---|---|
| Month 1 (Jan 2026) | $200,000.00 | $1,687.71 | $1,000.00 | $687.71 | $199,312.29 |
| Month 12 (Dec 2026) | $192,243.19 | $1,687.71 | $961.19 | $726.52 | $191,516.67 |
| Month 180 (Dec 2040) | $1,679.31 | $1,687.71 | $8.40 | $1,679.31 | $0.00 |
See How Extra Payments Change Your Loan
When you make an additional payment beyond your scheduled monthly installment, 100% of that extra amount reduces the principal balance immediately. Because monthly interest charges depend directly on the remaining debt, lowering the principal cuts the interest owed in every future period. This compounding reduction accelerates the loan toward payoff and eliminates thousands of dollars in lifetime borrowing costs.
Extra Monthly Payments
Adding a fixed extra amount to every monthly payment compounds savings continuously across every billing cycle.
- Loan payoff shortens from 180 months to 165 payments (paid off 15 months / 1 year and 3 months early in September 2039).
- Total interest paid drops from $103,788.46 to $93,759.99.
- Net interest savings: $10,028.47.
- Total extra principal invested: $16,423.63.
Extra Yearly Payments
An annual extra payment allows borrowers who receive annual bonuses, tax refunds, or seasonal distributions to apply a lump sum once per year in a designated month.
- Loan payoff shortens from 180 months to 164 payments (paid off 16 months early in August 2039).
- Total interest paid drops from $103,788.46 to $93,050.91.
- Net interest savings: $10,737.55.
- Total extra principal invested: $16,800.00.
One-Time Lump-Sum Payments
A single lump-sum prepayment immediately retires a block of principal in the selected month and year. In addition to the primary one-time extra payment, the calculator includes a “More one-time payments” feature allowing you to schedule up to 10 distinct prepayments across future dates.
- Loan payoff shortens from 180 months to 173 payments (paid off 7 months early in May 2040).
- Total interest paid drops from $103,788.46 to $96,765.17.
- Net interest savings: $7,023.29.
Starting Extra Payments Later
Payment timing is a critical factor in amortization savings. An extra principal payment made early in a loan saves substantially more interest than the identical prepayment made years later because the lower balance avoids interest accrual across far more compounding cycles.
The calculator provides dedicated start month and year selectors for extra monthly and extra yearly payments. This enables borrowers to model realistic financial transitions—such as waiting for career promotions, college graduations, or the payoff of other debts—before initiating accelerated loan payments.
How Amortization Is Calculated
This calculator uses a standard fixed-rate loan amortization formula. It estimates the periodic principal-and-interest payment from the loan principal, annual interest rate, and repayment term. It then models the interest, principal reduction, and ending balance for each period. Additional payments are applied according to the selected schedule and the calculator's timing rules.
The step-by-step mathematical algorithm proceeds as follows:
- Periodic Monthly Interest Rate (r): The annual percentage rate is converted to a monthly decimal rate:r = Annual Rate / (12 × 100)
- Total Scheduled Periods (n): The loan tenure is converted to the total number of monthly payments:n = (Years × 12) + Months
- Scheduled Monthly Payment (M): When interest rate is greater than 0, the fixed monthly installment is calculated using the standard annuity formula:M = P × [r × (1 + r)^n] / [(1 + r)^n - 1]For zero-interest loans (r = 0), the payment is simply principal divided by total periods:M = P / n
- Period Interest Charge (Ik): For payment cycle k, interest is computed on the beginning balance of that period:Ik = Beginning Balancek × r
- Principal Reduction and Balance Clamping: Scheduled principal is deducted (Pk = M - Ik), any applicable extra prepayment is added, and the remaining balance is updated. In the final payment period, payments are clamped so the ending balance terminates at exactly $0.00 without negative balance overruns.
What This Calculator Includes and Excludes
Included in Calculations:
- Fixed-rate loan amortization math with monthly compounding.
- Scheduled monthly principal and interest (P&I) installment.
- Custom loan start month and year tracking.
- Extra monthly, extra annual, and one-time lump-sum prepayments.
- Delayed start dates for extra payment schedules.
- Up to 10 additional one-time prepayments across custom dates.
- Annual summary and monthly itemized amortization tables.
- Exporting schedule data to CSV, Excel, and PDF/Print.
Excluded from Calculations:
- Property taxes, hazard insurance, and flood insurance held in escrow.
- Private Mortgage Insurance (PMI) or FHA mortgage insurance premiums.
- Homeowners Association (HOA) dues and condo fees.
- Lender origination fees, discount points, closing costs, and per diem interest.
- Adjustable-Rate Mortgages (ARMs with floating indices, margins, and rate caps).
- Biweekly payment scheduling (26 biweekly half-payments per year).
- Negative amortization, balloon payments, and interest-only grace periods.
- Official lender payoff quotes (which depend on per diem daily interest posting).
Amortization Calculator FAQs
Related Financial Calculators
Explore our suite of specialized debt, financing, and real estate tools to evaluate related borrowing scenarios: