Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2004

Tip: Looking for answers? Try searching our database.

PMT result as positive number

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BigBlueMan - 01 Apr 2004 15:45 GMT
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 - 01 Apr 2004 16:21 GMT
use a - in front of or inside the formula

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> 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.
[quoted text clipped - 5 lines]
>
> ed
Norman Harker - 01 Apr 2004 16:24 GMT
Hi BigBlueMan!

Either:

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

Or:

Reverse the signs of the PV and FV arguments.

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

> I'm using the PMT function to do some financial planning, but
> everytime I do
[quoted text clipped - 7 lines]
>
> ed
BigBlueMan - 01 Apr 2004 16:28 GMT
Thank you gentlemen!  Works like a charm!

Ed (Kentucky, USA)

> Hi BigBlueMan!
>
[quoted text clipped - 17 lines]
> >
> > ed
Norman Harker - 01 Apr 2004 16:46 GMT
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>

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

> Thank you gentlemen!  Works like a charm!
>
[quoted text clipped - 22 lines]
>> >
>> > ed
Don Guillett - 01 Apr 2004 17:18 GMT
What's a gentleman? We don't have those in Texas.

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> Hi Ed!
>
[quoted text clipped - 28 lines]
> >> >
> >> > ed
Don Guillett - 01 Apr 2004 17:18 GMT
glad to help

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> Thank you gentlemen!  Works like a charm!
>
[quoted text clipped - 21 lines]
> > >
> > > ed
Norman Harker - 01 Apr 2004 16:34 GMT
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.

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

> Hi BigBlueMan!
>
[quoted text clipped - 17 lines]
>>
>> ed
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.