EMI Calculator

EMI Calculator — Know Your Monthly Payment Before You Borrow.

Enter three numbers — loan amount, interest rate and tenure — and instantly see your EMI, total interest and a full month-by-month repayment schedule. Comes pre-filled with a worked example — a ₹25,00,000 home loan at 9% for 240 months — so you see exactly how it works, then type your own loan over it.

What's inside

• Instant EMI calculation from amount, rate and tenure
• Total payment and total interest at a glance
• Full amortisation schedule — opening balance, interest, principal, closing balance for every month
• Works for home, car, personal and education loans
• Pre-filled worked example included — see how it works, then type over it
• Printable PDF version included

How it works

Open the spreadsheet in Excel, Google Sheets or LibreOffice. Fill in the gold input cells — every total, balance and percentage calculates automatically. It comes pre-filled with example data so you can see exactly how it works — just type over the examples with your own numbers. Category and status columns have dropdown menus, and key columns colour-code themselves as you type. Prefer paper? A print-ready A4 PDF version is included.

Specifications

• Format: XLSX (live formulas) + printable PDF + read-me
• Works in: Excel, Google Sheets, LibreOffice
• Currency: ₹ by default — switch to any currency in one step (Format Cells)
• License: full rights — use, edit, rebrand & resell
• Updates: free for life

Full rights

Sold with full rights: use it personally or with clients, edit anything, and even rebrand and resell it — keep 100% of the income, no attribution required. Customise before reselling (marketplaces reject identical duplicates).

Please note

A personal organisation tool, not financial advice. Digital download — delivered instantly, so all sales are final; future updates are free.