Loan Calculator with Amortization Schedule

Calculate your monthly payment and see a complete amortization schedule — principal, interest, and balance for every month, with CSV export.

Loan calculator with a full amortization schedule

Enter your loan amount, annual interest rate, and term in years, then click Calculate. You'll get your estimated monthly payment plus a complete amortization schedule showing how every payment splits between principal and interest — and how your balance falls to zero over the life of the loan.

How to use this calculator

Enter the total amount you plan to borrow. Input the annual interest rate offered by your lender. Set the loan term in years (for example, 30 for a typical mortgage). Click Calculate to see your monthly payment, total interest, total cost, and the month-by-month amortization table. Switch the table between Yearly and Monthly views, and use Export CSV to download the full schedule.

Understanding your amortization schedule

An amortization schedule lists every scheduled payment across the life of the loan. Each row shows the payment amount, how much goes to interest, how much reduces the principal, and the remaining balance afterward.

Early in the loan, most of each payment goes toward interest because interest is charged on a larger outstanding balance. As the balance falls, the interest portion shrinks and more of each payment reduces the principal. This is why extra payments made early save the most interest.

The monthly payment shown covers principal and interest only. It does not include property taxes, homeowners insurance, HOA dues, or mortgage insurance, so your real-world payment may be higher.

Why the amortization table matters

Seeing the full schedule helps you compare loan terms, understand how much interest you'll actually pay, and decide whether extra payments are worth it. Exporting the schedule to CSV lets you keep a record or run your own what-if analysis in a spreadsheet.

Loan Calculator with Amortization Schedule FAQ

What is an amortization schedule?

An amortization schedule is a table listing every payment over the life of a loan. Each row shows how much of that payment goes to interest, how much goes to principal, and the remaining balance after the payment. By the final row, the balance reaches zero.

How is my monthly payment calculated?

The calculator uses the standard amortization formula based on your loan amount, monthly interest rate, and number of payments. Each payment is the same amount, but the split between interest and principal changes every month as the balance falls.

Why does most of my early payment go to interest?

Interest is charged on the outstanding balance, which is highest at the start of the loan. So early payments are mostly interest. As you pay down the balance, the interest portion drops and more of each payment goes to principal.

Does this calculator include taxes and insurance?

No. It estimates principal and interest only. Property taxes, homeowners or mortgage insurance, HOA fees, and closing costs are not included, so confirm your full monthly cost with your lender.

Can I export the amortization schedule?

Yes. Click **Export CSV** to download the full month-by-month schedule. You can open it in Excel, Google Sheets, or Numbers to keep a record or run your own scenarios.

Related loan calculators

This calculator provides an estimate for principal and interest only and excludes taxes, insurance, and fees. Consult your lender for exact terms.