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
|