How to using PMT Formula in excel ( For LOAN EMI Calculation)

If you calculate what is your EMI for the loan please see below :

Example : 1

Loan Amount : 50000

Interest : 5 %

Type of Int. : Yearly (/12)

Total paid months : 60

Now Calculate as per below :

=PMT(5%/12,60,50000)

Now result is : 943.56 Rupees per month

 

If you calculate in the requirement as quarterly interest, and EMI paying in quarter beginning so how many rupees see example EMI as per below :

Example : 2

Loan Amount : 10000

Interest : 3.5 %

Type of Int. : Quarterly (/4)

Total paid months : 24

Quarter : 8

Pay in beginning : 1

Now Calculate as per below :

=PMT(3.5%/4,8,10000,5000,1)

Now result is : 1,889.30 Rupees per month

 

I hope helpful this post for you.