Learn About Pmt Function In Excel 2007 In Detail.

Asked By Eliza M Waters 0 points N/A Posted on - 06/13/2017

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.

• Status: Open
• Question Views: 330
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: OS
• Question Tags: Excel | pmt function

Answered By Christine Yong 50 points N/A #299295

Learn About Pmt Function In Excel 2007 In Detail.

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

• Vote Up 0 Vote Down

• Posted on - 06/13/2017
• Question Category: OS