Free tool • Runs in your browser
Loan calculator
Calculate monthly loan payments, total interest and a full amortisation schedule.
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
- Enter the loan amount.
- Enter the annual interest rate and term.
- Read the payment, total interest and schedule.
Example
100,000 at 12% a year for 12 months
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.