CCI Online Learning
What do you want to learn today?
     
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  




Popular Discussion


view more »



Trending Tags

GST Live Class    |    x