Difference between pmt formula and emi formula

2414 views 3 replies
What is the difference between PMT formula and EMI formula? Or both are same?
Replies (3)

Actually it may be called same, as PMT is one of the function in EXCEL to calculate the payment for a loan based on constant payments and a constant interest rate, i.e EMI.

 The basic formula that works behind an EMI calculator is:

E = P x r x (1+r)^n/((1+r)^n – 1)

for details you may refer https://www.youtube.com/watch?v=WzofplrjidU

Thanks for your reply, Sir, I'm a Banker. When we open loan account there are 2 different options one is on PMT formula and second is on EMI formula, that is why I'm confused. If both are same then why 2 options are there?

I know that in excel we can find EMI with PMT formula. 

Thanks again

 

 

Oh, in that case check whether bank has specifically designed software for that?. Does operation or results differ or are same?


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details