Here is the raw data, investment 1=-10% Investment=0.0% which is wrong!:
Thank you,
IRR Currency
Nov-98 Dec-98 Jan-99 Feb-99 Mar-99 Apr-99 May-99 Jun-99 Jul-99 Aug-99 Sep-99 Oct-99 Nov-99 Dec-99 Jan-00 Feb-00 Mar-00 Apr-00 May-00 Jun-00 Jul-00 Aug-00 Sep-00 Oct-00 Nov-00 Dec-00 Jan-01 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01 Sep-01 Oct-01 Nov-01 Dec-01 Jan-02 Feb-02 Mar-02 Apr-02 May-02 Jun-02 Jul-02 Aug-02 Sep-02 Oct-02 Nov-02 Dec-02 Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05 May-05 Jun-05 Jul-05 Aug-05 Sep-05 Oct-05 Nov-05 Dec-05 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07
-10.5% Investment1 Equivalent USD (0) (2,000,000) - - - -
- - - - - - - - - - - - -
- - - - - - - - - - - - -
- - - - - - - - - - - - -
- - - - - - - - - - - - -
- - - - - - - - - - - - -
- - - - - 1,000,000 - - - - - -
- - - - - - - - - - - - -
- - - - - - - - - - -
0.0% Investment2 Equivalent USD (1,995,277) (2,000,000) - - -
- 163,953 - (2,092,790) - - - - - - -
- 172,911 68,472 (196,707) - - (5,550,825) - 114,130
- - 28,496 28,496 28,496 219,026 (179,021) - -
22,593 22,593 22,593 22,593 (21,555) 46,341 (100,723) (213,634)
45,186 3,045 - 45,186 - 45,186 - - - - -
48,000 - - 3,498 34,064 - - - 34,064 (390,237)
33,047 - 82,852 - - - - - - 35,257 35,257
- - 6,353,025 - - - - - - - - -
- - - - - - - - - - - - -
- - - - - - - -
"Jerry W. Lewis" wrote:
We are not mind readers. Give examples.
Jerry
Gilles wrote:
Hello,
I am having a wierd thing: using the XIRR for different investment analysis,
some of them give me a answer, others do not, I get a result 0.0% !!! for no
reason, can anyone please help?????
Thank you,
Gilles
|