Skip to content
LoveToCalc

Loan calculator

Find your monthly payment, what the loan costs in interest and how equal payments compare with equal principal. Put two rates or terms side by side and see the difference.

Your numbers

Repayment

The same payment every month (annuity). The interest part shrinks over time.

Result

Monthly payment

$495

Put a second set of numbers beside this one and see the difference.

Total interest
$4,702
Total cost
$29,702
Final payment
$495

You pay $495 a month for 5 years — $29,702 in total, of which $4,702 is interest.

The interest rate is a nominal annual rate, charged monthly. Payments are made at the end of each month. Fees and changes in the rate are not included.

Monthly payment at other rates

Same amount, term and repayment type; only the rate changes.

Interest rateMonthly paymentTotal interestDifference per month
5%$472$3,307-$23
6%$483$3,999-$12
7%Your rate$495$4,702$0
8%$507$5,415+$12
9%$519$6,138+$24

Payments per year

Show year-by-year table
YearPrincipalInterestBalance left
1$4,327$1,613$20,673
2$4,640$1,300$16,032
3$4,976$965$11,057
4$5,335$605$5,721
5$5,721$219$0
Download the month-by-month schedule

The CSV uses commas between fields and a decimal point. In the Excel file the numbers are plain numbers, which Excel shows in your own format.

The Excel sheet recalculates when you change the numbers in the blue cells. The CSV holds the values only.

Ready-made template with example numbers: Loan amortization schedule in Excel

Loan payment in Excel: PMT

The same calculation in one cell, with your numbers. Paste it into Excel:

=PMT(7%/12,5*12,-25000)

In Swedish Excel the function is called BETALNING. There the arguments are separated by semicolons and decimals written with a comma. Google Sheets uses the English names whatever the language.

The minus sign is not a mistake. Excel tells money coming in from money going out by its sign, so one of the amounts is negative. Flip the signs and the answer flips too.

How loan payments work

Every payment on a loan has two parts: interest on the balance you still owe, and principal that pays the balance down. How the two are split depends on the repayment method.

Formula

The calculator uses the nominal annual rate divided by twelve as the monthly rate.

i = r / 12,   n = 12 · t

Equal payments: PMT = A · i / (1 − (1 + i)−n)

Equal principal, month k: PMTk = A/n + i · (A − (k − 1) · A/n)

Example

You borrow $25,000 at 7% for 5 years:

The term is yours to choose

The lender sets the rate, and what you can do about it is compare offers and negotiate. The term you choose yourself, and it decides much of what the loan costs. The same $25,000 at 7%:

Term Monthly Total interest
2 years $1,119 $1,864
3 years $772 $2,789
5 years $495 $4,702
7 years $377 $6,695
10 years $290 $9,833

Read the table from the bottom up. Going from ten years to five raises the payment by $205 a month and cuts the interest by $5,131. The monthly figure flattens out — seven years to ten saves only $87 a month — while the interest keeps climbing. A term longer than you need is expensive without feeling expensive, because the only number you see each month is the smaller one.

The reverse is true too: a term you cannot carry is not cheap, it is a missed payment. Pick the shortest one you are sure you can live with, not the shortest one you can imagine.

Your loan at different interest rates

The same $25,000 over 5 years at different rates:

Rate Monthly Total interest
3% $449 $1,953
5% $472 $3,307
7% $495 $4,702
9% $519 $6,138
11% $544 $7,614

Two percentage points is about $24 a month and about $1,400 over five years. That is the argument for getting quotes from more than one lender: a gap that is small per month adds up over the whole term.

You do not have to rerun the calculator for every rate. Under the result it shows the same table for your own loan: the monthly payment and the total interest at your rate and at two percentage points either side. It updates when you change the amount, the term or the repayment type. To see two rates with every figure next to each other, compare 7% and 5% side by side and then set one column to the rate you have been offered.

Why almost all of it is interest at the start

Interest is charged on what you owe, and at the start you owe everything. The first payment on the loan above is $495, of which $146 is interest and $349 is principal. By the last payment the ratio is the other way round.

This is why two things feel wrong but are correct: the balance barely moves in the first year, and an extra payment early in the loan is worth far more than the same payment late. The chart under the calculator shows the split year by year.

Equal payments or equal principal

Equal principal always costs less in total interest at the same rate and term, because the balance falls faster from the first month. On the loan above the difference is $254 over five years. The price is a payment $68 higher at the start.

Which one is cheaper is settled, then, and the choice is about which one you can carry. Equal payments are predictable and easy to put in a budget. Equal principal is cheaper for anyone who can handle the heaviest month, and gets easier every year. Many lenders offer only one of the two.

Paying a little extra each month

Anything you pay above the scheduled amount goes straight onto the balance, and all later interest is charged on a smaller number. The same loan, $25,000 at 7% over 5 years:

If you want to run it the other way — “I can pay $X a month, when am I debt free?” — the debt payoff calculator does exactly that. Check your terms first: some loans, fixed-rate ones especially, carry a prepayment charge.

What the calculator does not include

Setup fees, monthly fees, insurance and changes in a variable rate are not included. The APR a lender quotes may include fees and can therefore be higher than the interest rate used here. Real schedules round each payment to the cent, so the lender’s totals can differ by a few cents.

To put the fees in, use the total cost of a loan — the same loan at the same rate, with the arrangement fee and the monthly fee counted into what it costs.

Frequently asked questions

Which is cheaper, equal payments or equal principal? Equal principal always costs less in total interest for the same rate and term, because you pay the balance down faster. The trade-off is higher payments at the start of the loan.

Why is so much of my payment interest at the start? Interest is charged on the balance you still owe. At the start the balance is at its highest, so the interest part is largest. With equal payments, the principal part grows every month as the balance falls.

Should I take a shorter term or pay extra? Arithmetically they are close to the same thing — both bring the balance down faster. The difference is the commitment: a short term locks in a high payment, while an extra payment is voluntary every month. If you are unsure what a bad month looks like, take the longer term and pay extra when you can.

Why doesn’t the payment halve when I double the term? Because the interest runs for twice as long. Only the principal part of the payment halves; the interest part grows, since you owe more for longer. So ten years instead of five gives a payment around 60% as large — and more than twice the interest.

What does nominal interest rate mean? It is the annual rate the lender quotes, converted to a monthly rate by dividing by twelve. The APR is a different number: it includes fees and is normally higher. This calculator works from the nominal rate.

Does it work for a mortgage? The arithmetic is the same, so the payment and the interest are right. What it leaves out is anything local: required amortisation, tax relief on interest, fixed-rate periods or an escrow account for property tax and insurance. Treat the result as the cost of the loan itself, not of owning the house.

Last reviewed October 6, 2026 ·How pages are reviewed

The formula behind this

All loans calculators

Put this calculator on your site

Copy the code into your page where the calculator should appear. It loads from lovetocalc.com, so it stays current on its own — all we ask is that the credit line comes with it.