U Love Office
Advertisement
U Love Office โ€” free online PDF, Word and Excel tools
Home โ€บ Calculators โ€บ Loan EMI Calculator

Loan EMI calculator

Estimate your monthly instalment, total payment and total interest for any loan amount, interest rate and tenure.

Advertisement
U Love Office โ€” smart tools for office, better work

How EMI is calculated

The standard EMI formula is:

EMI = P ร— r ร— (1 + r)โฟ รท [(1 + r)โฟ โˆ’ 1]

Where P is the loan principal, r is the monthly interest rate (annual rate รท 12, as a decimal), and n is the total number of monthly payments (years ร— 12).

Worked example

Loan amount AED 100,000, annual interest rate 6%, tenure 5 years:

  • Monthly rate r = 6% รท 12 = 0.5% = 0.005
  • Number of payments n = 5 ร— 12 = 60
  • Monthly EMI โ‰ˆ AED 1,933.28
  • Total payment over 60 months โ‰ˆ AED 115,996.80
  • Total interest โ‰ˆ AED 15,996.80

A longer tenure lowers the monthly EMI but generally increases total interest paid โ€” always compare total repayment, not just the monthly figure, when choosing between loan offers.

Frequently asked questions

What is the formula for EMI calculation?

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.

Does a longer tenure reduce EMI?

Generally yes โ€” spreading the same principal over more months lowers the monthly payment, but usually increases total interest paid over the life of the loan.

Is this calculator accurate?

It gives a close estimate based on the standard amortization formula. Your actual lender figure may vary slightly due to rounding, fees, insurance or the lender's exact calculation method โ€” treat the lender's official schedule as authoritative.

Does this calculator store my figures?

No. All calculations run in your browser โ€” nothing is uploaded or saved.

More calculators

All calculators โ†’