Quecko Logo

Free tool • Runs in your browser

Loan calculator

Calculate monthly loan payments, total interest and a full amortisation schedule.

Loading tool...

Quick answer

Monthly payments use the standard reducing-balance formula. Each payment covers that month's interest first, and the rest reduces the balance, so interest falls over time.

How to use it

  1. Enter the loan amount.
  2. Enter the annual interest rate and term.
  3. Read the payment, total interest and schedule.

Example

Input
100,000 at 12% a year for 12 months
Output
Monthly payment 8,884.88
Total interest 6,618.55

Common errors and how to fix them

My bank's figure differs
Lenders may add fees or insurance, or round and calculate interest differently.

Frequently asked questions

How do I calculate a monthly loan payment?

Enter the loan amount, annual interest rate and term, and the monthly payment appears instantly.

What is the loan payment formula?

Payment = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), where P is the amount, r the monthly rate and n the number of months.

What is EMI and how is it calculated?

EMI is an equated monthly instalment, a fixed monthly payment. This calculator uses the standard reducing-balance formula.

How do I calculate a loan payment in Excel?

Use =PMT(annual_rate/12, months, -amount). For example, =PMT(12%/12, 12, -100000) gives about 8,884.88.

How much interest will I pay on my loan?

See the Total interest figure, which is everything you pay minus the amount you borrowed.

Can I use this as a home loan or mortgage calculator?

Yes, for the basic principal and interest payment. Real mortgages may also include insurance, taxes and fees.

What is an amortisation schedule?

It is a month-by-month table showing how each payment splits between principal and interest, and the balance left.

Why is my bank's payment different?

Lenders may include fees or insurance, or round and calculate interest differently. Confirm the exact terms with them.

Does it work with 0% interest?

Yes. The monthly payment is simply the amount divided by the number of months.

Is my loan information uploaded?

No. The calculation runs in your browser and nothing is sent to Quecko.

More calculators

Need something built for your business?

Quecko designs and builds AI, Web3 and custom software products.

Start a Project