Account

What new tool do you want?

Loans & Real Estate

Amortization Schedule Calculator

Generate a full month-by-month amortization schedule showing each payment's principal, interest and remaining balance — downloadable as CSV.

For information and education only — not financial advice. Results are estimates based on the numbers you enter; check important decisions with a qualified professional.

How to use

  1. 1Enter the loan amount, rate and term.
  2. 2Scroll the monthly table or download it as a CSV for Excel or Google Sheets.

How it's calculated

Each month: interest = balance × rate ÷ 12; principal = payment − interest; new balance = balance − principal.

Frequently asked questions

Why is so much of my early payment interest?

Interest is charged on the remaining balance, which is largest at the start. As the balance falls, more of each payment goes to principal.

When do I start paying more principal than interest?

It depends on the rate and term. The schedule's 'principal' and 'interest' columns show exactly when they cross.

Can I add extra payments?

Yes — enter a monthly extra payment to see how the schedule shortens.

Why the crossover point between principal and interest isn't halfway through the loan

Because interest is charged on the remaining balance each month, the point where a payment's principal portion first exceeds its interest portion arrives well past the loan's halfway mark in years, even though the payment itself never changes — a 30-year loan can easily spend 15 or more years with interest as the larger share of each payment, depending on the rate.

Worked example: Amortization Schedule Calculator

A $200,000 loan at 6.5% over 30 years has a monthly payment of $1,264.14 and accrues $255,088.98 in total interest across all 360 payments — more interest paid than the original loan amount. Adding a monthly extra payment shortens that 360-payment schedule directly, since every extra dollar reduces the balance that the next month's interest is calculated on, visible row by row in the generated schedule.

Why downloading the CSV matters more than scrolling the table

A full 360-row amortization schedule is unwieldy to review on screen, but it's exactly the kind of record a mortgage servicer, accountant, or divorce settlement sometimes needs in spreadsheet form — exporting to CSV preserves every month's exact principal, interest and balance figures for import into Excel or Google Sheets, where they can be filtered, charted or cross-checked against actual statements.

Why the payment never changes even as the balance shrinks

A fixed-rate loan's monthly payment is calculated once, at the start, to be exactly the amount that fully pays off the loan over the term at a constant rate — the fact that the principal-versus-interest split shifts every month while the total payment itself stays flat is simply how amortization achieves a level payment despite a shrinking balance and constant rate. Understanding this is what makes it clear why an 'extra payment' works the way it does: it doesn't change the required monthly payment at all, it just accelerates how fast the balance (and therefore future interest) falls.

Why an extra payment's benefit compounds the earlier it's made

A dollar of extra principal paid in month 2 saves interest on that dollar for the next 358 months of the loan, while the same extra dollar paid in month 300 only saves interest for the remaining 60 months — which is why making extra payments as early as possible in the loan's life produces dramatically more total interest savings than the same total extra amount paid later, even though the dollar amount contributed is identical either way.

Related tools

More: Loans & Real Estate