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
|