Inputs at a Glance
Basic mode asks for three values, and Advanced mode adds two more. The main three also have sliders that track the typed number.
In Basic mode the fee and down payment are treated as zero. A field that breaks a rule shows a message, and the results hold their last values until it is corrected.
The Monthly Figure
Three quantities drive the installment: the financed principal (loan amount minus down payment), the monthly rate (annual percentage divided by 1,200), and the number of payments (tenure in years times 12, rounded).
At a zero rate the code divides the principal by n instead, since the formula would divide by zero. The schedule reuses this EMI month by month and groups the rows by loan year.
Worked Example: 5,00,000 at 9% for 5 Years
A Basic-mode loan of 5,00,000 rupees at 9 percent for 5 years gives r = 9 ÷ 1,200 = 0.0075 and n = 60, with the full amount as the principal.
- Raise 1.0075 to the 60th power, which gives about 1.565681.
- Numerator: 500,000 × 0.0075 × 1.565681, which is about 5,871.30.
- Denominator: 1.565681 − 1, which is 0.565681.
- Divide: 5,871.30 ÷ 0.565681, which is about 10,379.18. The panel displays ₹10,379.
Multiplying the EMI by 60 gives a total payment of about ₹6,22,751, so the total interest tile reads roughly ₹1,22,751. In the schedule, the first loan year shows principal of about ₹82,915, interest of about ₹41,635, and a closing balance near ₹4,17,085.
In Advanced mode, a ₹1,00,000 down payment and a 1 percent fee change the picture: the principal becomes ₹4,00,000, the EMI is about ₹8,303, and the upfront outlay tile shows ₹1,05,000 (the down payment plus the ₹5,000 fee).
Loan Types This Formula Covers
The formula fits any fixed-rate loan repaid in equal monthly installments. The table gives typical ranges; actual terms depend on the lender.
| Loan Type | Common Term Range | Where Rates Usually Sit | Typical Security |
|---|---|---|---|
| Home loan | 15 to 30 years | Lower end of consumer lending | The property |
| Vehicle loan | 3 to 7 years | Middle of the range | The vehicle |
| Student loan | 5 to 15 years of repayment* | Middle of the range | Varies by lender |
| Unsecured personal loan | 1 to 5 years | Usually the highest of these | None |
*Student loans often defer repayment until after the course, so enter only the repayment period as the tenure.
Why People Use It
What the Results Panel Shows
Results refresh on their own, and the Recalculate button runs the same process on demand. The panel reports these figures:
- Monthly EMI: the headline value, rounded to the nearest rupee.
- Principal Borrowed (Advanced): loan amount minus down payment.
- Total Payment: EMI multiplied by the number of months. It leaves out the down payment and the fee.
- Total Interest Payable: total payment minus the financed principal.
- Total Upfront Outlay (Advanced): down payment plus processing fee.
- Doughnut chart: principal, total interest and processing fee as three segments. The fee segment stays at zero in Basic mode.
- Amortization schedule: one row per loan year showing principal paid, interest paid and the balance left. Rounding differences are absorbed in the final month.
Levers You Control
Four inputs move the monthly figure:
- Financed amount. A larger down payment shrinks the principal in the formula, and the EMI falls in proportion.
- Term. A longer term lowers the EMI but spreads interest across more months. Run two tenures and compare the total interest tile.
- Rate. The rate sets the monthly factor in the formula. Run the same loan at two rates to see the spread.
- Fee. The processing fee does not touch the EMI, so plan for it in your upfront budget instead.
Comparison Pitfalls
- Entering a monthly rate. The rate field expects an annual percentage, and the code divides it by twelve itself.
- Comparing EMIs alone. Two offers can show similar monthly figures while the longer one carries a far larger total interest tile.
- Leaving out insurance and taxes. Neither the monthly figure nor the totals include insurance premiums or taxes on fees.
- Assuming the rate holds. The result applies one rate across the whole term, so a floating loan will drift away from it.
Prepayments Are Not Modelled
The calculator has no lump-sum prepayment input, and every schedule row assumes the same EMI all the way through.
To estimate one, enter the balance from the schedule at that year as the loan amount, with the remaining years as the tenure, and compare the two EMIs. Your lender's rules decide the final figure.
Questions and Answers
It is the equal monthly payment that repays the financed principal, at the entered annual rate, across the entered number of months. Each payment first covers that month's interest on the outstanding balance, and whatever is left reduces the balance.
It applies the standard amortizing formula: principal times the monthly rate times (1 plus the monthly rate) to the power of the number of months, divided by (1 plus the monthly rate) to the power of the number of months, minus 1. When the rate is zero, the code divides the principal evenly by the number of months instead.
The formula runs on the loan amount minus the down payment. A bigger down payment shrinks that base, so the monthly figure, the total interest and the total payment all fall with it.
No. The fee is calculated as a percentage of the loan amount and shown under Total Upfront Outlay with the down payment. It does not increase the financed principal, so the EMI is unaffected.
For the inputs you enter, the results follow the same arithmetic the lender's formula uses, with the display rounded to whole rupees. Insurance, taxes and any lender-specific day-count or rounding rules are not included, so a lender's schedule can differ slightly.
Yes, as a fresh estimate. Enter the outstanding balance as the loan amount, the new rate, and the remaining years as the tenure. The calculator assumes the rate stays fixed for that remaining term.