Thread: PMT function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default PMT function

You should use
=PMT(0.006667,60,80000)

the first parameter is rate/period so in this case it should be 0.08/12 or
8%/12

"Brent" wrote:

I can't ever seem to get the payment function to calculate properly. I am
entering an $80,000 loan with and interest rate of 8% payable over 5 years.
This is the formula I am entering =PMT(0.6667,60,80000). The result I am
getting is ($53,336.00). The answer should be a montly payment of $1,622. My
eyes are crossed - what am I doing wrong?