Loan Amortization Schedule Calculator

Generate detailed payment schedules with principal and interest breakdowns.

How to Use the Amortization Calculator

1

Enter loan details

Add loan amount, annual rate, term, frequency, and first payment date.

2

Generate schedule

Calculate payment, total interest, and payoff date with one click.

3

Review breakdown

See principal vs interest for each payment and export to CSV.

What is a Loan Amortization Schedule?

A loan amortization schedule shows every payment on your loan, how much goes to principal versus interest, and when the balance reaches zero. It is essential for understanding mortgages, auto loans, personal loans, and business financing.

By entering your loan amount, interest rate, term, and payment frequency, you get a full payoff plan with totals for interest and overall cost. Use it to budget, compare offers, and spot savings from refinancing or extra payments.

This calculator gives you a ready-to-export schedule so you can track payments, plan prepayments, and stay on top of your payoff timeline.

How the Amortization Calculator Works

The calculator uses the standard amortization formula: Payment = P × r × (1 + r)^n / ((1 + r)^n - 1), where P is principal, r is periodic interest (annual rate ÷ payments per year), and n is total payments.

Each payment is split into interest (on the remaining balance) and principal (reducing the balance). As the balance declines, interest shrinks and the principal portion grows. The schedule runs until the balance reaches zero on the payoff date.

Why the schedule matters

  • Shows true borrowing cost via total interest.
  • Reveals how payments shift from interest to principal over time.
  • Helps plan prepayments and refinancing decisions.

Why Use This Calculator?

Clarity on total cost

See monthly (or weekly) payments, total interest, and total amount paid across the loan.

Better budgeting

Predictable payments make it easier to align debt payoff with cash flow.

Refinance insights

Compare scenarios to see how lower rates or shorter terms change total interest.

Prepayment planning

Understand how extra principal payments can shorten the loan and cut interest.

When to Use an Amortization Schedule

Mortgage planning

Forecast monthly payments and equity build for home loans.

Auto and personal loans

See payment breakdowns for cars, personal credit, or consolidation loans.

Refinance comparisons

Model new rates or terms to understand savings before refinancing.

Investment properties

Track amortization for rentals and evaluate long-term cash flow

Extra payment impact

Assess how additional principal payments reduce total interest.

Frequently Asked Questions

It is a table showing each payment's split between principal and interest, along with remaining balance until payoff.

We use the standard amortization formula: Payment = P × r × (1 + r)^n / ((1 + r)^n - 1), where P is principal, r is periodic rate (annual rate ÷ payments per year), and n is total payments.

Yes, you can switch between monthly, bi-weekly, and weekly frequencies to see how payments change.

Use the Export CSV button in the schedule section to download the full table for your records.

Yes. If the rate is 0%, payments are simply principal divided by the number of periods.