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

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

EMI Calculation


kamlesh (Employee)     06 December 2007

kamlesh
Employee 
 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
Service 
 47 likes  2703 points

View Profile | My Other Post

It is Rs 2834 as found using calculator in www.apnaloan.com

avater

Sathish Karunakaran (ACA)     06 December 2007

Sathish Karunakaran
ACA 
 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

(Guest)

pls send tome the calculator

CA Kiran (consultancy)     07 December 2007

CA Kiran
consultancy 
 33 points

View Profile | My Other Post

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

(Guest)

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 @ gmail.com

(Guest)

EMI Calculation

(Guest)

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

(Guest)

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


Loading

Popular Discussion


view more »



Trending Tags
GST Live Class    |    x