View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

PMT's results reflect the "direction" of money. You can think of it in
terms of negative results requiring expenditure and positive amounts
being income.

So if you're taking out a load for $10,000, you receive the money, so
the value is positive. The payment is negative to represent expense.

Of course, you can also think of it as the reverse...

In your case, I'd make the PV values negative to reflect your extending
credit, then the payment result will be positive to reflect your income
stream.





In article ,
"Matt Stanley" wrote:

FYI - on our client's monthly payment, I used the PMT Financial Function but
it gave me a negative number so either it's not working right or I'm doing
something wrong.