Amortization Schedule Calculator — Monthly P&I Split + Payoff Date + Milestones

What is an Amortization Schedule?

An amortization schedule is the month-by-month breakdown of how each fixed loan payment splits between principal (debt reduction) and interest(the lender’s fee). The total monthly payment stays constant for the entire life of the loan, but the internal split shifts dramatically — early payments are almost entirely interest, and late payments are almost entirely principal. The schedule reveals when, exactly, that crossover happens.

Every fixed-rate, fully amortizing loan in the United States — mortgages, auto loans, federal student loans, personal loans, small-business term loans — uses this same schedule. Variable-rate (ARM) loans use the same math but the schedule resets each time the rate adjusts. The numbers you see on this calculator match the numbers your bank prints on its statement (within a dollar or two of rounding) because the underlying formula is identical.

For homeowners, the schedule is the single most useful piece of paper about the mortgage. It tells you how much of your next payment is actually paying down debt, what your remaining balance will be at any future month, exactly when the principal portion first exceeds the interest portion, and how an extra payment in any specific month accelerates the entire trajectory.

The Amortization Formula

Every line in the schedule comes from one closed-form formula plus a simple monthly recursion:

Monthly payment: EMI = P × r × (1+r)^n / ((1+r)^n − 1)
where P = principal, r = monthly rate (annual rate / 12 / 100), n = total monthly payments (term in years × 12).

Once the monthly payment is fixed, the schedule unrolls month by month:

1. Month-N interest= balance at start of month N × r.
2. Month-N principal= EMI − month-N interest.
3. End-of-month balance= start balance − month-N principal.
4. Repeat for the next month, using the new balance.

That’s it — the rest is bookkeeping. The same recursion produces the EMI shown on the loan EMI calculator and the full amortization schedule shown here.

Why Early Payments are Interest-Heavy

Interest is computed on the outstanding balance. In month 1 of a $400,000 mortgage at 7%, you owe interest on the full $400,000:

Month-1 interest = $400,000 × (7% / 12) = $400,000 × 0.005833 = $2,333.33.

Your fixed monthly payment on a 30-year term at 7% is $2,661.21. After paying the $2,333 of interest, only $327.88 remains to reduce principal. Your balance after month 1 is $399,672.12.

In month 2, you owe interest on $399,672.12 — very slightly less than the month before. The interest portion drops by about $1.91; the principal portion grows by the same $1.91. This continues every month for 360 months. By the time you reach the final payment, you owe interest on almost nothing — nearly the entire $2,661 goes to principal.

Worked Example: $400K @ 7% for 30 Years — First 12 Months

Concrete numbers for the first year of a $400,000 mortgage at 7% APR on a 30-year fixed (monthly payment: $2,661.21):

Total paid in year 1: $31,934.52. Of that, $27,870.27 (87.3%) was interestand only $4,063.25 was principal. After 12 months of $2,661 payments, the balance dropped only 1.0% — from $400,000 to $395,937. This is the front-loading effect that makes early-loan prepayments so high-leverage: a single $1,000 extra principal payment in month 1 eliminates 12 months of interest accumulation on that $1,000 going forward.

The Principal-Interest Crossover Point

At some point in every amortizing loan, the principal portion of each payment finally exceeds the interest portion. That month is the “crossover.” For a 30-year fixed mortgage at 7%, the crossover happens around month 230 (year 19). At 5%, it’s earlier — around year 16. At 9%, it’s later — around year 22.

Why this matters: the crossover is the inflection point of the loan. Before it, most of each dollar you send your lender just rents the principal for another month. After it, most of each dollar actually retires the debt. Borrowers who sell or refinance before the crossover have built remarkably little equity through their monthly payments alone — whatever home-price appreciation they got is essentially the entire equity story.

Extra Payments & Biweekly Schedules

Two of the most powerful (and most misunderstood) accelerators:

Extra principal payments

Every dollar of extra principal in month N eliminates the entire stream of interest that dollar would have generated for the remaining (360 − N) months. On a 30-year mortgage at 7%, $1 of extra principal in month 1 saves approximately $6.72 in lifetime interest. The same $1 prepaid in month 300 saves about $0.21. Early prepayment is roughly 32 times more powerful than late prepayment — not because of any magic, but because there’s far more future interest to eliminate when you start.

On a $400K loan at 7%, adding just $200/month to principal from day one shortens a 30-year mortgage by approximately 6 years and saves roughly $120,000in lifetime interest. That’s a 200%+ return on the $72,000 of extra payments made.

Biweekly payments — the actual math

The classic biweekly pitch: split your monthly payment in half, pay it every two weeks instead of monthly — you finish in 26 years instead of 30. Why? Not because you’re paying more frequently. Because 52 weeks / 2 = 26 half-payments per year = 13 full monthly payments per year. You’re making one extra full payment per year (entirely principal) without noticing.

On a $400K mortgage at 7%, a 30-year loan paid biweekly finishes in about 24.9 years and saves about $108,000. You can replicate the exact same effect without setting up biweekly: just add 1/12th of your regular monthly payment to your monthly check. Same outcome, no extra fee from servicers who charge for biweekly enrollment.

Refinancing Resets the Curve

A refinance pays off the original loan and starts a new one. If you refinance to a fresh 30-year term in year 7 of your original 30-year, you reset to month 1 of the new amortization — back to mostly-interest payments. The actual rate savings can still win, but the curve reset is the hidden cost almost no refinance calculator surfaces.

Two ways to keep the savings without resetting the curve:

• Refinance to a shorter remaining term.If you’re in year 7 of a 30-year and the new rate is meaningfully lower, refinance to a 23-year (preserves your original payoff date) or a 20-year (accelerates it). Monthly payment is similar; total interest savings can double versus a fresh 30.
• Refinance to a new 30, then continue paying the old amount. The new minimum payment is lower because the rate dropped, but you keep paying the old higher amount. The excess goes to principal — you finish years early and capture the full rate-savings benefit. Run the math in the mortgage refinance calculator first.

Term Length: The Biggest Cost Lever

Same $400,000 principal at 7% — the only difference is term length:

Going from 30-year to 15-year increases the monthly payment by $933 (35% higher) but cuts lifetime interest by $311,000 (56% less). On most household budgets, the 15-year monthly is too aggressive — but the 20-year monthly is only $440 more than 30-year and saves over $213,000 in interest. It’s the underrated middle path almost nobody discusses.

Common Mistakes & Edge Cases

• Confusing amortization with interest-only.Interest-only loans (common in commercial real estate, less so in residential) charge only interest for a defined period (typically 5-10 years). The balance stays flat. When the IO period ends, the loan re-amortizes over the remaining shorter term — monthly payment can leap 40-60%. Many 2007-era foreclosures were IO loans re-amortizing into payments borrowers couldn’t make.
• Forgetting the PITI vs P&I distinction. Amortization schedules show P&I only(principal + interest). The actual monthly check to a mortgage servicer typically includes property tax + insurance + PMI escrows on top — the “PITI” payment. Don’t expect this schedule to match your full mortgage statement; match it against the P&I line.
• Misapplied extra payments.Some servicers default to applying extras toward future months’ interest (effectively useless) rather than principal reduction. Always label extra payments “principal only” in your bank’s bill-pay memo. Confirm via the next statement that the balance dropped by the full extra amount.
• Treating ARM schedules as fixed.A 5/1 ARM is amortizing-fixed for the first 5 years only; then the rate resets annually. The schedule you’re looking at is wrong from year 6 onward. Run two passes: teaser rate for years 1-5, then worst-case lifetime-cap rate (start rate + 5% typically) on the remaining balance over the remaining 25 years.
• Ignoring rounding effects on the final payment.Most banks round each EMI up to the nearest cent or dollar. The accumulated rounding difference shows up on the final payment, which can be anywhere from $5 below to $50 above the standard payment. The bank’s payoff letter is the binding number for the last month.
• Believing the schedule once a refinance is on the table.The moment you refinance, this schedule becomes a historical artifact. The new loan has a new schedule starting at month 1. Save the old schedule for tax records; don’t treat its future months as predictions.

Why Schedules Differ Slightly Between Calculators

Three legitimate reasons for small numerical differences across calculators and bank statements:

• Rounding convention. Some calculators round each monthly payment to the cent; some round to the dollar. Accumulated rounding over 360 months can produce $5-$50 variance.
• Daily-accrual vs monthly-accrual interest.A few US lenders (and many international lenders) accrue interest daily on the outstanding balance rather than monthly. Daily accrual produces fractionally higher interest on the same headline rate — usually within $1-$3 per month.
• Pay date timing. If your monthly payment lands on the 15th rather than the 1st, the interest accrual covers more or fewer days the first month. The first or second payment may be slightly different from the steady-state schedule; subsequent months sync up.

Related Calculators

• Mortgage calculator— full PITI (P&I plus property tax, insurance, PMI) for the actual monthly check.
• Loan EMI calculator— lightweight monthly-payment calc when you don’t need the full schedule.
• PMI removal calculator— project when amortization plus appreciation hits 80% LTV and PMI legally falls off.
• Cash-out refinance— what tapping equity costs in lifetime interest by resetting the amortization curve.
• Mortgage refinance— breakeven math on a rate-and-term refinance, including the curve-reset cost.
• Payoff vs invest— before doubling down on principal payments, compare the expected return of investing the same dollars.