And as a side effect of the point below, I have yet to see a single response
to the original post you refer to.

--
W


"W" wrote in message
...
"joeu2004" wrote in message
...
Please see the responses to your first posting.

In the future, please do not the same question multiple times, be it in
the
same or multiple newsgroups. That usually leads to confusion, and it
wastes
the time of responders.

I have a glitch on giganews that is not allowing me to see either the
original post or any responses to it. Sorry, and it doesn't happen very
often.

--
W


"W" wrote in message
...
I use XIRR to calculate a compound annual return on investments.
This
works fine when the first value is negative and the others are
positive.
However I cannot get it to work for a short sale. For a short sale,
you
are paid up front, and then you pay back the investment later.

If I have a short sale like:

1/27/2012 2/3/2012
$52 -$50

XIRR tells me it is an annualized return of -87.1% (NEGATIVE return,
even
though it is net positive cash)

If I reverse this:

1/27/2012 2/3/2012
-$50 $52

XIRR tells me it is 673% annualized return. But at least it is
positive.

Why does XIRR have problems dealing with positive cash up front
followed
by
negative cash flows?

--
W