Thread: PMT
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default PMT

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

Not really wrong. The payment is just being shown as a negative number.
You can format negative numbers in four different ways, two of which
include a red font, or create your own format. See Excel help for
"negative numbers"

Bill