incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject DO NOT REPLY [Bug 118557] OO calc internal rate of return gives anomalous result (so does Excel)
Date Sun, 30 Oct 2011 13:16:38 GMT changed:

           What    |Removed                     |Added
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |
         Resolution|                            |WORKSFORME

--- Comment #2 from 2011-10-30 13:16:38 UTC ---
IRR is defined to use periodic cash flow. So you have to enter 0 for those
years which have no cash flow. Otherwise those years where not counted at all.
In your example the first row means an investment of 100000 and a return if
150000 in the _next_ year, which makes 50% rate.

If you have a non-periodic cash flow use XIRR.

Configure bugmail:
------- You are receiving this mail because: -------
You are on the CC list for the bug.

View raw message