View Single Post
  #1   Report Post  
Karl
 
Posts: n/a
Default PV(), FV() confused by sign expected

given

annual rate = 10%
periodic rate = 0.8333...%
nper=12
pv=100,000
pmt=100
type=0

FV() returns -$111,727.86

Why a negative value? If I have a balance of a positive $100, 000 and add
to it $100 each month, I would expect to have a positive $111,727.86

On the other hand, if I assume the same facts as above except change the
payment to a -100.00

then Excel's FV() returns -$109,214.75

I also don't understand this either, in that I start with a balance of
$100,000 and I believe I'm subtracting (-100.00) each month. Why's the
balance not 98,800.00 plus the impact of interest?

So my question is, how do I interpret the sign when using the financial
functions.

TIA.