Difference between pmt formula and emi formula

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?

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 September 2026
Internal Audit - Team Lead

Consulting & Beyond

Chennai

CA

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 28 September 2026
Junior Accountant

J S P M & Associates LLP

Pune

B.Com

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details
Company
30 September 2026
Senior Accountant

Codeboard Technology

Chennai

B.Com

View Details
Company
18 September 2026
Accounts & Finance Specialist

ULTRA CHEMICAL WORKS

Thane

CA Final

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
ARTICLESHIP 07 October 2026
Article Trainee/ CMA Trainee

RMA And Associates LLP

New Delhi

CA Inter

View Details