XIRR over several years
"Don Kline" wrote:
I have a XLS file I can send you. I don't know how to attach
the XLS file to the discussion. Please advise how I can get
this to you.
I received your XLS file in email. I sent you my comments. I will post an
update to this thread later today so that others might be able to contribute
their thoughts, too.
----- original message -----
"Don Kline" wrote in message
...
I have a XLS file I can send you. I don't know how to attach the XLS file
to
the discussion. Please advise how I can get this to you.
"JoeU2004" wrote:
"Don Kline" wrote:
I have a series of monthly transactions over several years.
I have used the XIRR function to find the ROR for each month,
each quarter, and each calendar year.
That's a neat trick, since XIRR only returns the annualized rate. I hope
that is what you mean. But I wonder if you are misinterpreting the
results from XIRR.
The client now wants a rate from inception. My expectation
was I would get an annual rate for the entire period. However
I feel that a -400% ROR is not accurate.
Is there anything different I need to do when the period is
greater than one year?
Yes. But I cannot tell you what that is because I'm not a mindreader.
If you post an example, you might get some help.
|