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:

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

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

About Christine Yong
Questions
64
Answers
5
Best Answers
0
  • Posted on -
  • Question Category:

Read About Plugin-container.exe Error In Brief.

Previous

Read About Png To Jpg Batch Converter In Brief.

Next

Related Questions