Learn About Pmt Function In Excel 2007 In Detail.

Asked By 0 points N/A Posted on -
qa-featured

Hello,

I am currently using Microsoft Excel 2007 on my Windows 10 PC. I just wish to know about the pmt function in excel 2007. If someone has some information on the same, please share your views.

SHARE
Answered By 50 points N/A #299295

Learn About Pmt Function In Excel 2007 In Detail.

qa-featured

The function PMT has a syntax as follows:

  • PMT(rate, np, pv)
    • Here,Rate is the rate of interest.
    • Np is the total number of installments/payments for the loan.
    • Pv is the present value; which can be the principal amount.

For Example, Consider the image given below:

Image result for pmt function in excel 2007

The payment in cell C6 will depend on the formula as:

=-PMT(C2/12,C3,C4)

Login/Register to Answer

Related Questions