Loan EMI calculator with a full repayment schedule
This is a free loan EMI calculator that does more than just tell you the monthly instalment. It generates a complete month-by-month amortisation schedule showing exactly how each payment is split between principal and interest, how the outstanding balance falls, and — if you have a moratorium period — how interest accrues or is capitalised during that time. Everything runs in your browser. No signup, no account, nothing sent to any server.
Most online EMI calculators give you a single number. This one gives you the underlying table that a lender would produce, month by month, so you can plan repayments, compare loans, verify a bank's calculations, and understand where your money is actually going over the life of the loan.
How to use it
Enter the principal amount. This is the total amount borrowed, before any interest. For a ₹50 lakh home loan, enter 5000000.
Enter the annual interest rate. Use the reducing balance rate your bank quoted. For a flat rate loan, convert it to reducing balance first (a 10% flat rate is roughly 18% reducing balance).
Enter the tenure in months. A 20-year loan is 240 months. A 5-year car loan is 60 months.
Add a moratorium if applicable. Most education loans and some home loans have one. Enter 0 if not.
Choose whether the tenure includes the moratorium. Check your loan agreement. Most Indian banks quote tenure as EMI months excluding the moratorium.
Pick the moratorium type. Interest-only means you pay interest monthly during the moratorium and the balance stays flat. Full means no payment and interest is capitalised into the balance.
Review the results. The calculator shows monthly EMI, total interest, total payment and a full month-by-month schedule.
Export or share. Click Export to Excel to download an .xlsx file, or use the copy buttons for text output.
Understanding each input
Principal
The amount you borrow. If you take a ₹30 lakh home loan, the principal is ₹30,00,000. Interest is calculated on this amount, but as you repay, the balance falls and so does the interest component.
Annual interest rate
Expressed as a percentage per year. The calculator divides this by 12 to get the monthly rate. Always use the reducing balance rate for accurate results — flat rate quotes are misleadingly low.
Tenure
The number of monthly instalments. Longer tenure means a smaller EMI but a much larger total interest. A 20-year loan can cost 2–3× the principal in interest alone.
Moratorium period
A grace period at the start where you don't repay principal. Common in education loans, some home loans, and project finance. Can be anywhere from 3 months to several years.
Moratorium type
Interest-only — you pay interest each month but the principal balance stays the same. This is what most banks use.
Full moratorium — you pay nothing, and the interest accrues and is added to your balance. When EMI starts, you're paying interest on a larger principal.
First EMI date
Affects only the month labels in the schedule. Useful when you want the schedule to line up with your actual repayment calendar.
This is the reducing balance formula. It assumes interest is charged on the outstanding balance each month, not the original principal. That's how almost all modern loans work.
Every EMI is the same amount, but its composition changes over time. In the early months, most of the EMI goes to interest. In the last months, most goes to principal. The schedule shows this shift month by month.
Understanding the schedule columns
Principal repayment — the portion of each instalment that reduces the loan balance. Summed across the entire schedule, this always equals the original loan amount.
Interest payment — the portion of each instalment that goes to interest. This is cash you actually hand over to the lender.
Interest capitalised — only present in a full moratorium. It's interest that accrued but wasn't paid, and was instead added to the outstanding balance. It becomes part of what you repay later, but it's tracked separately from principal for accounting clarity.
Total instalment — cash paid that month. Zero during a full moratorium, the monthly interest during an interest-only moratorium, and the full EMI during the repayment phase.
Principal balance — the outstanding loan amount after that month's payment.
How the totals reconcile
Every column's total equals the sum of its rows — nothing is hidden or double-counted.
Principal repayment total = original loan amount.
Interest payment total = interest actually paid in cash (EMI phase interest, plus any interest paid during an interest-only moratorium).
Interest capitalised total = interest accrued but rolled into the balance during a full moratorium. Not paid as cash, but becomes part of what you repay.
Total instalment total = cash paid out of pocket across the whole loan. Because capitalised interest was never paid as cash, it doesn't appear here.
When a full moratorium is used, the principal repayment column in the EMI phase sums to more than the original principal — because it also repays the capitalised interest that grew the balance. The capitalised interest appears in its own column so the schedule stays honest.
Check your loan agreement to know which your bank uses. Most Indian home loan lenders quote exclude — a "20-year loan" means 240 EMIs starting after the moratorium. Some project finance and education loan products quote include — a "10-year loan" means the whole thing is over in 120 months, moratorium and repayment combined.
Common real-world uses
Home loan planning. Compare a 15-year vs 20-year tenure for the same amount and see how much extra interest the longer tenure costs.
Car loan comparison. Check whether a lower interest rate from one dealer is actually better than a longer tenure from another.
Education loan budgeting. Understand how much interest will accrue during the course and moratorium before repayment begins.
Verifying a bank's numbers. Banks occasionally issue schedules that don't reconcile. This calculator lets you check their math.
Prepayment planning. See the month-by-month balance to decide when a lump-sum prepayment would save the most interest.
Refinance decisions. Compare the total cost of your existing loan against a new offer with a lower rate or shorter tenure.
Business loan analysis. Model cash flow requirements against monthly EMI obligations.
Tax planning. Home loan interest is tax-deductible in many countries. The schedule shows how much interest you pay each financial year.
Reducing balance vs flat rate
This calculator uses the reducing balance method, which is standard for almost all modern loans. But some lenders — particularly in certain segments of car finance and personal loans — quote a flat rate, which sounds much cheaper than it is.
Reducing balance: interest is charged only on the outstanding principal, which falls every month. As the loan matures, the interest portion of each EMI falls.
Flat rate: interest is charged on the full original principal for the entire tenure. Even in the last month, you're paying interest as if you still owed the full amount.
A 10% flat rate is roughly equivalent to 18% on reducing balance. Always convert flat rate quotes to reducing balance before comparing loans.
Why use this calculator
Full schedule, not just one number. See every month's principal, interest, capitalised interest and balance.
Handles moratoriums properly. Most online calculators ignore moratoriums entirely or handle them badly.
Reconciling totals. Every column sums correctly. Nothing is hidden in a footnote.
Export to Excel. One click downloads the full schedule as a proper .xlsx file.
Shareable links. Every scenario has a URL you can bookmark or send to your financial advisor.
Privacy-first. Runs entirely in your browser. No uploads, no tracking, no account.
Works offline. After the first visit, the calculator works without internet.
What this calculator can't do
Being honest about limits is more useful than pretending they don't exist. This calculator does not:
Handle variable interest rates. It assumes a single fixed rate for the entire tenure. For floating rate loans, recalculate with the new rate from the change date — your bank will issue a revised schedule.
Model prepayment or part-payment. It assumes you pay exactly the EMI every month. Prepayment shortens the tenure or reduces the EMI, but the calculator doesn't simulate either scenario. Ask your lender for a revised schedule.
Calculate the effect of skipped EMIs. Missed payments trigger penalties and interest on arrears, which the calculator doesn't model.
Convert flat rate to reducing balance automatically. You need to make that conversion yourself or use a dedicated tool.
Include processing fees, insurance or other charges. The calculator shows only principal and interest. Add upfront costs manually for a full cost of borrowing.
Model step-up or step-down EMIs. Some loans allow increasing or decreasing instalments. The calculator assumes a constant EMI.
Calculate GST or tax implications. Use the GST calculator for tax computations.
Troubleshooting
Results don't appear. Check that principal, rate and tenure are filled in with valid numbers. The result card appears only when the inputs are complete.
"Moratorium cannot be greater than or equal to total tenure when included" — you've set the moratorium longer than or equal to the tenure in "include" mode. That leaves zero months for EMI. Either shorten the moratorium or switch to "exclude" mode.
Total interest looks very high. Check the tenure. Doubling the tenure roughly quadruples the total interest. A 20-year loan at 9% costs about 1.3× the principal in interest. A 30-year loan at the same rate costs about 2×.
The last EMI differs from the others. This is normal and expected. Rounding during the schedule means the final instalment is adjusted slightly to clear the balance to exactly zero.
Capitalised interest column shows zeros. That column only has values during a full moratorium. If you have no moratorium or an interest-only moratorium, it stays zero.
Export doesn't work. The Excel library loads from a public CDN. If your network blocks jsdelivr.net, the export will fail. Try the Copy schedule button instead, which works without any external library.
Inputs disappeared. Your inputs are stored in browser local storage. Private browsing or clearing browser data resets them.
Common questions
How is EMI calculated?
EMI = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), where P is the principal, r is the monthly interest rate and n is the number of monthly instalments.
What is a moratorium period?
A moratorium is a period at the start of the loan during which no principal is repaid. In interest-only moratoriums you pay interest monthly. In full moratoriums, interest accrues and is capitalised into the balance.
How is interest capitalised shown in the schedule?
Capitalised interest appears in its own column so the schedule reconciles. Principal repayment totals to the original loan amount, and interest totals include both paid and capitalised interest.
Can I export the schedule to Excel?
Yes. Click Export to Excel to download an .xlsx file with the full schedule and totals.
Should tenure include the moratorium?
It depends on how your bank quotes tenure. Most Indian banks quote tenure excluding the moratorium. Check your loan agreement or use the toggle to match.
Does this work for home, car and personal loans?
Yes. The formula is universal for any fixed-rate loan with equated monthly instalments.
Can I calculate a loan with variable interest rates?
Not directly. The calculator assumes a single fixed rate. If your rate changes, recalculate with the new rate from the change date.
Does the calculator handle prepayment?
No. It assumes you pay exactly the EMI every month. For prepayment analysis, ask your lender for a revised schedule.
What's the difference between reducing balance and flat rate?
Reducing balance charges interest only on the outstanding principal, which decreases each month. Flat rate charges interest on the full original principal for the entire tenure. A 10% flat rate is roughly equivalent to 18% reducing balance.
Why does the last EMI differ from the others?
Because of rounding. Each EMI is calculated to a fixed precision, but the amount needed to clear the balance on the last month is rarely an exact multiple. The schedule adjusts the final instalment to close to zero.
Are my inputs saved?
Yes. Your inputs are stored in your browser's local storage and restored when you return. Nothing is sent to any server.
Does this calculator work offline?
Yes. After the page loads once, the calculator works entirely offline.
Can I share a specific loan scenario?
Yes. Click Share link to copy a URL that reopens the calculator with all your inputs.
Is this calculator free?
Yes. Completely free, no signup, no account required, no limits on the number of calculations.
Related calculators
This calculator handles loan repayment. For savings, taxes and everyday math, these tools work the same way — free, in your browser, no signup.