Loan Amortization Calculator
Generate a complete month-by-month amortization schedule and see exactly how every payment splits between principal and interest from Month 1 to payoff.
| Month | Payment | Principal | Interest | Remaining Balance |
|---|
Loan amortization is the process of paying off a debt over time through scheduled, equal installments where every payment covers both current-period interest and a slice of principal: M = P × [r(1 + r)n] / [(1 + r)n − 1], where P is loan principal, r = APR / 12 is the monthly interest rate, and n is the total number of monthly payments. In each period k, interest is calculated first on the remaining balance (Interestk = Balancek−1 × r), and the rest of the fixed payment reduces principal (Principalk = M − Interestk). On the default $250,000 loan at 6.5% APR for 30 years (360 months), the fixed monthly payment is $1,580.17: Month 1 splits into $1,354.17 of interest (85.7%) and $226.00 of principal (14.3%), the principal share finally overtakes interest in Month 233 ($791.42 principal vs. $788.75 interest), and Month 360 finishes with $1,571.66 of principal and $8.51 of interest (total interest $318,861.22; total paid $568,861.22).
How Loan Amortization Splits Principal vs. Interest Over Time
Unlike simple division, an amortizing loan keeps your total monthly payment constant while dynamically shifting the internal ratio of principal to interest every single month:
- Why early years are interest-heavy: In Month 1, you owe the full principal
P, soI1 = P × ris at its lifetime peak. On a $250,000 loan at 6.5% (r = 0.065 / 12 ≈ 0.0054167), Month 1 interest is$250,000 × 0.0054167 = $1,354.17, leaving only$1,580.17 − $1,354.17 = $226.00to reduce the balance. - Geometric growth of the principal slice: Because each month's principal payment reduces the balance by
Pk, the next month's interest drops byPk × r, and the next month's principal grows by that exact same amount:Pk+1 = Pk × (1 + r). Every month on a 6.5% loan, the principal portion grows by 0.54167%. - The principal-vs-interest crossover point: Principal exceeds interest once the remaining balance falls below half of the present value limit, which occurs at period
k > n + 1 − ln(2) / ln(1 + r). For a 30-year (360-month) loan at 6.5%,ln(2) / ln(1 + 0.065/12) ≈ 128.31, so the crossover lands at Month 233 (Year 20, Month 5). - Final-period identity: In the last month (
k = n), the remaining balance entering the period equalsBn−1 = M / (1 + r). On the default $250,000 loan, Month 360 starts with a balance of $1,571.66, accrues $8.51 in final interest, and zeroes out the loan with the $1,580.17 payment.
30-Year Amortization Milestone Schedule ($250,000 at 6.5% APR)
Tracing key milestones across a 360-month schedule shows why halfway through a 30-year mortgage in time (Month 180 / Year 15), you still owe 72.6% of the original balance ($181,397.85) and have already paid 67.7% of the loan's lifetime interest ($215,828.46 of $318,861.22):
| Period | Payment | Principal Paid | Interest Paid | Principal Share | Cumulative Interest | Ending Balance |
|---|---|---|---|---|---|---|
| Month 1 (Start) | $1,580.17 | $226.00 | $1,354.17 | 14.3% | $1,354.17 | $249,774.00 |
| Month 12 (Year 1) | $1,580.17 | $239.84 | $1,340.33 | 15.2% | $16,167.73 | $247,205.69 |
| Month 60 (Year 5) | $1,580.17 | $310.84 | $1,269.33 | 19.7% | $78,837.65 | $234,027.44 |
| Month 120 (Year 10) | $1,580.17 | $429.83 | $1,150.34 | 27.2% | $151,560.72 | $211,940.32 |
| Month 180 (Year 15 Midpoint) | $1,580.17 | $594.38 | $985.79 | 37.6% | $215,828.46 | $181,397.85 |
| Month 233 (Crossover) | $1,580.17 | $791.42 | $788.75 | 50.1% | $263,004.09 | $144,824.47 |
| Month 240 (Year 20) | $1,580.17 | $821.92 | $758.25 | 52.0% | $268,404.02 | $139,163.21 |
| Month 300 (Year 25) | $1,580.17 | $1,136.56 | $443.61 | 71.9% | $304,811.42 | $80,760.41 |
| Month 360 (Final) | $1,580.17 | $1,571.66 | $8.51 | 99.5% | $318,861.22 | $0.00 |
How to Read an Amortization Schedule Row by Row
Every row in the expandable amortization table above follows a strict five-column accounting identity from the prior month's ending balance:
- Month 1 (Opening row): Starting from a $250,000.00 balance at 6.5% APR (
0.065 / 12 = 0.541667%per month), Month 1 interest is$250,000.00 × 0.00541667 = $1,354.17. Subtracting that interest from the $1,580.17 payment leaves $226.00 of principal reduction, bringing the ending balance to$250,000.00 − $226.00 = $249,774.00. - Month 2 (The compounding shift): Month 2 interest is computed on the lower $249,774.00 balance:
$249,774.00 × 0.00541667 = $1,352.94($1.22 less interest than Month 1). Because the total payment stays fixed at $1,580.17, that $1.22 shifts directly into principal reduction ($227.23), lowering the ending balance to $249,546.77. - Extra Principal Payments: Any amount entered in Extra Monthly Payment bypasses the interest column completely and is subtracted straight from the remaining balance every month. Adding $200/month lifts Month 1 principal from $226.00 to $426.00, which immediately cuts Month 2's interest charge and compounds the savings across all remaining months.
- Month 360 (Payoff row): Entering the final month with a balance of $1,571.66, one last month of interest accrues (
$1,571.66 × 0.00541667 = $8.51). Your final $1,580.17 payment covers $1,571.66 in principal plus $8.51 in interest, bringing the remaining balance to $0.00.
15-Year vs. 30-Year Amortization Schedule Comparison
Shortening the amortization period on the same $250,000 loan at 6.5% APR from 30 years (360 months) to 15 years (180 months) does not change Month 1 interest ($1,354.17 in both schedules), but it increases Month 1 principal by more than 3.6×:
| Amortization Metric | 15-Year Schedule (180 mo) | 30-Year Schedule (360 mo) | Difference (15-Yr vs. 30-Yr) |
|---|---|---|---|
| Monthly Payment | $2,177.77 | $1,580.17 | +$597.60 / month |
| Month 1 Interest Paid | $1,354.17 (62.2%) | $1,354.17 (85.7%) | $0.00 (same initial balance) |
| Month 1 Principal Paid | $823.60 (37.8%) | $226.00 (14.3%) | +$597.60 faster equity in Month 1 |
| Principal > Interest Crossover | Month 53 (Year 5, Month 5) | Month 233 (Year 20, Month 5) | 180 months (15 years) earlier |
| Remaining Balance at Year 10 | $111,302.87 | $211,940.32 | $100,637.45 less debt after 10 yrs |
| Final Month Principal / Interest | $2,166.04 / $11.73 | $1,571.66 / $8.51 | Paid off at Month 180 vs. Month 360 |
| Total Interest Paid | $141,998.31 | $318,861.22 | −$176,862.91 interest saved |
| Total of All Payments | $391,998.31 | $568,861.22 | −$176,862.91 total cost reduction |
Amortization Formulas in Excel, Google Sheets & TI-84
You can verify any single row or cumulative window of the amortization table above in a spreadsheet or graphing calculator without building a 360-row sheet:
- Total Monthly Payment (Excel / Sheets):
=PMT(6.5%/12, 360, -250000)returns $1,580.17. - Interest Portion in Month k:
=IPMT(6.5%/12, 1, 360, -250000)returns $1,354.17 for Month 1;=IPMT(6.5%/12, 360, 360, -250000)returns $8.51 for Month 360. - Principal Portion in Month k:
=PPMT(6.5%/12, 1, 360, -250000)returns $226.00 for Month 1;=PPMT(6.5%/12, 360, 360, -250000)returns $1,571.66 for Month 360. - Cumulative Interest Between Two Months:
=-CUMIPMT(6.5%/12, 360, 250000, 1, 180, 0)returns $215,828.46 (total interest paid during the first 15 years); across all 360 months (1, 360) it returns $318,861.22. - Cumulative Principal Between Two Months:
=-CUMPRINC(6.5%/12, 360, 250000, 1, 180, 0)returns $68,602.15 (leaving$250,000 − $68,602.15 = $181,397.85remaining at Month 180). - TI-84 Plus TVM Solver & Finance Functions: After solving for
PMT = -1580.17inAPPS → 1:Finance → 1:TVM Solver(N=360, I%=6.5, PV=250000, FV=0, P/Y=12, C/Y=12), usebal(180)for the Month 180 balance ($181,397.85),ΣInt(1, 12)for Year 1 interest (-$16,167.73), andΣPrn(1, 12)for Year 1 principal paid.
Worked Examples: 30-Year Schedule, Extra Principal & Short-Term Amortization
Example 1: Standard 30-Year Mortgage Amortization ($250,000 at 6.5% APR)
Borrow $250,000 at 6.5% annual interest for 30 years (360 monthly payments) with no extra payments:
- Monthly Payment: $1,580.17
- Month 1 Split: $1,354.17 interest + $226.00 principal (remaining balance $249,774.00)
- Year 15 Midpoint (Month 180): $985.79 interest + $594.38 principal; cumulative interest paid is $215,828.46 and remaining balance is $181,397.85
- Principal Crossover (Month 233): Principal ($791.42) exceeds interest ($788.75) for the first time, with $144,824.47 remaining
- Final Payment (Month 360): $1,571.66 principal + $8.51 interest (remaining balance $0.00)
- Lifetime Totals: $568,861.22 total of 360 payments ($250,000.00 principal + $318,861.22 total interest)
Example 2: Adding $200/Month Extra Principal to the Same $250,000 Loan
Keep the $250,000 loan at 6.5% APR for 30 years, and add $200/month in recurring extra principal (total monthly outflow $1,780.17):
- Month 1 Split: Interest remains $1,354.17, but principal paid jumps from $226.00 to $426.00 (+88.5% faster principal reduction in Month 1)
- Accelerated Payoff Time: Paid off in 265 months (22 years 1 month), eliminating 95 monthly payments (7 years 11 months earlier)
- Lifetime Interest Saved: Total interest drops from $318,861.22 to $221,243.10, saving $97,618.12 in interest (total paid $471,243.10)
Example 3: 15-Year Mortgage ($250,000 at 6.5%) & 5-Year Auto Loan ($35,000 at 6.0%)
- 15-Year Mortgage ($250,000 at 6.5% for 180 months): Monthly payment is $2,177.77. Month 1 splits into $1,354.17 interest and $823.60 principal; principal overtakes interest in Month 53 ($1,090.72 principal vs. $1,087.05 interest); Month 180 closes with $2,166.04 principal and $11.73 interest. Total interest is $141,998.31 and total paid is $391,998.31 (saving $176,862.91 vs. the 30-year schedule).
- 5-Year Auto/Equipment Loan ($35,000 at 6.0% for 60 months): Monthly payment is $676.65. Because the term is only 60 months, principal exceeds interest from Day 1: Month 1 splits into $501.65 principal (74.1%) and $175.00 interest (25.9%, ending balance $34,498.35), and Month 60 finishes with $673.28 principal and $3.37 interest. Total interest is $5,598.88 (total paid $40,598.88).
Related tools
- Baseline payment math. The Loan / Mortgage Calculator computes monthly payments and simple schedules for any fixed-rate borrowing.
- Accelerated payoff savings. The Early Mortgage Payoff Calculator models how extra monthly payments or lump sums cut interest and shorten the term.
- Financing cost with upfront fees. The APR Calculator incorporates lender points and closing fees to disclose the true annual percentage rate.
- Revolving card debt payoff. The Credit Card Payoff Calculator applies the same amortization mechanics to revolving credit card balances.
Frequently Asked Questions
What is an amortization schedule and how does it work?
An amortization schedule is a complete table of periodic loan payments showing the exact dollar amount of each payment that goes toward accrued interest versus principal reduction, along with the remaining loan balance after every payment. On a standard fixed-rate loan, the total monthly payment stays constant, while the interest portion declines and the principal portion grows every month until the balance reaches $0.00 at the end of the term.
Why does most of my early payment go toward interest instead of principal?
Interest in any month equals your current unpaid loan balance multiplied by the monthly interest rate (Balance × APR / 12). At the beginning of a 30-year loan, your unpaid balance is at its maximum, so the monthly interest charge consumes most of your fixed payment (for example, $1,354.17 of a $1,580.17 payment on a $250,000 loan at 6.5% APR). As principal is gradually paid down, the interest charge shrinks each month and a larger share of the same fixed payment goes toward principal.
When does the principal portion of my payment exceed the interest portion?
The principal portion exceeds the interest portion once the remaining loan balance drops below the point where monthly interest equals half of your monthly payment. In monthly periods, that crossover happens at k > n + 1 − ln(2) / ln(1 + r). Notice that the number of months remaining after the crossover (ln(2) / ln(1 + r)) depends only on the interest rate: at 6.5% APR, principal overtakes interest with about 128 months left on the schedule—which is Month 233 of a 360-month (30-year) loan, or Month 53 of a 180-month (15-year) loan.
How do extra principal payments change the amortization schedule?
An extra principal payment does not lower your required base payment on a standard fixed-rate loan; instead, 100% of the extra amount is subtracted directly from your remaining principal balance in that month. Because next month's interest is calculated on the lower balance, the interest portion of every subsequent regular payment is permanently reduced, shifting more of each regular payment into principal and eliminating months or years from the end of the schedule.
What is the difference between equal-payment amortization and fixed-principal amortization?
Equal-payment amortization (standard US mortgages, auto loans, and personal loans, also called French amortization or Tabela Price) keeps the total monthly payment constant while the principal slice grows geometrically over time. Fixed-principal amortization (also called constant-amortization or SAC) divides the loan amount into equal monthly principal slices (for example, $250,000 / 360 = $694.44 per month in principal) plus monthly interest on the declining balance, producing a higher initial payment that steps down every month and lower total lifetime interest. You can compare both side by side with our Fixed-Principal Loan Calculator.
What is negative amortization and can it happen on a standard fixed-rate loan?
Negative amortization occurs when a borrower's monthly payment is smaller than the interest accrued during that period (Payment < Balance × r), causing the unpaid interest difference to be added back to the loan balance so the debt grows over time. A standard fixed-rate fully amortizing loan cannot experience negative amortization because the payment formula guarantees that even Month 1's payment exceeds Month 1's interest charge.
How do I calculate the remaining loan balance after k months without building every row?
You can compute the exact remaining balance after k payments using the closed-form formula Bk = P × [(1 + r)n − (1 + r)k] / [(1 + r)n − 1], where P is original principal, r is the monthly interest rate, and n is the total number of months. Equivalently, the remaining balance equals the present value of the remaining n − k monthly payments discounted at rate r.