CCI Online Learning
50% OFF in CA/CS/CMA Subjects

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  

Related Threads


Popular Discussion

view more »

Trending Tags
GST Live Class    |    x