EMI Calculator | Bank Loans | Interest Calculator

EMI Calculator

EMI Calculator

How to use EMI Calculator?

EMi calculator helps you to calculate monthly payments which should be given to banks or microfinance according to principal amount, intrest rate and time. It helps you to plan your budget for your bussiness, building house, and investing in any equipment.

Steps to use calculator:-

First of all inter the principle amount in calculator.

After that add interest rate you are taking with that principle.

Inter time in month for which you are taking principle amount.

Finally, hit calculate button to get EMI payment with interest and principle amount for each year.

How to calculate EMI of any principle - Numerical

Calculate EMI and Amortization Schedule for a loan with principle Rs.10 lakh, Interest 16% and Time 60 month.

Given,

  • Principal (P): Rs. 10,00,000
  • Annual Interest Rate (r): 16%
  • Loan Tenure (n): 60 months

Step 1: Calculate Monthly Interest Rate

The annual interest rate is 16%, so the monthly interest rate is:

Monthly Interest Rate = 1612×100 = 161200 = 0.01333 

Monthly Interest Rate=12×10016​ = 120016​ = 0.01333

Step 2: Calculate EMI

The formula to calculate EMI is:

EMI=P×r×{((1+r)^n) / (1+r)^n−1}

Where:

  • P=10,00,000
  • r=0.01333
  • n=60

Substitute the values in formula:

EMI=10,00,000×0.01333×{((1+0.01333)^60) / ((1+0.01333)^60−1)}

= 2.2071(1+0.01333)60 = 2.2071

Now, calculate the numerator:

= 10,00,000×0.01333×2.2071

=29,417.64x10,00,000×0.01333×2.2071

= Rs. 29,417.64

Calculate the denominator:

or, 2.2071−1 = 1.20712.2071−1 = 1.2071

Finally, calculate the EMI:

EMI=29,417.64/1.2071 = Rs. 24,371.64

So, the EMI is Rs. 24,371.64.

Step 3: Amortization Schedule

The amortization schedule breaks down each EMI into principal and interest components and shows the outstanding balance after each payment.

Formula for Each Month:

  1. Interest Component:

Interest = Outstanding Principal×Monthly Interest Rate

  1. Principal Component:

Principal=EMI−Interest

  1. Outstanding Principal:

Outstanding Principal = Outstanding Principal−Principal

Example Calculation for Month 1:

  • Outstanding Principal: Rs. 10,00,000
  • Interest:

Interest=10,00,000×0.01333=13,333.33

  • Principal:

Principal=24,371.64−13,333.33=11,038.31

  • Outstanding Principal:

Outstanding Principal=10,00,000−11,038.31=9,88,961.69

Example Calculation for Month 2:

  • Outstanding Principal: Rs. 9,88,961.69
  • Interest:

Interest=9,88,961.69×0.01333=13,185.08

  • Principal:

Principal=24,371.64−13,185.08=11,186.56

  • Outstanding Principal:

Outstanding Principal=9,88,961.69−11,186.56=9,77,775.13

Amortization Table for Year 1

Here’s the breakdown for the first 12 months:

MonthEMI (Rs.)Interest (Rs.)Principal (Rs.)Outstanding Balance (Rs.)
124,371.6413,333.3311,038.319,88,961.69
224,371.6413,185.0811,186.569,77,775.13
324,371.6413,035.6711,335.979,66,439.16
424,371.6412,885.0911,486.559,54,952.61
524,371.6412,733.3311,638.319,43,314.30
624,371.6412,580.3811,791.269,31,523.04
724,371.6412,426.2311,945.419,19,577.63
824,371.6412,270.8712,100.779,07,476.86
924,371.6412,114.2912,257.358,95,219.51
1024,371.6411,956.4812,415.168,82,804.35
1124,371.6411,797.4312,574.218,70,230.14
1224,371.6411,637.1312,734.518,57,495.63

Summary

Total Payment: Rs. 14,62,298.40 (Principal + Interest)

EMI: Rs. 24,371.64

Total Interest Paid: Rs. 4,62,298.40 (Sum of interest components over 60 months)

Civil Concept

Share On:

"Structural Engineer" with over 5 years of proven expertise in estimation, structural design, and surveying. I specialize in creating safe, efficient, and sustainable structures that combine innovation with practicality.