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.
No comments:
Post a Comment
Thank you for comment.