Loan Amortization Schedule
Build a monthly repayment schedule and export it as CSV.
Estimate equal monthly repayments from principal, annual interest and loan tenure. The result assumes a constant rate and excludes lender fees and insurance.
Loading workspace…
Preparing the controls for this tool. Your files have not been selected or uploaded.Enter principal, annual interest rate, and tenure. The calculation assumes a constant rate and equal monthly repayments, excluding lender fees and insurance.
Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.
EMI = P × r × (1 + r)^n / ((1 + r)^n − 1), where P is principal, r is annual percentage divided by 1,200, and n is the rounded number of monthly payments. At zero interest, EMI = P / n.
For ₹500,000 at 9% annually over 60 months, the estimated monthly EMI is ₹10,379.18, total payment ₹622,750.66 and interest ₹122,750.66. Calculations use unrounded intermediate values, so multiplying the displayed rounded EMI can differ slightly. This is an illustration, not financial advice.
No. It assumes a fixed annual rate over the selected term and excludes fees, insurance, prepayments and rate changes.
Payment dates, compounding conventions, fees, tenure rounding and lender-specific rounding can differ from this monthly reducing-balance illustration.
Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.
Adjust your values and see the result update instantly.