Thread: PMT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default PMT

Hi,

You have to enter PV as a negative amount

=PMT(14.9%/12,48,-15000)

and your answer beccomes black!!
--
Mike

When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''''s razor (Abbrev)


"exceldud" wrote:

Why is my answer in red? What did I do wrong?

I'm trying to figure out how much monthly car payments will be for a $15,000
car. with 48 monthly payments at an interest rate 14.9%

I put: 14.9%/12 in the rate box. 48 in Nper. and 15000 in Pv.

I end up with $416.70 in red print