Finance

Loan Amortization Calculator

Details

How to use Loan Amortization Calculator

What the tool does, how to run it, and what to expect from the result.

How to build a loan amortization schedule

Enter the amount borrowed, the annual interest rate, and the term in years. The calculator converts the rate to a monthly figure, applies the standard annuity formula to get a fixed monthly payment, and then walks the loan month by month, charging interest on the remaining balance and applying the rest to the principal.

You get the monthly payment, the total repaid, the total interest, and the full payment-by-payment schedule, which can be copied out as CSV.

  • Enter the loan amount, with no currency symbol or thousands separators.
  • Enter the annual interest rate as a percentage, for example 6 for 6 percent.
  • Enter the term in years; the schedule is capped at 1,200 monthly payments.
  • Read the monthly payment and, more importantly, the total interest over the life of the loan.
  • Click Copy schedule (CSV) and paste it into a spreadsheet if you want to model overpayments.
Tips

Getting a better result out of Loan Amortization Calculator

Specific settings and thresholds, not general advice.

  • The payment is the standard annuity formula: P times r over 1 minus (1 + r) to the power of minus n, where r is the annual rate divided by 12 and n is the number of monthly payments. A 0 percent rate is handled separately as the principal divided by the number of months, rather than dividing by zero.
  • Interest each month is charged on the remaining balance, which is why the split flips over the life of the loan. On a 250,000 loan at 6 percent over 30 years, the first payment is about 1,250 of interest and only about 250 of principal; you do not cross the halfway point until year 18 or so.
  • The final payment is adjusted to absorb the accumulated rounding so the balance lands exactly on zero. Your lender does the same thing, but they may round each month differently, so expect your real last payment to differ by a few units.
  • The schedule is capped at 1,200 payments, which is 100 years. That is not a real product; it exists so a mistyped term cannot lock the tab building a schedule.
  • Total interest is the number that should change your behaviour. At 6 percent over 30 years you repay roughly double what you borrowed, and paying even a little extra principal early cuts that total far more than the same amount paid in year 25, because interest compounds on what is left.
Limits

What Loan Amortization Calculator does not do

The honest boundary, so you do not lose time finding it yourself.

  • Monthly payments only; no weekly, fortnightly, or bi-weekly schedule.
  • No extra or lump-sum payments, no offset account, and no redraw.
  • Fixed rate for the whole term; no variable-rate or interest-only period.
  • No taxes, insurance, fees, or PMI, so this is principal and interest only.
At a glance

Who Loan Amortization Calculator is for

A quick way to understand who this helps, what it solves, and where it connects next.

Best fit

Borrowers reviewing a loan payment schedule.

Ideal for

Using the loan amortization calculator without installing anything or signing up.

FAQ

Common questions

Short answers for the questions people usually have before trying a utility like this.

Why does hardly any of my early payment go to the principal?

Because interest is charged on what you still owe, and at the start you owe almost everything. The monthly interest is the balance times the monthly rate, so on a 250,000 loan at 6 percent the first month's interest alone is 1,250. Your payment is fixed, so whatever is left after that interest goes to principal, which early on is very little. As the balance falls, the interest portion falls with it and the principal portion grows, which is why the curve accelerates in the later years.

Can I model overpaying my loan?

Not directly; there is no extra-payment field. You can approximate it by shortening the term and seeing what the payment becomes, which tells you what you would need to pay to clear the loan in, say, 25 years instead of 30, and how much interest that saves. The saving is usually far larger than people expect.

Why is my lender's payment slightly different from this one?

Rounding conventions and day counts. This calculator uses the annual rate divided by 12 for every month, whereas some lenders use a daily rate applied to the actual number of days in each month, and they may round each installment differently. The difference is normally a few units per payment. The shape of the schedule is right even if the last decimal is not.

Does a 0 percent rate work?

Yes. The annuity formula would divide by zero at a rate of 0, so that case is handled separately by dividing the principal evenly across the number of months. Every payment is then identical, all of it principal, and the total interest is zero.

What can I do with the CSV export?

Copy schedule (CSV) puts the whole payment-by-payment table on your clipboard with a header row of Payment, Amount, Principal, Interest, Balance, and with the thousands separators stripped so every value lands in its own cell. Paste it into a spreadsheet to chart the principal-versus-interest crossover, or to model what an overpayment would do.

Recommendations

You Might Also Like

Nearby tools from the catalog that fit the same job or workflow.

Cleanor app

Do it all on your device

Cleanor puts these tools in one app: compress and convert images, video, and audio, work with PDFs, and scan text right on your device. Plus free up storage and clear inbox clutter with Email Cleaner. Start with a free trial.

  • iPhone
  • Android
  • Macsoon
  • Windowssoon