Emi

This query is : Resolved

Share Report Follow Query Ask a Query

rohit

rohit (Querist)
Follow

06 September 2013 respected sir plz kindly tell how to calculate emi and logic behind it

Mohan Babu.L

Mohan Babu.L (Expert)
Follow

11 September 2013 Hi Rohit,
If you want to calculate EMI you can download EMI Calculator from www.caclubindia.com itself.. or just go through the following:

How to calculate EMI in Excel?

EMI value can be calculated in Excel using PMT function, which has the following syntax:
=PMT(RATE,NPER,PV,FV,TYPE)

For instance, if you want to find EMI value for a loan amount of 100,000 which is payable in say 5 years (i.e., 60 monthly instalments) with an interest rate of say 12% p.a., the EMI can be calculated by placing the following formula in a cell in Excel spreadsheet:
=PMT(0.01,60,100000,0,0);
It must be noted here that the rate to used in the formula should be monthly rate i.e. 12%/12=1% or 0.01 in the above example. You may also note that the last two parameters in the function (FV and TYPE) are optional and if ignored they are assumed to be 0; You may refer to Excel help on this function for further explanation on this.

EMI Formula

For the mathematically curious minded, here is the exact EMI formula that can be used for calculating EMI amount for any given values of Principal, Interest Rate and Loan Period:

EMI = (P * R/12) * [ (1+R/12)^N] / [ (1+R/12)^N-1], where

P = Principal (loan amount);
R = Annual Interest Rate;
N = No. of Monthly Instalments
That is the EMI maths; So, EMI of a loan can be derived using the above formula with the help of just an electronic EMI calculator which can be downloaded for simple calculations... Best of Luck Rohit..

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

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

T.N.Reddy

Sreekumar J Pai

asmita gupta

Keshav Dubey

kambamcr@gmail.com

Subscribe Now

Emi

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

GST CONSULTANCY

Manager- Finance and Compliance

Accountant

GST CONSULTANT

CA Final