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
21 August 2026
Accountant

A G International

Kolkata

B.Com

View Details
Company
25 August 2026
Senior Accountant

MG Associates

New Delhi

CA Inter

View Details
Company
27 August 2026
ACCOUNTANT

CHARUPREETI & CO

Noida

Graduate (Any)

View Details
Company
18 August 2026
Audit Assistant - Remote / Work From Home

CA ANOOP P K & ASSOCIATES

Kozhikode

CA Inter

View Details
Company
29 August 2026
Chartered Accountant

Velionit Consulting PVT LTd

Mumbai

CA

View Details
Company
ARTICLESHIP 26 August 2026
CA Article Assistant/CA Drop Out/Accounts Executive

PARV & Co.

New Delhi

CA Inter

View Details
Company
19 August 2026
Chartered Accountant - Financial Consolidation & Reporting

Synergy Keystone

Mumbai

CA

View Details
Company
ARTICLESHIP 17 August 2026
CA Article Trainee

ASC Group

Noida

CA Inter

View Details