[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Question about XIRR in financial.cpp
From:       "Alvaro Soliverez" <asoliverez () gmail ! com>
Date:       2008-07-17 20:23:41
Message-ID: 64e15f8f0807171323p2593ff5xed33205863f2ea53 () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hello all,
I'm a developer of KMyMoney. I work mostly on reports and forecast for that
application.
Lately we have found some issues in the way we calculate IRR (internal rate
of return) when reports are over a couple of years.

Looking for some info, I found the method func_xirr in financial.cpp, which
is used by KSpread and it looks very similar to the one we use.

My question is, does it work fine when the series of cashflows are spread
over several years?
We found the issue when a user tried an IRR report on a series spread over
10 years.

Is that method even intended to provide results over several years? I
noticed the 365, which might lead to odd calculation when dates are over a
year.

Thanks for any help you can provide me.

Regards,
Alvaro Soliverez

[Attachment #5 (text/html)]

<div dir="ltr">Hello all,<br>I&#39;m a developer of KMyMoney. I work mostly on \
reports and forecast for that application.<br>Lately we have found some issues in the \
way we calculate IRR (internal rate of return) when reports are over a couple of \
years.<br> <br>Looking for some info, I found the method func_xirr in financial.cpp, \
which is used by KSpread and it looks very similar to the one we use.<br><br>My \
question is, does it work fine when the series of cashflows are spread over several \
years? <br> We found the issue when a user tried an IRR report on a series spread \
over 10 years.<br><br>Is that method even intended to provide results over several \
years? I noticed the 365, which might lead to odd calculation when dates are over a \
year.<br> <br>Thanks for any help you can provide me.<br><br>Regards,<br>Alvaro \
Soliverez<br><br></div>



_______________________________________________
koffice-devel mailing list
koffice-devel@kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel


[prev in list] [next in list] [prev in thread] [next in thread]