Loan / EMI Calculator

This loan calculator works out the regular repayment on a fixed-rate loan, known as the EMI (equated monthly instalment) in India and much of Asia. Enter how much you are borrowing, the yearly interest rate and the term, then choose monthly, fortnightly or weekly repayments. You instantly see the repayment, the total interest, the total you will pay back and how long it takes.

It is built for home loans and mortgages, car loans, personal loans and student loans. A chart shows how each year’s payments split between paying off the loan and paying interest, and the amortisation schedule (the table that shows how each repayment reduces what you owe) lists every year, opening up to every single repayment when you tap a year.

Add an extra amount to each repayment and the calculator shows how much sooner the loan is cleared and how much interest you save. Press “Download CSV” and the whole schedule, every single repayment with its interest, extra payment and balance, opens in Excel, Numbers or Google Sheets. Amounts start in your local currency; 30 others are a tap away. Everything runs in your browser, so nothing you type is sent anywhere. It is an estimate for planning, not financial advice.

1. Type the loan amount and, if needed, change the currency in the list next to it.
2. Enter the yearly interest rate, for example 6.25, and the term in years and months.
3. Choose how often you repay: monthly, fortnightly or weekly.
4. Read the repayment, total interest, total paid and payoff time. They update as you type.
5. Optionally type an extra repayment to see the time and interest saved.
6. Scroll to the chart and schedule. Tap a bar for that year’s figures, or tap a year in the table to see each repayment.
7. Press “Download CSV” to save every repayment as a spreadsheet file.

• The standard repayment (amortisation) formula used by banks for fixed-rate loans: P = A × r ÷ (1 − (1 + r)^−n).
• Monthly, fortnightly (26 a year) and weekly (52 a year) repayments.
• Total interest, total paid, number of repayments and time to pay off.
• Extra repayments each period, with the time saved and interest saved worked out against the normal schedule.
• Year-by-year schedule that opens to show every repayment: amount paid, amount off the loan, interest and balance left.
• CSV download of the full schedule: one row per repayment with the scheduled amount, any extra repayment in its own column, interest, running interest total and balance.
• A principal vs interest bar chart drawn on the page, which you can explore by tapping, hovering or using the arrow keys.
• Your local currency picked automatically from your browser, with 30 currencies to choose from.

• Fortnightly here means the yearly rate split across 26 fortnights. Paying half the monthly amount every fortnight instead adds up to one extra monthly payment a year: model it with an extra repayment.
• Compare loans by total interest, not just the repayment: a longer term lowers each payment but can add tens of thousands overall.
• Fees, offset accounts, redraw and variable rates are not included. Ask your lender for a comparison rate, which bundles most fees into one figure, and put that in the rate box for a closer estimate.
• The CSV holds plain numbers with no currency signs, so spreadsheet formulas work on it straight away. The currency code is in each column heading.
• Terms from 1 month to 50 years are supported. The repayment shown is rounded to the nearest cent, so the last one may be a few cents different.