How to calculate PMT function

  • Thread starter Thread starter Guest
  • Start date Start date
One way:

If you have the following information:

A1: <annual interest rate>
A2: <number of years>
A3: <Principal amount>

A4: =PMT(A1/2, A2*2, A3)


The key is to make sure the rate and the periods are in sync - i.e., if
you have 6-month periods, you need to have 6-month rates.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PMT function question 2
PMT function? 6
PMT function and 1st payment partway through a period 3
financial function 1
PMT question 5
PMT function 4
PMT function in Excel 7
different result with excel and calculator 2

Back
Top