Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default XIRR

I am getting a really weird XIRR result for the following series of cash flows:

4/27/07 $43,750.00
9/11/07 $(437,500.00)
10/11/07 $(433,008.33)
11/11/07 $(428,217.22)
12/11/07 $(424,025.00)
1/11/08 $(418,934.44)
2/11/08 $(414,293.06)
3/11/08 $(411,448.33)
4/11/08 $(405,010.28)
5/11/08 $(401,566.67)
6/11/08 $(395,727.50)
7/11/08 $(392,583.33)
8/11/08 $(386,444.72)
9/11/08 $(381,803.33)
10/11/08 $(379,108.33)
11/11/08 $(372,520.56)
12/11/08 $(370,125.00)
1/11/09 $74,262.22
2/11/09 $74,262.22
3/11/09 $67,075.56
4/11/09 $74,262.22
5/11/09 $71,866.67
6/11/09 $74,262.22
7/11/09 $71,866.67
8/11/09 $74,262.22
9/11/09 $74,262.22
10/11/09 $71,866.67
11/11/09 $74,262.22
12/11/09 $7,071,866.67

TOTAL CF $1,465,811.67
XIRR = 305,076.9%

This can't be right, can it? It's only net ~$1.5mm...that doesn't strike me
as a 300,000% return. Help?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XIRR KC Excel Worksheet Functions 3 March 30th 07 05:09 PM
XIRR Bob Umlas, Excel MVP Excel Worksheet Functions 3 January 26th 07 01:58 AM
xirr john Excel Worksheet Functions 4 June 26th 06 11:04 AM
tir... is the same as xirr?? Daniela Gutierrez Excel Discussion (Misc queries) 2 June 8th 06 05:26 AM
To XIRR or Not To XIRR Jonathan Excel Worksheet Functions 3 May 17th 06 03:13 PM


All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"