Monday, 18 December 2017

PMT formula

Basically PMT formula is use to calucalt the amount of loan.We will try to uderstand the formula throgh the Example. 

Suppose we have taken loan form the bank and we have to find out the EMI Amount. 

Syntex
=pmt(rate,nper,pv[fv],[type])

 rate  = rate is The percent which is fix by the bank on the loan
 nper = nper is the time which is in month like 5 years(60 months)

 pv    = pv is present value (we can say the loan which is taken by us)






The value will show in minus because we are paying the money.

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

calculation of professional tax

Normally professional tax in not applicable all over the country but there are some state where the government take professional tax  Karn...

  • shortcut of tally
    Hello Friends here some shortcut key of tally.   1.          F1                            To select a Company 2.          Alt+...
  • How to prepair Bank Reconcilition Statement
     Bank Reconciliation statement if we say in simple word this is the one way to know that how much balance is in our Company  Account h...
  • PMT formula
    Basically PMT formula is use to calucalt the amount of loan.We will try to uderstand the formula throgh the Example.  Suppose we have ta...