25L at 14% for 5 years
- Business loan amount
- ₹25,00,000
- Interest rate (per year)
- 14%
- Tenure
- 5 years
Monthly instalment₹58,171
Excel PMT(14%/12, 60, -2500000)
Open this exampleEMI on a term business loan, with the schedule you need for a cash-flow projection rather than just the monthly figure.
Also called: commercial loan calculator, msme loan emi.
₹58,171 a month for 5 years. Over the full term you repay ₹34,90,238, of which ₹9,90,238 is interest. 39.61% of what you borrowed.
An estimate, not an offer or a guarantee. Projected returns assume the rate you entered holds for the whole term, which no market does.
| Month | Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | ₹58,171 | ₹29,167 | ₹29,004 | ₹24,70,996 |
| 2 | ₹58,171 | ₹28,828 | ₹29,342 | ₹24,41,654 |
| 3 | ₹58,171 | ₹28,486 | ₹29,685 | ₹24,11,969 |
| 4 | ₹58,171 | ₹28,140 | ₹30,031 | ₹23,81,938 |
| 5 | ₹58,171 | ₹27,789 | ₹30,381 | ₹23,51,557 |
| 6 | ₹58,171 | ₹27,435 | ₹30,736 | ₹23,20,821 |
| 7 | ₹58,171 | ₹27,076 | ₹31,094 | ₹22,89,727 |
| 8 | ₹58,171 | ₹26,713 | ₹31,457 | ₹22,58,269 |
| 9 | ₹58,171 | ₹26,346 | ₹31,824 | ₹22,26,445 |
| 10 | ₹58,171 | ₹25,975 | ₹32,195 | ₹21,94,250 |
| 11 | ₹58,171 | ₹25,600 | ₹32,571 | ₹21,61,679 |
| 12 | ₹58,171 | ₹25,220 | ₹32,951 | ₹21,28,728 |
This is what the calculation gives for the numbers you entered. It is an estimate, not advice, and it knows nothing about your situation beyond those numbers. Rules for India change on a published schedule; the effective date is shown on every rule-based tool.
An EMI does two jobs at once: it pays the interest that accrued this month, and it repays some principal. Because the principal shrinks, next month's interest is smaller, so more of the identical payment goes to principal. The formula answers one question. What fixed payment, repeated n times, drives the balance to exactly zero?
E = P * i * (1+i)^n / ((1+i)^n - 1)Each of these is asserted on every build. If a change to the engine ever moved one of these answers, the build would fail before the page could print it.
Monthly instalment₹58,171
Excel PMT(14%/12, 60, -2500000)
Open this exampleMonthly instalment₹10,000
i=0 branch
Open this exampleFormula version 1.0.0 · definition 1.0.0 · India · Report a problem with this calculator