Skip to content
OneTooling

Loan & Mortgage Calculator

Calculate loan or mortgage payments, total interest, and a full amortization schedule with extra payments. Export it as CSV. Runs in your browser.

Runs in your browser · nothing uploaded

Paid on top of the regular payment, all of it going to the balance.

Monthly payment

1,580.17

Total interest

318,861.22

Total paid

568,861.22

Interest is 128% of the amount

Principal and interest paid each year

14710131619222528
Principal Interest

Amortization schedule

Show
YearPaymentPrincipalInterestBalance
118,962.042,794.3116,167.73247,205.69
218,962.042,981.4515,980.59244,224.23
318,962.043,181.1315,780.91241,043.10
418,962.043,394.1715,567.87237,648.93
518,962.043,621.4915,340.55234,027.44
618,962.043,864.0315,098.02230,163.42
718,962.044,122.8114,839.23226,040.61
818,962.044,398.9214,563.12221,641.69
918,962.044,693.5214,268.52216,948.17
1018,962.045,007.8613,954.18211,940.32
1118,962.045,343.2413,618.80206,597.07
1218,962.045,701.0913,260.95200,895.99
1318,962.046,082.9012,879.14194,813.09
1418,962.046,490.2812,471.76188,322.80
1518,962.046,924.9512,037.09181,397.85
1618,962.047,388.7311,573.31174,009.13
1718,962.047,883.5611,078.48166,125.56
1818,962.048,411.5410,550.50157,714.02
1918,962.048,974.889,987.16148,739.15
2018,962.049,575.949,386.10139,163.21
2118,962.0410,217.268,744.78128,945.95
2218,962.0410,901.538,060.51118,044.42
2318,962.0411,631.627,330.42106,412.80
2418,962.0412,410.616,551.4394,002.18
2518,962.0413,241.785,720.2680,760.41
2618,962.0414,128.604,833.4466,631.80
2718,962.0415,074.823,887.2251,556.98
2818,962.0416,084.412,877.6335,472.57
2918,962.0417,161.611,800.4318,310.96
3018,962.0418,310.96651.080.00

For learning and rough planning only. Real loans may add fees, insurance, taxes, or different rounding, so check the figures with your lender.

Why is there an ad? This tool is free and runs on your device. One small ad pays for hosting and new tools. No pop-ups, no autoplay, never inside the tool. How we make money

How to calculate a loan or mortgage payment

  1. Enter the loan amount, the yearly interest rate, and the term in years or months.
  2. Optionally add an extra monthly payment to see how much sooner you would finish and how much interest you would save.
  3. Read the monthly payment and total interest, then browse the schedule by year or by month.
  4. Use "Download CSV" to open the full month-by-month schedule in a spreadsheet.

Terms up to 100 years are supported. The calculator assumes equal monthly payments at a fixed rate, with interest charged each month on the remaining balance.

Questions

Is my loan information stored or sent anywhere?

No. The figures are worked out in your browser while you type. Nothing is uploaded, saved, or tracked.

How is the monthly payment calculated?

The calculator uses the standard fixed-rate formula: payment = P × r ÷ (1 − (1 + r)^−n), where P is the amount, r is the monthly rate (the yearly rate divided by 12), and n is the number of monthly payments. At a rate of 0% the payment is simply the amount divided by the number of months.

What does an extra payment do?

Every extra amount goes straight to the balance, so the next month charges less interest. The loan ends sooner and total interest drops. The page shows how much interest and how many months you would save compared with no extra payments.

Why does most of my early payment go to interest?

Interest is charged on the remaining balance, which is highest at the start. As the balance falls, the interest part of each equal payment shrinks and the principal part grows. The chart and schedule show this shift year by year.

Does this include taxes, insurance, or fees?

No. It covers principal and interest on a fixed-rate loan only. Property tax, insurance, fees, and variable rates are not included, so real payments can differ. This page is for learning and rough planning, not financial advice.

Credits

Built by OneTooling using standard browser features. No third-party code runs on your data.