Drop in the principal, rate, and tenure — out comes a clean PDF schedule with the EMI, principal/interest split for every period, a yearly rollup, and an XLSX you can plug into a model.
01 — What you create
EMI, every period’s principal/interest split, opening and closing balance, yearly rollup, and totals — all in one PDF, with an XLSX for the modellers.
EMI / AMORTIZATION SCHEDULE
Home Loan — EMI Schedule
Borrower: Marcus Vance · Lender: Northwind Mortgage Bank
LOAN AMOUNT
USD 250,000.00
INTEREST RATE
6.50% p.a.
EMI / MONTHLY
USD 1,864.29
TOTAL PAYABLE
USD 447,430
AMORTIZATION SCHEDULE
+ 234 more rows over 240 monthly periods
Scanned invoices, multi-page batches, multi-currency stacks, and direct push into your accounting system. Free for 30 days, no card required.
Try Premium FreeFree 30 days · no credit card · cancel anytime
02 — How it works
Every retail loan in the world uses the same EMI formula on a declining balance. This tool runs it locally, lets you tweak the inputs, and shows you the full schedule before you sign anything.
Principal, annual rate, tenure. The EMI computes from the standard amortization formula — same one your bank uses.
Monthly is most common; the tool also supports quarterly, semi-annual, annual, weekly, and bi-weekly. Tenure converts automatically to the right number of periods.
PDF for printing, sharing, or attaching to a loan agreement. XLSX has three sheets — summary, full schedule, yearly rollup — ready to drop into a model.
03 — Built for borrowers & lenders
The standard amortization formula — same one banks use. P × r × (1+r)^n / ((1+r)^n − 1).
Monthly, quarterly, semi-annual, annual, weekly, bi-weekly. Tenure converts automatically based on the frequency you pick.
Add a flat extra-payment per period to model accelerated payoff. The schedule shortens and total interest drops accordingly.
In addition to the period-by-period schedule, a yearly summary shows total principal, interest, and year-end balance by calendar year.
Each row gets its actual due date — calculated from your start date and the chosen frequency, respecting month-end logic.
PDF with summary cards, yearly rollup, and full period table. XLSX has Summary, Schedule, and Yearly sheets — pre-formatted for further analysis.
Bulk OCR, batch invoicing, multi-party e-signing, redaction, audit logs — pdfFiller picks up where Sonchoy ends. Free for 30 days, no credit card.
Run 100+ invoices, statements, or conversions in one go.
Turn paper invoices into searchable, exportable data.
Multi-party signatures with full audit trails.
Mask sensitive ledger lines before sending to auditors.
04 — Common questions
EMI is "Equated Monthly Instalment" — the fixed amount you pay each period that includes both interest and principal. The split shifts over time: early payments are mostly interest, late payments are mostly principal. Total amount per period stays constant.
Almost always within a few cents per EMI. Different banks round at different steps, and some apply rate-reset, processing-fee amortization, or insurance — the tool models the pure amortization. The total interest figure should be within 0.5% of the bank's.
EMI is calculated on a declining-balance basis. Each period, interest is charged on the remaining balance — and since principal goes down, interest does too. The principal portion of the EMI rises every period to compensate, keeping the EMI itself constant.
Yes — set the "Extra payment per period" field. It's added to the principal portion of each EMI, the schedule shortens automatically, and total interest drops. The final period's payment is auto-adjusted to settle any remaining balance.
Weekly / bi-weekly EMIs charge interest more frequently, which means slightly less interest accrues between compounding steps. Over a 20-year loan, switching from monthly to bi-weekly can save several percent on total interest — though most banks only offer monthly.
PDF (multi-page, with summary cards, yearly rollup, full amortization table, and totals row) and XLSX (three sheets: Summary, Schedule, Yearly). The XLSX columns are numeric and ready for further formulas, pivots, or charts.