Prev Previous Post   Next Post Next
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

This is so that one can keep track of the *direction* that money is
flowing. For instance, a standard convention is that for money flowing
*out*, the number is negative, whereas for money flowing *in*, the
number is positive. So if you get a loan (money coming in) then your
payment should be negative (money going out).

However, this is just a convention, so you can feel free to put the loan
amount as a negative, or to negate the answer.

This is explained in Help (the "PV" topic, which is referred to by the
"PMT" topic).

In article ,
"Chuck" wrote:

When using the PMT formula, why does the payment come back in a negative?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 01:49 PM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 09:04 PM
Formula displays does not calculate Neil Bhandar Excel Discussion (Misc queries) 4 January 10th 05 10:55 PM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM
Paste is is copying in formula, but display is wrong. Matt Excel Discussion (Misc queries) 2 December 7th 04 08:37 PM


All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"