30L at 10% for 15 years
- Loan against property amount
- ₹30,00,000
- Interest rate (per year)
- 10%
- Tenure
- 15 years
Monthly instalment₹32,238
Excel PMT(10%/12, 180, -3000000)
Open this exampleEMI on a loan secured against property. Longer tenures and lower rates than an unsecured loan, and the same reducing-balance arithmetic as a mortgage.
Also called: lap emi calculator, mortgage loan calculator india.
₹32,238 a month for 15 years. Over the full term you repay ₹58,02,868, of which ₹28,02,868 is interest. 93.43% 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 | ₹32,238 | ₹25,000 | ₹7,238 | ₹29,92,762 |
| 2 | ₹32,238 | ₹24,940 | ₹7,298 | ₹29,85,463 |
| 3 | ₹32,238 | ₹24,879 | ₹7,359 | ₹29,78,104 |
| 4 | ₹32,238 | ₹24,818 | ₹7,421 | ₹29,70,683 |
| 5 | ₹32,238 | ₹24,756 | ₹7,482 | ₹29,63,201 |
| 6 | ₹32,238 | ₹24,693 | ₹7,545 | ₹29,55,656 |
| 7 | ₹32,238 | ₹24,630 | ₹7,608 | ₹29,48,049 |
| 8 | ₹32,238 | ₹24,567 | ₹7,671 | ₹29,40,377 |
| 9 | ₹32,238 | ₹24,503 | ₹7,735 | ₹29,32,642 |
| 10 | ₹32,238 | ₹24,439 | ₹7,799 | ₹29,24,843 |
| 11 | ₹32,238 | ₹24,374 | ₹7,864 | ₹29,16,978 |
| 12 | ₹32,238 | ₹24,308 | ₹7,930 | ₹29,09,048 |
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₹32,238
Excel PMT(10%/12, 180, -3000000)
Open this exampleMonthly instalment₹39,645
Excel PMT(10%/12, 120, -3000000)
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