EMI Calculation

This query is : Resolved

Share Report Follow Query Ask a Query

pravin

pravin (Querist)
Follow

15 April 2011 Sir please give me a formula of EMI Caculation with interest

Kumar Babu.G

Kumar Babu.G (Expert)
Follow

15 April 2011 Rs.100000 Loan 15% interest 20 months period.EMI is (100000*115%)/20 = 5750

Message likes : 1 times

pravin

pravin (Querist)
Follow

15 April 2011 sir, when i calculate with loan calculator there is some difference in ur calculation

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

15 April 2011 https://www.deal4loans.com/Contents_Calculators.php

Please see above link.

pravin

pravin (Querist)
Follow

15 April 2011 Thanks sir but we r not calculate with calculator, i want a formula to calculate with calculator or excel formula

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

15 April 2011 This is the formula to calculate:

E = P×r×(1 + r)n/((1 + r)n - 1)

E is EMI

where P is Principal Loan Amount

r is rate of interest calculated in monthly basis it should be = Rate of Annual interest/12/100

if its 10% annual ,then its 10/12/100=0.00833

n is tenure in number of months

Eg: For 100000 at 10% annual interest for a period of 12 months

it comes to 100000*0.00833*(1 + 0.00833)12/((1 + 0.00833)12 - 1) = 8792

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Summarize this with AI

ChatGPT Perplexity Claude Google AI Grok

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

Leena Rachh

RISHI LATTA

Dhananjay Singh

shubham agrawal

N N V Satish

Subscribe Now

EMI Calculation

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

GST CONSULTANT

CA Final

Accountant

Senior execiutive

Manager- Finance and Compliance

GST CONSULTANCY

Article Assistant