How to calculate PMT function

J

JE McGimpsey

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.
 

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

Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
PMT function question 2
PMT function? 6
PMT function and 1st payment partway through a period 3
Excel PMT Function Help 2
PMT function 4
Function to establish mortgage bond size. 2
Possible problem with PMT and FV functions 2

Top