EMI Calculation Formula: Formula, Example & Calculator
How EMI is calculated: formula, example and calculator
The EMI calculation formula is used to calculate the fixed monthly payment on a loan when the interest rate and repayment period are known. The standard formula is EMI = P × r × (1 + r)ⁿ ÷ [(1 + r)ⁿ − 1], where P is the loan principal, r is the monthly interest rate, and n is the number of monthly payments. You can calculate EMI manually using this formula, in Excel, or with an online EMI calculator. The calculator is usually the quickest option because it automatically handles the mathematical calculation and shows the monthly payment.
What is EMI?
EMI stands for Equated Monthly Instalment.
It is the amount a borrower pays toward a loan at regular monthly intervals.
An EMI normally consists of two components:
- Principal repayment
- Interest
At the beginning of an amortizing loan, a larger portion of the EMI generally goes toward interest. As the outstanding principal decreases, the interest component also decreases.
The exact split depends on the loan’s interest rate, repayment schedule and terms.
What is the EMI calculation formula?
The standard monthly EMI formula is:
EMI = P × r × (1 + r)ⁿ ÷ [(1 + r)ⁿ − 1]
Where:
- P = Principal loan amount
- r = Monthly interest rate expressed as a decimal
- n = Total number of monthly payments
For a loan with an annual interest rate, convert the annual rate into a monthly rate before using the formula.
For example, if the annual interest rate is 6%:
Monthly rate = 6% ÷ 12 = 0.5%
As a decimal:
r = 0.005
If the loan runs for five years:
n = 5 × 12 = 60 months
How to calculate EMI step by step
You need three main figures:
- Loan amount
- Annual interest rate
- Loan tenure
Once you have them, follow these steps.
Step 1: Enter the loan amount
The loan amount is the principal you borrow.
For example:
Loan amount = AED 100,000
This is represented by P in the formula.
Step 2: Find the monthly interest rate
If your lender gives an annual interest rate, divide it by 12.
For example:
Annual rate = 6%
Therefore:
6% ÷ 12 = 0.5% per month
Convert 0.5% into decimal form:
r = 0.005
Make sure you use the rate in the form required by the formula.
Step 3: Convert the tenure into months
EMI calculations normally use the number of monthly payments.
For a five-year loan:
5 × 12 = 60 months
Therefore:
n = 60
Step 4: Apply the formula
The formula becomes:
EMI = 100,000 × 0.005 × (1 + 0.005)⁶⁰ ÷ [(1 + 0.005)⁶⁰ − 1]
The resulting monthly EMI is approximately:
AED 1,933.28
The exact amount displayed by a lender or calculator can vary slightly depending on rounding and the lender’s calculation methodology.
Worked example with AED figures
Suppose you want to borrow AED 100,000.
The loan terms are:
| Item | Value |
| Loan principal | AED 100,000 |
| Annual interest rate | 6% |
| Loan tenure | 5 years |
| Number of payments | 60 |
| Monthly interest rate | 0.5% |
| Approximate monthly EMI | AED 1,933.28 |
Using the formula:
EMI = P × r × (1 + r)ⁿ ÷ [(1 + r)ⁿ − 1]
Substituting the values:
P = 100,000
r = 0.005
n = 60
The approximate monthly payment is:
AED 1,933.28
Over 60 payments, the total scheduled payments are approximately:
AED 115,996.80
Therefore, the interest portion over the full repayment period is approximately:
AED 15,996.80
This is a simplified example. Actual borrowing costs can also include fees, insurance, charges, or other amounts depending on the loan agreement.
How EMI changes when the loan amount changes
The principal has a direct effect on the EMI.
For example, keeping the interest rate and tenure unchanged:
- AED 50,000 → lower EMI
- AED 100,000 → higher EMI
- AED 150,000 → still higher EMI
A larger loan generally means a larger monthly repayment when the other variables remain unchanged.
How interest rate affects EMI
The interest rate also affects your monthly payment.
Suppose the principal and tenure remain at:
AED 100,000 for 5 years
A lower interest rate generally produces a lower EMI, while a higher rate generally produces a higher EMI.
This is why comparing only the monthly payment can be misleading. Two loans can have similar monthly payments but different interest rates, fees or repayment periods.
How loan tenure affects EMI
Tenure is another important factor.
A longer repayment period generally reduces the monthly EMI because the principal is spread across more payments.
However, a longer tenure can result in more interest being paid over the life of the loan.
For example, extending a loan from five years to seven years may make the monthly payment easier to manage, but the borrower could pay more total interest.
This is why you should consider both:
- Monthly EMI
- Total repayment
rather than looking at EMI alone.
How to use an EMI calculator
An online EMI calculator removes the need to perform the formula manually.
Step 1: Open the EMI calculator
Open the EMI calculator on uLoveOffice.com.
Step 2: Enter the loan amount
Enter the amount you intend to borrow.
Example:
AED 100,000
Step 3: Enter the interest rate
Enter the annual interest rate.
Example:
6%
Step 4: Enter the tenure
Enter the repayment period.
For the example:
5 years
Step 5: Calculate the EMI
Click the calculate button.
The calculator should display the estimated monthly EMI based on the values entered.
Step 6: Compare different scenarios
Try changing one value at a time.
For example, compare:
- AED 100,000 at 6% for 5 years
- AED 100,000 at 6% for 7 years
- AED 120,000 at 6% for 5 years
This makes it easier to see how loan amount and tenure affect repayment.
EMI calculation in Excel
You can also calculate loan payments using Excel’s PMT function.
A basic example is:
=PMT(6%/12,60,-100000)
This calculates the monthly payment for:
- AED 100,000 principal
- 6% annual interest
- 60 monthly payments
The negative principal is used so that Excel returns the payment as a positive amount.
Excel is useful when comparing multiple loan scenarios in a spreadsheet.
EMI versus total loan cost
A low EMI does not automatically mean a cheaper loan.
Consider two scenarios:
Loan A
- Lower tenure
- Higher monthly EMI
- Lower total interest
Loan B
- Longer tenure
- Lower monthly EMI
- Higher total interest
The right choice depends on your budget, loan terms and financial circumstances.
When comparing loans, check the complete repayment amount rather than choosing solely based on the lowest monthly EMI.
Common EMI calculation mistakes
Several mistakes can produce incorrect results.
Using the annual rate directly
If the formula requires a monthly rate, don’t enter 6% directly as the monthly rate.
Convert the annual rate first:
6% ÷ 12 = 0.5%
Forgetting to convert years into months
A five-year loan has:
5 × 12 = 60 monthly payments
Using 5 instead of 60 produces the wrong result.
Confusing interest rate and interest amount
An interest rate is a percentage. Interest amount is the money charged based on the applicable rate and outstanding balance.
Looking only at EMI
Always consider total repayment and total interest as well.
Ignoring additional charges
A calculator based only on principal, interest and tenure may not include processing fees, insurance, penalties or other charges.
Check the lender’s actual agreement for the complete cost.
Is EMI always fixed?
The term “equated monthly instalment” generally refers to a scheduled payment calculated according to the applicable loan terms.
However, actual payment structures can differ depending on the loan product, interest-rate structure, lender policies and contractual terms.
For floating-rate loans, changes in the applicable interest rate can affect the repayment schedule or other loan parameters.
Always check the specific terms provided by the lender.
Frequently asked questions
What is the formula for EMI calculation?
The standard formula is EMI = P × r × (1 + r)ⁿ ÷ [(1 + r)ⁿ − 1], where P is principal, r is the monthly interest rate and n is the number of monthly payments.
How do I calculate EMI manually?
Enter the principal, convert the annual interest rate to a monthly decimal rate, convert the loan tenure into the total number of months, and substitute these values into the EMI formula.
What is the EMI for AED 100,000 at 6% for 5 years?
Using the standard monthly amortization formula, the approximate EMI is AED 1,933.28 for AED 100,000 at 6% annual interest over 60 months. Actual lender calculations may vary because of rounding and loan-specific terms.
Does a longer loan tenure reduce EMI?
Generally, spreading the same principal over a longer period reduces the monthly payment, assuming the other terms remain unchanged. However, it can increase the total interest paid.
Is an EMI calculator accurate?
An EMI calculator can provide a useful estimate when the principal, interest rate and tenure are entered correctly. The lender’s actual repayment schedule should be treated as the authoritative figure because fees, rate structures, rounding and other contractual terms can affect the final amount.
Conclusion
The EMI calculation formula uses three core inputs: principal, interest rate and repayment period. Understanding the formula helps you see how changing the loan amount, interest rate or tenure affects your monthly payment and total borrowing cost. For quick comparisons, an online EMI calculator is easier than calculating each scenario manually. Visit uLoveOffice.com to use the EMI calculator, test different AED loan scenarios, and calculate estimated monthly payments as often as needed.