PMT result as positive number

[BigBlueMan]

I'm using the PMT function to do some financial planning, but everytime I do
a calculation for a payment it comes up as a negative number.

Can I change this to a positive number in anyway? I want to use it to
calculate long term payoffs, etc. and prefer it as a positive.

Thanks!

ed

 

[Don Guillett]

use a - in front of or inside the formula

 

[Norman Harker]

Hi BigBlueMan!

Either:

Use =-PMT(........)

Or:

Reverse the signs of the PV and FV arguments.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[BigBlueMan]

Thank you gentlemen! Works like a charm!

Ed (Kentucky, USA)

 

[Norman Harker]

Hi BigBlueMan!

I should add that where you have arguments for both the PV and FV it
is important that you switch both of their signs. The function is
calculating the PMT that balances the equivalence formula and failure
to switch both signs would throw this out.

Using the switched sign approach is the same as reversing your
"persona". From being a borrower to whom the PV is an amount received,
you become a lender to whom the PV is an amount paid out. Similarly
with the FV argument. From being a borrower who pays out a terminal
payment, you become a lender who receives the terminal payment.

On balance I prefer a sign convention approach but simple negating of
the entire function will do the job.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi Ed!

Thanks for thanks is always appreciated and helps Google searchers
know that solutions work "as advertised". I know Don appreciates being
called a Gentleman for a change. <vbg>

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Don Guillett]

What's a gentleman? We don't have those in Texas.

 

[Don Guillett]

glad to help