Amortization Calculator
Calculate your loan payment and generate a complete amortization schedule showing principal, interest, and remaining balance over time.
See how your payments change the loan balance, how much interest you will pay, and how extra payments can help you pay off the loan faster.
Loan Details
The amount borrowed (principal).
Fixed annual rate, for example 6.5.
360 monthly payments
Advanced Options (optional)
Standard monthly schedule.
Optional. Adds payment dates and an estimated payoff date.
Monthly Payment
Principal and interest only
- Total Principal
- $300,000.00
- Total Interest
- $382,633.47
- Total Paid
- $682,633.47
- Number of Payments
- 360
Paid off after 360 payments (30 years).
First payment breakdown
$1,896.20 = $1,625.00 interest + $271.20 principal
Balance after payment 1: $299,728.80
Where your money goes
What If I Pay Extra?
Added to every payment and applied to principal.
Once a year, applied to principal.
A single lump sum toward principal.
1 to 360
Enter an extra amount, or tap a quick amount, to compare a faster payoff with the original schedule.
Biweekly alternative: paying half the monthly payment ($948.10) every two weeks makes 26 half-payments, the equivalent of 13 monthly payments a year. Simulated on this loan, that pays it off in ≈ 24 years 2 months and saves $88,121.78 in interest, if your lender applies each payment when received.
Loan Balance Over Time
Chart summary: the balance falls from $300,000.00 to $0 over 30 years, slowly at first and faster later. Hover, tap or use the arrow keys to read any year.
Principal vs. Interest by Year
Chart summary: in year 1, $19,401.27 of payments goes to interest and $3,353.18 to principal; in the final year it is $781.30 interest and $21,973.15 principal. Early payments are mostly interest, and the principal share grows as the balance falls.
Loan Milestones
| After | Balance | Principal Repaid |
|---|---|---|
| 1 year | $296,646.82 | 1.1% |
| 5 years | $280,832.93 | 6.4% |
| 10 years | $254,328.38 | 15.2% |
| 15 years | $217,677.42 | 27.4% |
| 20 years | $166,995.85 | 44.3% |
| 25 years | $96,912.49 | 67.7% |
| Final payoff | $0.00 | 100.0% |
Principal first exceeds interest with payment 233 (19 years 4 months in).
How Much Will I Still Owe?
- Remaining balance after payment 60
- $280,832.93
- Principal paid
- $19,167.07
- Interest paid
- $94,605.18
- Total payments made
- $113,772.24
Based on the standard schedule without extra payments.
Why Is My First Payment Mostly Interest?
Interest is charged on the balance you still owe. At the start the balance is at its highest ($300,000.00), so the first payment's interest is $1,625.00 and only $271.20 reduces the loan. As the balance falls, the interest charge falls with it and more of the same $1,896.20 goes to principal: by payment 271, interest is $730.10 and principal is $1,166.11.
Amortization Schedule
| Payment # | Payment | Principal | Interest | Remaining Balance |
|---|---|---|---|---|
| 1 | $1,896.20 | $271.20 | $1,625.00 | $299,728.80 |
| 2 | $1,896.20 | $272.67 | $1,623.53 | $299,456.12 |
| 3 | $1,896.20 | $274.15 | $1,622.05 | $299,181.97 |
| 4 | $1,896.20 | $275.64 | $1,620.57 | $298,906.34 |
| 5 | $1,896.20 | $277.13 | $1,619.08 | $298,629.21 |
| 6 | $1,896.20 | $278.63 | $1,617.57 | $298,350.58 |
| 7 | $1,896.20 | $280.14 | $1,616.07 | $298,070.44 |
| 8 | $1,896.20 | $281.66 | $1,614.55 | $297,788.79 |
| 9 | $1,896.20 | $283.18 | $1,613.02 | $297,505.60 |
| 10 | $1,896.20 | $284.72 | $1,611.49 | $297,220.89 |
| 11 | $1,896.20 | $286.26 | $1,609.95 | $296,934.63 |
| 12 | $1,896.20 | $287.81 | $1,608.40 | $296,646.82 |
| 13 | $1,896.20 | $289.37 | $1,606.84 | $296,357.46 |
| 14 | $1,896.20 | $290.93 | $1,605.27 | $296,066.52 |
| 15 | $1,896.20 | $292.51 | $1,603.69 | $295,774.01 |
| 16 | $1,896.20 | $294.09 | $1,602.11 | $295,479.92 |
| 17 | $1,896.20 | $295.69 | $1,600.52 | $295,184.23 |
| 18 | $1,896.20 | $297.29 | $1,598.91 | $294,886.94 |
| 19 | $1,896.20 | $298.90 | $1,597.30 | $294,588.04 |
| 20 | $1,896.20 | $300.52 | $1,595.69 | $294,287.52 |
| 21 | $1,896.20 | $302.15 | $1,594.06 | $293,985.37 |
| 22 | $1,896.20 | $303.78 | $1,592.42 | $293,681.59 |
| 23 | $1,896.20 | $305.43 | $1,590.78 | $293,376.16 |
| 24 | $1,896.20 | $307.08 | $1,589.12 | $293,069.08 |
| 25 | $1,896.20 | $308.75 | $1,587.46 | $292,760.33 |
| 26 | $1,896.20 | $310.42 | $1,585.79 | $292,449.91 |
| 27 | $1,896.20 | $312.10 | $1,584.10 | $292,137.81 |
| 28 | $1,896.20 | $313.79 | $1,582.41 | $291,824.02 |
| 29 | $1,896.20 | $315.49 | $1,580.71 | $291,508.53 |
| 30 | $1,896.20 | $317.20 | $1,579.00 | $291,191.33 |
| 31 | $1,896.20 | $318.92 | $1,577.29 | $290,872.41 |
| 32 | $1,896.20 | $320.65 | $1,575.56 | $290,551.77 |
| 33 | $1,896.20 | $322.38 | $1,573.82 | $290,229.39 |
| 34 | $1,896.20 | $324.13 | $1,572.08 | $289,905.26 |
| 35 | $1,896.20 | $325.88 | $1,570.32 | $289,579.37 |
| 36 | $1,896.20 | $327.65 | $1,568.55 | $289,251.73 |
| 37 | $1,896.20 | $329.42 | $1,566.78 | $288,922.30 |
| 38 | $1,896.20 | $331.21 | $1,565.00 | $288,591.09 |
| 39 | $1,896.20 | $333.00 | $1,563.20 | $288,258.09 |
| 40 | $1,896.20 | $334.81 | $1,561.40 | $287,923.29 |
| 41 | $1,896.20 | $336.62 | $1,559.58 | $287,586.67 |
| 42 | $1,896.20 | $338.44 | $1,557.76 | $287,248.22 |
| 43 | $1,896.20 | $340.28 | $1,555.93 | $286,907.95 |
| 44 | $1,896.20 | $342.12 | $1,554.08 | $286,565.83 |
| 45 | $1,896.20 | $343.97 | $1,552.23 | $286,221.85 |
| 46 | $1,896.20 | $345.84 | $1,550.37 | $285,876.02 |
| 47 | $1,896.20 | $347.71 | $1,548.50 | $285,528.31 |
| 48 | $1,896.20 | $349.59 | $1,546.61 | $285,178.72 |
| 49 | $1,896.20 | $351.49 | $1,544.72 | $284,827.23 |
| 50 | $1,896.20 | $353.39 | $1,542.81 | $284,473.84 |
| 51 | $1,896.20 | $355.30 | $1,540.90 | $284,118.54 |
| 52 | $1,896.20 | $357.23 | $1,538.98 | $283,761.31 |
| 53 | $1,896.20 | $359.16 | $1,537.04 | $283,402.15 |
| 54 | $1,896.20 | $361.11 | $1,535.09 | $283,041.04 |
| 55 | $1,896.20 | $363.07 | $1,533.14 | $282,677.97 |
| 56 | $1,896.20 | $365.03 | $1,531.17 | $282,312.94 |
| 57 | $1,896.20 | $367.01 | $1,529.20 | $281,945.93 |
| 58 | $1,896.20 | $369.00 | $1,527.21 | $281,576.93 |
| 59 | $1,896.20 | $371.00 | $1,525.21 | $281,205.94 |
| 60 | $1,896.20 | $373.01 | $1,523.20 | $280,832.93 |
Amounts are rounded to the cent for display; the schedule is calculated at full precision, so a row can appear a cent off and the final payment clears the loan to exactly $0.
Extra Payment Comparison
| Extra / Month | Payoff Time | Interest Paid | Interest Saved | Time Saved |
|---|---|---|---|---|
| $0 | 30 years | $382,633.47 | — | — |
| $50 | 27 years 10 months | $349,051.74 | $33,581.73 | 2 years 2 months |
| $100 | 26 years | $321,638.68 | $60,994.79 | 4 years |
| $200 | 23 years 1 month | $279,184.67 | $103,448.79 | 6 years 11 months |
| $500 | 17 years 6 months | $202,874.38 | $179,759.08 | 12 years 6 months |
Loan Assumptions
This calculator assumes a fixed interest rate, regular scheduled payments and a fully amortizing loan, and shows principal and interest only. It does not include property taxes, homeowners insurance, PMI, HOA fees, lender fees, closing costs, points or prepayment penalties, so for a mortgage it is not the full PITI payment.
Adjustable-rate loans can change their payment and amortization schedule when the rate resets; this schedule does not model rate changes.
This amortization calculator shows exactly how a fixed-rate loan gets paid off. Enter the loan amount, interest rate and term to get the payment, the total interest and total cost, and a complete amortization schedule with the principal, interest and remaining balance for every payment, by month or by year.
Charts show the balance falling over time and how each year's payments shift from mostly interest to mostly principal, and milestones show what you still owe after 1, 5, 10 or more years and when principal first exceeds interest. To see how to pay a loan off faster, add an extra monthly, yearly or one-time payment and compare the interest saved and the time saved with the original schedule. It works for mortgages, auto loans and other fixed-rate installment loans, showing principal and interest only.
What Is an Amortization Schedule?
An amortization schedule is a payment-by-payment breakdown of a loan. For every payment it shows the payment amount, how much of it is interest, how much reduces the principal, and the balance still owed afterwards. Reading down the table shows exactly how the loan disappears over time: slowly at first, then faster as the balance shrinks.
An Amortization Table Calculator for Any Loan
This free amortization calculator, or amortization table calculator, is a loan amortization schedule calculator and loan amortization table calculator in one: it builds a free amortization schedule for any fixed-rate installment loan: a mortgage, a car loan, a personal loan, a student loan, a business or commercial loan, or a promissory note. Use it as an online mortgage amortization calculator or house amortization calculator (home loan amortization and mortgage loan amortization), a car loan amortization schedule calculator or auto loan amortization calculator, an auto loan amortization schedule, a personal loan amortization calculator or a debt amortization calculator. It is also a loan payment amortization calculator, because it shows the payment as well as the schedule, and an owner finance calculator for amortization of owner-financed sales, land contracts and contracts for deed, where the seller holds the loan.
What Does Amortization Mean?
To define amortization simply: it means paying off a debt with regular, equal payments over a set time, where each payment covers that period's interest and repays part of the principal. An amortized loan (amortised in British English) reaches a zero balance with the last payment. Interest amortization is front-loaded: early payments are mostly interest, later ones mostly principal. In accounting, amortization also means spreading the cost of an intangible asset over its useful life, which is a different calculation.
Amortization Formula
M = P × [r(1 + r)^n] ÷ [(1 + r)^n − 1]
- M = periodic payment
- P = loan principal
- r = periodic interest rate
- n = total number of payments
For monthly payments, r = annual rate ÷ 12 and n = loan term in years × 12. For biweekly or weekly payments the calculator uses 26 or 52 instead of 12. At a 0% rate the payment is simply P ÷ n.
Each row of the schedule
Interest = Opening Balance × Periodic Rate
Principal = Payment − Interest
New Balance = Opening Balance − Principal − Extra Principal
How to calculate the amortization of a loan by hand: find the payment with the formula, then for each row multiply the balance by the periodic rate for the interest, subtract it from the payment for the principal, and subtract the principal from the balance. Repeat until the balance reaches zero. That is how to calculate an amortization schedule for a loan, how to do an amortization schedule, and how to amortize a loan, with nothing more than this amortized loan equation (the amortization calculation formula).
The calculator keeps full precision and rounds only for display. The last payment is adjusted to clear whatever small amount remains, so the final balance is exactly $0. This level-payment method is the standard one used in U.S. Truth in Lending (Regulation Z) loan disclosures and in spreadsheet loan functions.
Amortization Examples
Example 1: 30-Year Mortgage
$300,000.00 · 6.5% · 30 years
- Monthly payment
- $1,896.20
- Total interest
- $382,633.47
- Total paid
- $682,633.47
- First payment
- $1,625.00 interest + $271.20 principal
- Balance after year 1
- $296,646.82
Example 2: Auto Loan
$20,000.00 · 7% · 5 years
- Monthly payment
- $396.02
- Total interest
- $3,761.44
- First payment
- $116.67 interest + $279.36 principal
Example 3: Extra Payment
$300,000.00 · 6.5% · 30 years · +$200/month
- Original payoff
- 30 years
- Accelerated payoff
- 23 years 1 month
- Original interest
- $382,633.47
- New interest
- $279,184.67
- Interest saved
- $103,448.79
- Time saved
- 6 years 11 months
Example 4: Remaining Balance
The Example 1 mortgage: how much would I still owe after 10 years?
- Still owed after 120 payments
- $254,328.38
- Principal repaid
- $45,671.62
- Interest paid
- $181,872.87
- Total payments made
- $227,544.49
All examples use the same calculation engine as the calculator above.
Amortization Table Example: Monthly Amortization Schedule
The first year of the Example 1 mortgage ($300,000.00 at 6.5% for 30 years), as it appears in the calculator's schedule. Each payment is $1,896.20; watch the interest fall and the principal rise every month.
| Payment | Interest | Principal | Balance |
|---|---|---|---|
| #1 | $1,625.00 | $271.20 | $299,728.80 |
| #2 | $1,623.53 | $272.67 | $299,456.12 |
| #3 | $1,622.05 | $274.15 | $299,181.97 |
| #4 | $1,620.57 | $275.64 | $298,906.34 |
| #5 | $1,619.08 | $277.13 | $298,629.21 |
| #6 | $1,617.57 | $278.63 | $298,350.58 |
| #7 | $1,616.07 | $280.14 | $298,070.44 |
| #8 | $1,614.55 | $281.66 | $297,788.79 |
| #9 | $1,613.02 | $283.18 | $297,505.60 |
| #10 | $1,611.49 | $284.72 | $297,220.89 |
| #11 | $1,609.95 | $286.26 | $296,934.63 |
| #12 | $1,608.40 | $287.81 | $296,646.82 |
Mortgage amortization schedule by year (amortization chart)
| Year | Interest paid | Principal paid | Balance at year end |
|---|---|---|---|
| Year 1 | $19,401.27 | $3,353.18 | $296,646.82 |
| Year 5 | $18,408.66 | $4,345.79 | $280,832.93 |
| Year 10 | $16,745.02 | $6,009.43 | $254,328.38 |
| Year 15 | $14,444.51 | $8,309.94 | $217,677.42 |
| Year 20 | $11,263.32 | $11,491.13 | $166,995.85 |
| Year 25 | $6,864.32 | $15,890.13 | $96,912.49 |
| Year 30 | $781.30 | $21,973.15 | $0.00 |
In year 1 about 85% of what you pay is interest; by the final year almost all of it is principal. The calculator's balance chart and principal vs. interest chart show the same home mortgage amortization curve for your own loan.
Amortization Schedule With Extra Payments
Extra principal payments shorten the schedule and cut interest, because each one lowers the balance that every later payment's interest is charged on. Under What If I Pay Extra? the calculator adds an extra amount every month, once a year, or as a one-time lump sum, so it works as a loan calculator with extra payments, a payment calculator with extra payments, a mortgage loan payoff calculator or home loan payoff calculator, and an amortization calculator paying extra toward principal: a loan amortization table with extra payments for any loan. On the Example 1 mortgage:
| Extra per month | Paid off in | Interest saved | Time saved |
|---|---|---|---|
| $100.00 | 26 years | $60,994.79 | 4 years |
| $200.00 | 23 years 1 month | $103,448.79 | 6 years 11 months |
| $500.00 | 17 years 6 months | $179,759.08 | 12 years 6 months |
| $1,000.00 | 12 years 9 months | $241,162.07 | 17 years 3 months |
The same applies to an amortization schedule with extra principal payments on a car: use it as an extra car payment calculator, car loan calculator with extra payments or auto loan calculator with extra payments by entering the auto loan and an extra amount; personal loans work the same way. Check that your lender applies extra money to principal rather than to future payments.
Car Loan Amortization Table
Monthly payments and total interest for common auto loans at 7%. For your own car payment amortization (use it as a car payment amortization calculator or auto amortization calculator), enter the amount financed after the down payment and trade-in; the auto loan calculator works that out from the car price, tax and fees.
| Amount financed | 36 months | 48 months | 60 months | 72 months |
|---|---|---|---|---|
| $20,000.00 | $617.54 ($2,231.51 interest) | $478.92 ($2,988.39 interest) | $396.02 ($3,761.44 interest) | $340.98 ($4,550.57 interest) |
| $30,000.00 | $926.31 ($3,347.26 interest) | $718.39 ($4,482.59 interest) | $594.04 ($5,642.16 interest) | $511.47 ($6,825.85 interest) |
| $40,000.00 | $1,235.08 ($4,463.02 interest) | $957.85 ($5,976.79 interest) | $792.05 ($7,522.88 interest) | $681.96 ($9,101.14 interest) |
How the Term Changes the Amortization
A shorter amortization raises the payment but cuts the interest sharply. $300,000.00 at 6.5% (a shorter term would usually get a lower rate, widening the gap):
| Amortization period | Monthly payment | Total interest |
|---|---|---|
| 5-year amortization schedule | $5,869.84 | $52,190.67 |
| 10-year amortization schedule | $3,406.44 | $108,772.72 |
| 15-year amortization schedule | $2,613.32 | $170,397.98 |
| 20-year amortization schedule | $2,236.72 | $236,812.66 |
| 30-year amortization schedule | $1,896.20 | $382,633.47 |
Amortization Schedule in Excel
Select Download CSV under the schedule to save the full amortization table, by payment or by year. The file opens in Excel, Google Sheets or Numbers, so you get an amortization table in Excel (a loan amortization schedule in Excel, or loan repayment schedule in Excel) without building a loan amortization spreadsheet or template yourself. To recreate it with formulas, Excel's =PMT(rate/12, months, -amount) gives the payment, for example =PMT(6.5%/12, 360, -300000) = $1,896.20, and =IPMT and =PPMT give the interest and principal for any payment number.
Loans This Schedule Does Not Fit
This calculator assumes a fixed rate and equal payments until the loan is repaid. A balloon loan, which leaves a large lump sum at the end, an interest-only period, an adjustable-rate mortgage after its reset, and a reverse mortgage all follow different schedules. A HELOC is interest-only during its draw period and amortizes only in the repayment period; the HELOC payment calculator handles both phases and works as a HELOC amortization calculator, and the home equity loan calculator covers fixed home equity loans. Credit cards are revolving debt rather than amortized loans; use the credit card payoff calculator. Some auto loans charge daily simple interest, so a simple interest amortization schedule can differ by a few dollars depending on the day each payment arrives.
Biweekly Payments and Amortization
“Biweekly” can mean two different things. A loan that is set up with biweekly payments has 26 payments a year, each calculated for that schedule at 1/26 of the annual rate; that is what the Payment Frequency option models. A common accelerated plan instead pays half of the monthly payment every two weeks. Because there are 26 two-week periods in a year, that adds up to 13 monthly payments instead of 12, and the extra payment goes to principal. The calculator simulates that plan separately under What If I Pay Extra?, rather than assuming savings.
Common Amortization Mistakes
- Confusing the payment with the total cost. A $1,896.20 monthly payment on the Example 1 mortgage adds up to $682,633.47 over 30 years.
- Ignoring total interest. Two loans with similar monthly payments can have very different lifetime interest, especially when the terms differ.
- Assuming extra payments automatically reduce interest. They only produce the modeled savings if the lender applies them to principal, which some loans require you to request.
- Comparing payment frequencies incorrectly. 26 biweekly half-payments equal 13 monthly payments a year, not 12.
- Using a fixed-rate schedule for an adjustable-rate loan. The payment and the schedule change when the rate resets.
- Confusing principal and interest with the full mortgage payment. Taxes, insurance, PMI and HOA fees are usually paid on top and are outside the amortization calculation.
Amortization, Loan and Mortgage Calculators
Each tool answers a different question. The loan calculator answers “what is my payment?” and lets you compare terms. The mortgage calculator adds home costs such as property tax and insurance for the full monthly housing payment. This amortization calculator shows how the loan is paid off payment by payment. For car purchases with a down payment and trade-in, use the auto loan calculator, and to see whether a new rate is worth it, the refinance calculator.
How to Use the Amortization Calculator
- Enter the loan amount, the annual interest rate and the loan term in years or months.
- Read the monthly payment, total principal, total interest, total paid and number of payments, plus how the first payment splits between interest and principal.
- Optionally open Advanced Options to switch to biweekly or weekly payments (the schedule is recalculated for that frequency) or to add a first payment date for payment dates and a payoff date.
- Use the balance chart, the principal vs. interest chart, the milestones and How Much Will I Still Owe? to see how the loan is paid down.
- Browse the full amortization schedule by payment or by year, jump to any payment number, or download it as a CSV file.
- Under What If I Pay Extra?, add an extra amount per month, per year or as a one-time payment (or tap +$50 to +$500) to see the interest saved and how much sooner the loan is paid off.
Frequently Asked Questions
What is an amortization schedule?
It is a table of every payment on a loan, showing how much of each payment goes to interest, how much reduces the principal, and the balance left afterwards, until the loan reaches $0.
How is an amortization schedule calculated?
The payment is found with M = P × r(1 + r)^n ÷ ((1 + r)^n − 1). Then, for each payment, interest is the opening balance times the periodic rate, principal is the payment minus that interest, and the new balance is the old balance minus the principal.
What is the difference between principal and interest?
Principal is the amount you borrowed and are paying back. Interest is the lender's charge for the loan, calculated on the balance you still owe. Each payment covers that period's interest first, and the rest reduces the principal.
Why do early loan payments have more interest?
Interest is charged on the outstanding balance, which is highest at the start. On a $300,000 loan at 6.5%, the first payment of $1,896.20 includes $1,625.00 of interest and only $271.20 of principal. As the balance falls, the interest share shrinks and the principal share grows.
How much interest will I pay over the life of my loan?
Enter your loan to see the total interest. For example, $300,000 at 6.5% over 30 years costs about $382,633 in interest, more than the amount borrowed. A shorter term or lower rate reduces it.
How does an extra payment affect amortization?
An extra payment applied to principal lowers the balance immediately, so every later payment carries less interest and more principal. The loan is paid off sooner and the total interest falls, while the scheduled payment stays the same.
How much interest can I save by paying extra each month?
It depends on the loan, but it is often substantial on long loans. On a $300,000, 30-year loan at 6.5%, an extra $200 a month saves about $103,000 in interest and pays the loan off almost 7 years sooner. Use What If I Pay Extra? or the comparison table to see your figures.
How much faster can I pay off my loan with extra payments?
The calculator shows the new payoff time and the time saved. On long loans, even small extra monthly payments can cut years off the term, because the extra goes straight to principal early, when it saves the most interest.
How much will I still owe after 5 years?
Use How Much Will I Still Owe? and choose 5 years. On long loans the balance falls slowly at first, so after 5 years of a 30-year mortgage most of the original principal is usually still owed.
How much will I still owe after 10 years?
Choose 10 years in How Much Will I Still Owe?, or check the milestones table. On a $300,000, 30-year loan at 6.5%, roughly $254,000 is still owed after 10 years, even though about $227,000 has been paid.
Does paying extra reduce the monthly payment?
Usually not. On a standard fixed-rate loan, extra principal payments shorten the loan and reduce total interest, but the required payment stays the same. Some lenders offer a recast that lowers the payment after a large prepayment, which this calculator does not model.
Does an amortization calculator include property taxes and insurance?
No. It shows principal and interest only. Property taxes, homeowners insurance, PMI and HOA fees are often paid with a mortgage payment but are not part of the loan's amortization; use the mortgage calculator for the full monthly cost.
Can I use this for an auto loan?
Yes. Enter the amount financed, the rate and the term in months or years. For example, $20,000 at 7% for 5 years is $396.02 a month. The auto loan calculator also handles the down payment, trade-in and sales tax.
Can I use this for a mortgage?
Yes, for the principal and interest part of a fixed-rate mortgage. It shows the full schedule, the balance after any year and the effect of extra payments, but not taxes, insurance or PMI.
Does this calculator work for adjustable-rate loans?
No. It assumes the rate never changes. An adjustable-rate loan's payment and schedule change when the rate resets, so this schedule only describes the initial fixed period.
What is the difference between amortization and simple interest?
With an amortizing loan, interest is charged on the remaining balance each period and fixed payments repay it gradually, so interest falls over time. Simple interest charges interest only on the original principal at a fixed rate, I = P × r × t, regardless of repayments.
What happens if I make a one-time extra payment?
A lump sum applied to principal reduces the balance right away. All later interest is calculated on the smaller balance, so the loan ends earlier and costs less. Enter the amount and the payment number under What If I Pay Extra? to see the new payoff time and interest saved.
How does biweekly payment affect amortization?
A loan scheduled with 26 payments a year is recalculated at 1/26 of the annual rate per payment. A popular alternative is paying half the monthly payment every two weeks, which adds up to 13 monthly payments a year; the extra payment goes to principal and shortens the loan. The calculator simulates both rather than assuming the savings.
What does amortization mean?
Amortization means paying off a loan with equal, regular payments that each cover the interest due and repay part of the principal, so the balance reaches zero with the last payment. Early payments are mostly interest; later payments are mostly principal.
How do I calculate an amortization schedule?
Work out the payment with M = P × r(1 + r)^n ÷ ((1 + r)^n − 1). Then, for each payment, interest = balance × periodic rate, principal = payment − interest, and the new balance = balance − principal. The calculator builds every row for you.
Can I make an amortization schedule with extra payments?
Yes. Under What If I Pay Extra?, add an amount every month, once a year or as a one-time payment. On a $300,000 30-year mortgage at 6.5%, an extra $200 a month saves about $103,449 of interest and pays the loan off about 7 years sooner.
Can I use this for a car loan amortization schedule?
Yes. Enter the amount financed, the APR and the term in months. A $30,000 car loan at 7% for 60 months costs $594.04 a month. Add an extra amount to see how much sooner the car is paid off.
How do I get my amortization schedule into Excel?
Select Download CSV under the schedule. The file opens directly in Excel or Google Sheets, by payment or by year. In Excel, =PMT(rate/12, months, -amount) gives the same monthly payment.
Does this work for balloon or interest-only loans?
No. It assumes equal payments that fully repay a fixed-rate loan. Balloon loans, interest-only periods, HELOC draw periods, adjustable-rate resets and reverse mortgages follow different schedules.
Related Calculators
Loan Calculator
Calculate monthly loan payments, interest charges, and loan payoff terms.
Mortgage Calculator
Estimate home mortgage payments including principal, interest, taxes, and insurance.
Auto Loan Calculator
Calculate monthly car loan payments, interest, trade-in value, and sales tax.
Refinance Calculator
Compare your current mortgage with a new loan: payments, closing costs, break-even and total cost.
Credit Card Payoff Calculator
Estimate your credit card payoff time, total interest and debt-free date.
Simple Interest Calculator
Calculate simple interest earnings I = P * r * t.
Rental Property ROI Calculator
Estimate rental property cash flow, NOI, cap rate and cash-on-cash return.
APR Calculator
Estimate a loan APR including fees, from loan terms or a quoted payment, and compare offers.
More Finance Calculators
Last updated: October 25, 2026.