Loan Calculator
Work out your payment, the total interest and the payoff date, then see every payment in a schedule.
Added to every regular payment. It shortens the loan and, at any rate above 0%, lowers the interest.
Write it as YYYY-MM-DD. Leave empty to start one payment period from today.
Changes how amounts are shown. Nothing is converted.
Results
- Monthly payment
- $386.66
- Total interest
- $3,199.35
- Total paid
- $23,199.35
- Loan amount plus interest.
- Payoff date
- –
- Number of payments
- 60
Payment schedule
| No. | Date | Payment | Principal | Interest | Extra | Balance |
|---|---|---|---|---|---|---|
| 1 | – | $386.66 | $286.66 | $100.00 | $0.00 | $19,713.34 |
| 2 | – | $386.66 | $288.09 | $98.57 | $0.00 | $19,425.25 |
| 3 | – | $386.66 | $289.53 | $97.13 | $0.00 | $19,135.72 |
| 4 | – | $386.66 | $290.98 | $95.68 | $0.00 | $18,844.74 |
| 5 | – | $386.66 | $292.44 | $94.22 | $0.00 | $18,552.30 |
| 6 | – | $386.66 | $293.90 | $92.76 | $0.00 | $18,258.40 |
| 7 | – | $386.66 | $295.37 | $91.29 | $0.00 | $17,963.03 |
| 8 | – | $386.66 | $296.84 | $89.82 | $0.00 | $17,666.19 |
| 9 | – | $386.66 | $298.33 | $88.33 | $0.00 | $17,367.86 |
| 10 | – | $386.66 | $299.82 | $86.84 | $0.00 | $17,068.04 |
| 11 | – | $386.66 | $301.32 | $85.34 | $0.00 | $16,766.72 |
| 12 | – | $386.66 | $302.83 | $83.83 | $0.00 | $16,463.89 |
Everything runs in your browser. Nothing you type is sent to us.
This calculator gives estimates for planning. It is not financial advice.
A loan calculator turns a loan amount, an annual interest rate and a term into a regular payment. Enter the three numbers and choose how often you pay. It then shows the payment, the total interest, the total you repay and the payoff date. An optional extra payment shows how much interest and how many payments you save, and an amortization schedule lists every payment.
Borrow $20,000.00 at 6% for 5 years and the regular payment is $386.66. Adding $100.00 to every payment clears the loan on 2030-11-15, 13 payments early, and saves $754.99 in interest.
How to use the calculator
- Enter the Loan amount and the Annual interest rate (%).
- Set the loan term in Years, and add Extra months (optional) if it is not a whole number of years.
- Choose the Payment frequency: monthly, every two weeks or weekly.
- To test an overpayment, enter an Extra payment each period (optional). Optionally enter the First payment date, and choose the Currency.
- Read the Results: the payment, Total interest, Total paid, Payoff date and Number of payments. With an extra payment you also see Interest saved and Payments saved.
- Open the Payment schedule (the amortization schedule) and pick the year in Year shown. Select Download CSV for every payment, or Copy link to share the same inputs.
How it works
The calculator works out a level payment. The rate for one payment period is the annual rate divided by the number of payments in a year: 12, 26 or 52. The payment is set for the term in months times the payments a year, divided by 12 and rounded to a whole number of payments. In some countries the regular payment is called an EMI (equated monthly installment) or a repayment.
Each period it charges interest on the remaining balance, takes that interest out of the payment and uses the rest to repay principal. The last payment pays exactly what is still owed. The regular payment is rounded up to the currency’s minor unit, and raised by one more unit when that is still not enough, so the last payment is never larger than the others. Without an extra payment it is often a little smaller, and the difference grows with the rate and the term. At high rates or over very long terms the loan can end before the full term. The Payment schedule shows the exact last payment and the payoff date. With an extra payment the loan ends early, so the last payment is usually much smaller. Amounts use the currency’s minor unit from the ISO 4217 table: two decimals for most currencies, three for currencies such as KWD and none for currencies such as JPY. Interest is rounded half up to that unit.
An extra payment is added to every regular payment and goes entirely to principal. Interest saved and payments saved compare the schedule with the same loan without the extra payment.
The payment schedule, also called an amortization schedule, lists every payment with its date, the amount, the part that repays principal, the interest, any extra payment and the balance after it.
Payment dates are calendar days in UTC, so your time zone never shifts a date. Monthly payments keep the day of the month of the first payment and fall on the last day of shorter months. Every-two-weeks and weekly payments step 14 and 7 days.
The formula
The level payment is:
Payment = P × r / (1 − (1 + r)^−n)
- P is the loan amount.
- r is the rate for one payment period: the annual rate as a decimal divided by payments a year (for monthly payments, divide the annual rate by 12).
- n is the number of payments in the term.
At a 0% rate there is no interest, and the payment is P / n. The interest in each period is the balance before the payment times r. This is the same calculation as the spreadsheet function PMT before the payment is rounded up to the minor unit. The calculator’s tests check these cases against independent values.
Payment frequency
| Payment frequency | Payments a year | Rate for one period | Payment dates |
|---|---|---|---|
| Monthly | 12 | annual rate ÷ 12 | Same day each month, or the last day of a shorter month |
| Every two weeks (fortnightly) | 26 | annual rate ÷ 26 | Every 14 days |
| Weekly | 52 | annual rate ÷ 52 | Every 7 days |
The worked example pays monthly: $20,000.00 is repaid in 60 payments of $386.66 without the extra payment. The last of them is a little smaller.
What the calculator assumes
- The rate is a fixed nominal annual rate, compounded once per payment period.
- Payments are level. The first one falls on the First payment date you enter, or one payment period after today when you leave it empty.
- Fees, insurance, taxes and penalties are not included.
- The currency list changes only how amounts are written. It does not convert money.
- Your lender’s offer and contract set the actual rate, fees and payments, so they can differ from these estimates. Lenders may also count days or round differently.
- Results are estimates for planning. They are not financial advice.
Sources
- What is a prepayment penalty? (Consumer Financial Protection Bureau, United States; last reviewed 2024-09-11; accessed 2026-11-14). Supports: some loans charge a prepayment penalty.
- Consumer credits and loans (Your Europe, European Union; last checked 2026-06-30; accessed 2026-11-14). Supports: the right to repay consumer credit early in the European Union, and the lender’s compensation, which the law caps.
- PMT function (Microsoft Support; no date on the page; accessed 2026-11-14). Supports: the level-payment formula.
- PMT (Google Docs Editors Help; no date on the page; accessed 2026-11-14). Supports: the same PMT function in Google Sheets.
- Global Financial Data Standards, ISO 4217 currency codes (SIX, maintenance agency for ISO 4217; accessed 2026-11-14). Supports: the currency codes and the minor units amounts are rounded to.
Your numbers stay on your device
The calculation runs in your browser. Nothing you enter is sent to us. The page address stores your inputs after a # sign, which browsers never send to a server, so you can copy the link to share the same calculation or to come back to it. The CSV is built on your device too.
Worked example
Inputs
- Loan amount
- $20,000.00
- Currency
- USD
- Annual interest rate
- 6%
- Term
- 5 years
- Payment frequency
- monthly
- Extra payment each period
- $100.00
- First payment date
- 2027-01-15
Results
- Regular payment
- $386.66
- Last payment
- $58.00
- Total interest
- $2,444.36
- Total paid
- $22,444.36
- Number of payments
- 47
- Payoff date
- 2030-11-15
- Interest saved by the extra payment
- $754.99
- Payments saved
- 13
Frequently asked questions
How is a loan payment calculated?
The regular payment is the same every period, and the last payment clears what is left. It depends on the loan amount, the rate for one payment period and the number of payments. For $20,000.00 at 6% over 5 years, the regular payment is $386.66, and the extra payment of $100.00 is added on top.
Why does more of each early payment go to interest?
Interest for each period is charged on the balance still owed, and the balance is largest at the start. So early payments carry the most interest, and each payment shifts more toward principal. On long loans or at high rates, most of an early payment can be interest. The amortization schedule shows the split for every payment.
What happens to my loan if I add an extra payment each period?
Extra amounts go straight to the balance, so the loan ends sooner. With $100.00 extra each period, the example ends after 47 payments instead of 60 and saves $754.99 in interest. Some loans charge for early repayment. In the European Union you have the right to repay most consumer credit early, but the lender may ask for limited compensation.
Do weekly or every-two-weeks payments change the result?
Only slightly. For every two weeks (fortnightly) or weekly, the calculator divides the annual rate by 26 or 52 and recalculates a level payment for the same term, which lowers total interest slightly. Paying half the monthly payment every two weeks is different: it adds one extra monthly payment a year. Test that with the Extra payment field.
Why is my lender's payment different from the result?
Lenders can differ in how they count days, round and treat the first period, and some include fees, insurance or taxes in the payment. This calculator leaves those out and uses a fixed rate with level payments. Enter the nominal annual rate, not an APR: an APR includes some fees, so it would overstate the payment.
Can I enter a flat interest rate in this calculator?
No. This calculator charges each period's interest only on the balance still owed (reducing balance). A flat rate charges interest on the original amount for the whole term, so the same quoted number costs more as a flat rate. If a lender quotes a flat rate, ask for the equivalent reducing-balance annual rate and enter that.
How do I calculate a loan payment in Excel or Google Sheets?
Use the PMT function: enter =-PMT(rate/12, years*12, amount) for monthly payments. Divide the annual rate by the number of payments a year and multiply the years by the same number. The schedule's CSV download opens in both programs, so you can compare the two line by line.
Can this calculator handle a variable rate or an interest-only loan?
No. It uses one fixed rate for the whole term and level payments, with a last payment that clears the balance. For a variable rate, run it again with the new rate and the remaining balance and term. An interest-only period needs a different calculation.

