CCI Online Learning
What do you want to learn today?

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

EMI Calculation

kamlesh (Employee)     06 December 2007

 56 points

| My Other Post

Hellow Freind,

Please provide me in excel format , how to calculate Fix EMI  Amount .  if rate of Interest is 16 %  for 4 year and principal amount 1 lac



Thanks & Regards

Kamlesh ( ICWA-Inter )



harsha vardhan (article assistant)     06 December 2007

harsha vardhan
article assistant 
 23 points

View Profile | My Other Post

1 lac+ (1 lac * 16%*4yrs)/4yrs

K V Subba Rao (Service)     06 December 2007

K V Subba Rao
 47 likes  2703 points

View Profile | My Other Post

It is Rs 2834 as found using calculator in


Sathish Karunakaran (ACA)     06 December 2007

Sathish Karunakaran
 6 likes  614 points

View Profile | My Other Post

U can use function from Insert Menu in Excel. Under category Financial/PMT PMT[Rate/12/100,No.of Months,(-)Principal] PMT[.01333,48,-100000] EMI - 2834


pls send tome the calculator

CA Kiran (consultancy)     07 December 2007

CA Kiran
 33 points

View Profile | My Other Post

I have uploaded the file of loan calculator in others section.


Please provide EMI When rate of int is 14% of Rs.3,00,000 for the period of 3 years. My actual E-mail ID IS : simhachalam.gadibantu @


EMI Calculation


Hi, Plz send me the EMI calculator to my below mentioned mail id:- siba_gopal @ Thanks in advance Siba Gopal


the formula is (p * r) ( 1 + r)^n -------------------------- (1 + r) ^ n - 1

Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Popular Discussion

view more »

Trending Tags

GST Live Class    |    x