Loan Amortization Calculator

A loan for over years at interest costs $127,551.07 with payments of $1,771.54 per month.

Work backward

Find the that makes the monthly payment : ...

Start over
Amortization schedule

Free calculator by ROI.fyi

What is loan amortization?

Amortization is how a loan gets paid off over time through equal payments. Each payment covers that month's interest first, and the rest reduces the balance. Enter the amount, years and rate above, then open the amortization schedule to see every payment. The example amortizes $110,000 over 6 years at 5%, which comes to $1,772 a month and $17,551 in total interest.

The split changes every month. In that example, the first payment includes $458 in interest and $1,313 in principal. By the final payment, almost all of it goes to principal. The total stays level, but the balance falls faster over time. The chart shows this curve clearly, and the longer the loan, the slower it starts. On a 30-year mortgage, most of your first payments are interest.

To work out a schedule by hand, you need three formulas. The payment is P x r(1 + r)^n / ((1 + r)^n - 1), where P is the amount, r is the monthly rate and n is the number of payments. Each month's interest is the balance x r, the principal is the payment minus the interest, and the new balance is the old balance minus that principal. Then you repeat for each month.

A schedule is more than a table of numbers. It tells you what you still owe at any date, how much interest you'd save by paying early and how much equity you'd have if you sold. You can copy it or download a CSV or Excel file to plan extra payments. This schedule assumes a fixed rate and on-time payments, so an actual statement may differ by a few cents because of rounding or day-count rules.

How a loan amortizes over time

This shows a $100,000 loan at 6.5% over 30 years.

After yearBalancePrincipal paid so farInterest paid so far
1$98,882$1,118$6,467
5$93,611$6,389$31,535
10$84,776$15,224$60,624
20$55,665$44,335$107,362
30$0$100,000$127,544

Frequently Asked Questions

How does loan amortization work?

You make the same payment each month. The lender first takes the interest due on your current balance, then applies the rest to principal. The balance falls a little, so next month's interest is a little smaller, and more of your payment goes to principal. That repeats until the final payment brings the balance to zero.

What is a loan amortization schedule?

It's a table with one row per payment, showing the payment amount, interest portion, principal portion and remaining balance. It gives you a full map of the loan from start to finish. You can see yours by opening the schedule above. Many lenders can also give you a schedule on request, though yours may reflect your specific payment dates.

What is the loan amortization formula?

The monthly payment is M = P x r(1 + r)^n / ((1 + r)^n - 1), where P is the principal, r is the annual rate divided by 12 and n is the total number of months. For $20,000 at 6% over 5 years, r is 0.005, n is 60, and M comes to $386.66. Interest for each month is the current balance x r.

How do you calculate loan amortization in Excel?

Use =PMT(rate/12, years*12, -amount) for the payment. In a table, interest for a period is =balance*rate/12, principal is =payment-interest, and the new balance is =balance-principal. Fill those formulas down for every month. Excel's IPMT and PPMT functions can calculate the interest and principal for a specific period. Or simply download our schedule as an Excel file.

What does amortization mean on a mortgage?

It means your mortgage is paid off gradually through regular payments over its term, usually 15 or 30 years. A fully amortizing mortgage reaches zero at the end. The table above shows why equity builds slowly at first: after 10 years on a 30-year loan at 6.5%, you've paid off only about 15% of the original balance.

What is the difference between amortized and unamortized loans?

An amortized loan pays down principal with every payment and reaches zero at the end. An unamortized or interest-only loan has you pay only interest, or less, for a period, so the balance doesn't fall, and you may owe a balloon payment. Payments are lower at first, but the debt remains. Credit cards and revolving lines aren't amortized in the usual sense.

What types of loans are amortized?

Most installment loans: fixed-rate mortgages, auto loans, student loans, personal loans and home equity loans. Their payment amounts can be calculated up front. Interest-only loans, balloon loans and credit cards work differently. Adjustable-rate mortgages also amortize, but their payments are recalculated when the rate changes, so one schedule can't predict the whole loan.

How do extra payments change amortization?

An extra payment reduces principal right away, so all later months charge less interest, and the loan ends sooner. Your required payment usually stays the same unless you recast. Tell your lender to apply extra money to principal. Early extra payments have the greatest effect, since the savings compound for the rest of the loan's life.

Why do I pay more interest at the beginning of a loan?

Because interest is calculated on your balance, and it's highest at the start. Your lender isn't charging a different rate. On a $100,000 loan at 6.5%, the first month's interest is about $542, and it falls as the balance falls. That's also why a loan's early payments reduce your debt so slowly, especially over long terms.

What is negative amortization?

It happens when a payment doesn't cover the month's interest. The unpaid interest gets added to the balance, so you owe more over time even while paying. Some older adjustable mortgages and certain student loan situations can do this. It can be dangerous, since your debt grows. Check your statement: if your balance is rising, ask your lender why.

What is the difference between amortization and depreciation?

Both spread a cost over time, but in different ways. Loan amortization is how you pay off debt. In accounting, amortization can also mean expensing an intangible asset, such as a patent, over its life. Depreciation expenses a physical asset, such as equipment, over its useful life. This calculator is for loans, not for tax or accounting schedules.

More loan calculators

Home & land

Mortgage payments with taxes and insurance, home equity loans and HELOCs, and land loans with a balloon.

Cars & vehicles

Start from the price: down payment, trade-in, sales tax, and what owning it really costs a month.

Personal, business & school

Fees that raise the true APR, whether a business loan pays for itself, interest while in school and what card minimums cost.

Pay off & refinance

Full schedules, extra payments, refinancing break-even and the fastest order to clear several debts.