Loan Amortization Schedule
Every month’s principal, interest and balance, with dates.
Your result
—
Enter your numbers to see the result.
This amortization schedule breaks your loan into a month-by-month table. For every EMI you see how much goes to interest, how much reduces the principal and what balance remains, with real dates from your first EMI. You also get your payoff date and can download the whole schedule as a CSV file.
What is a Loan Amortization Schedule?
An amortization schedule is a table that shows how a loan is paid off over time. Each row is one EMI, split into the part that pays interest and the part that reduces the principal, followed by the balance still owed.
Looking at the schedule explains a lot about loans. In the early years, most of each EMI is interest. As the balance falls, the interest part shrinks and the principal part grows, even though the EMI stays the same. This amortization schedule gives you that full picture with real dates, so you can plan prepayments or prepare figures for tax and accounting.
How does the Loan Amortization Schedule work?
The schedule starts with your loan amount. For each month it charges interest at the monthly rate on the opening balance, subtracts that interest from the EMI to get the principal repaid, and reduces the balance by that amount.
The process repeats for every EMI until the balance reaches zero. Dates are counted forward month by month from the first EMI date you enter.
How to use the Loan Amortization Schedule step by step
- Enter the loan amount.
- Enter the interest rate.
- Enter the tenure in years.
- Pick the first EMI date.
- Scroll the monthly table under the tool, or use the totals in the result panel.
- Press Download CSV to open the full schedule in Excel or Google Sheets.
Loan Amortization Schedule example with real numbers
You take a ₹25 lakh home loan at 8.5% for 20 years, with the first EMI on 5 November 2026.
| Example input | Value |
|---|---|
| Loan amount | ₹25,00,000 |
| Interest rate per year | 8.5% |
| Loan tenure | 20 years |
| First EMI date | 2026-11-05 |
| Example output | Value |
|---|---|
| Monthly EMI | ₹21,696 |
| Total interest | ₹27,06,939 |
| Total payment | ₹52,06,939 |
| Interest in first 12 EMIs | ₹2,10,591 |
| Principal repaid in first 12 EMIs | ₹49,756 |
| Number of EMIs | 240 |
The amortization schedule shows an EMI of ₹21,696. In the first 12 EMIs you pay ₹2,10,591 as interest but repay only ₹49,756 of principal. That is why prepayments in the early years save so much.
Key features of this Loan Amortization Schedule
- Month-by-month table with real month names
- Principal, interest and balance for every EMI
- Payoff month shown
- First-year interest and principal totals
- Full CSV download
Who should use the Loan Amortization Schedule?
Who is this Loan Amortization Schedule for?
- Home loan borrowers planning prepayments
- Salaried people noting yearly interest and principal for tax under the old regime
- Accountants recording loan entries
- Students learning loan amortization
Practical use cases
- Seeing how slowly principal falls in the early years
- Finding the balance left after 5 years
- Preparing a yearly interest summary
- Checking a lender’s schedule for errors
Key benefits
- Full transparency: every rupee of every EMI explained.
- Better timing: see when prepayments help most.
- Record-keeping: a CSV you can keep with loan papers.
- Dates included: no need to count months by hand.
Tips for better results
- Compare this schedule with your lender’s; small differences usually come from broken-period interest in the first month.
- For tax under the old regime, home loan certificates follow the financial year (April to March), so add up the right months.
- Use the balance column to decide how much to prepay.
- Run the schedule again whenever your floating rate changes.
Common mistakes to avoid
- Assuming each EMI reduces the principal by the same amount.
- Ignoring the first month’s broken-period interest some lenders charge.
- Using an old rate after a repo rate change.
- Forgetting that a rate change may extend the tenure instead of changing the EMI.
Limitations of this Loan Amortization Schedule
- It assumes a fixed rate for the whole tenure.
- It does not include broken-period interest, fees or insurance.
- Very long tables are best viewed in the CSV file.
Loan Amortization Schedule vs other ways to calculate
| Method | Monthly detail | Dates | Download |
|---|---|---|---|
| Qorico amortization schedule | Yes | Yes | CSV |
| EMI calculator | Yearly | No | CSV |
| Lender’s schedule | Yes | Yes | PDF, on request |
| Excel PPMT and IPMT | Yes | If added | Native |
Excel’s PPMT and IPMT functions give the principal and interest for any single month. For a quick EMI and yearly view, the EMI calculator is simpler, and the prepayment calculator shows how extra payments change this schedule.
Privacy and data handling
This Loan Amortization Schedule runs entirely in your browser. The numbers you type are not sent to Qorico or stored on any server, and nothing is saved after you close the page. The Copy and Download buttons create the result on your own device. If the page has analytics turned on, it may count that a calculation happened, but it does not record the values you entered.
Loan Amortization Schedule FAQs
What is an amortization schedule?
It is a table showing each loan payment split into interest and principal, along with the balance left after each payment.
Why is interest higher in early EMIs?
Interest is charged on the outstanding balance, which is largest at the start. As you repay principal, the interest part of each EMI falls.
How do I see principal and interest every month?
Enter your loan details in this amortization schedule; the monthly table and CSV show both for every EMI.
How does prepayment change the schedule?
A prepayment reduces the balance at once, so every later EMI has less interest and more principal, and the loan ends earlier unless you choose to lower the EMI.
How much interest do I pay in the first year of a ₹25 lakh home loan?
At 8.5% over 20 years, about ₹2.1 lakh of the roughly ₹2.6 lakh paid in the first 12 EMIs goes to interest.
Can I use this schedule for my tax return?
It is a good estimate, but use the interest certificate from your lender for tax filing, as it reflects the exact amounts charged.
Related tools
Sources and references
We checked the method and the current figures used in this Loan Amortization Schedule against these official and primary sources:
Written and reviewed by the Qorico Team
