Repayment Schedule Calculator
Use this free repayment schedule calculator to see exactly how each EMI is split between interest and principal. Enter your loan amount, interest rate and tenure, and you will get a complete month-wise table showing how your balance falls over time.
Whether you are planning a home loan, car loan or personal loan, the schedule helps you understand the true cost of borrowing, compare offers and plan prepayments with confidence.
Table of Contents
What is a Repayment Schedule Calculator?
A repayment schedule, also called an amortisation schedule, lists every instalment of a loan from the first month to the last. For each month it shows the EMI, how much of it is interest, how much repays principal, and the balance left after payment.
EMI = P x r x (1+r)^n / ((1+r)^n − 1), where r is the monthly rate and n is the number of months. Each month: interest = balance x r, principal = EMI − interest, and the balance falls. The last instalment adjusts for rounding. Total interest = EMI x n − P.
How to Use the Repayment Schedule Calculator (Step by Step)
- Enter loan amount, yearly rate, tenure in years.
- Press Calculate.
- Read EMI/total interest/total payment summary.
- Scroll the month-wise table.
Example Calculation
Rs 5,00,000, 9%, 5 years → EMI Rs 10,379.18; Month 1: Interest Rs 3,750.00, Principal Rs 6,629.18, Balance Rs 4,93,370.82; Total interest Rs 1,22,750.80.
Features
- Full month-wise amortisation table
- EMI + totals summary
- Any loan type
- Free, instant
Benefits
- See interest vs principal split
- Plan prepayments
- Verify bank schedules
- Loan comparison
Final Thoughts
A clear repayment schedule turns a long loan into a plan you can follow month by month. Use it before you borrow, check it against your bank statement, and revisit it whenever you consider a prepayment. For related tools, try the TDEE Calculator and the Loan EMI Calculator.
Frequently Asked Questions (FAQs)
Why does the interest part fall every month?
Interest is charged on the remaining balance. As you repay principal, the balance falls, so interest falls and a bigger part of the fixed EMI goes to principal.
Can this schedule be used for home and car loans?
Yes, any reducing-balance loan with fixed EMI follows the same maths. Enter that loan's rate and tenure.
What happens if I prepay part of the loan?
Prepayment cuts the balance, so either your EMI falls or your tenure shortens and total interest drops. This table assumes no prepayment.
Why is my bank's last EMI slightly different?
Banks round EMI to whole rupees and adjust the final instalment, so the last row can differ by a few rupees from this table.