Spreadsheet: 203932d1357301988-variable-date-in-xirr-function-possible-xirr_senarios
Sheet: Sheet1

INVESTMENT RETURNS |  |  | XIRR  % |  | 0.4084266901016236 |  |  | XIRR  % | 0.1838304948806763 | 0.1691321420669555
 |  |  |  | USD | GBP |  |  |  | USD | GBP
 |  |  | Totals | 0 | 3174701 |  |  | Totals | 1601764 | 884838
Fund_NAMES |  | TEST_1 |  |  |  |  | TEST_2
TEST_1 |  | Seq_Numbering | Date |  | Amounts - GBP |  | Seq_Numbering | Date | Amounts in  -  USD | Amounts - GBP
TEST_2 |  | 1 | 1997-10-01 00:00:00 |  | -300000 |  | 1 | 1998-01-14 00:00:00 | -20000 | -12267
TEST_3 |  | 2 | 1997-12-01 00:00:00 |  | -150000 |  | 2 | 1998-06-22 00:00:00 | -155000 | -92687
TEST_4 |  | 3 | 1998-03-01 00:00:00 |  | -150000 |  | 3 | 1999-07-20 00:00:00 | -245000 | -155704
TEST_5 |  | 4 | 1998-04-01 00:00:00 |  | -450000 |  | 4 | 1999-08-13 00:00:00 | -200000 | -124626
 |  | 5 | 1998-07-01 00:00:00 |  | -300000 |  | 5 | 1999-08-23 00:00:00 | -300000 | -186615
 |  | 6 | 1998-09-01 00:00:00 |  | -150000 |  | 6 | 2000-04-14 00:00:00 | -120000 | -75659
 |  | 7 | 1998-12-01 00:00:00 |  | -450000 |  | 7 | 2000-11-15 00:00:00 | -25000 | -17400
 |  | 8 | 1999-01-01 00:00:00 |  | -150000 |  | 8 | 2001-02-12 00:00:00 | -75000 | -51695
 |  | 9 | 1999-02-01 00:00:00 |  | -150000 |  | 9 | 2001-04-23 00:00:00 | -33320 | -23176
 |  | 10 | 1999-03-01 00:00:00 |  | -60000 |  | 10 | 2001-05-31 00:00:00 | -116667 | -82276
 |  | 11 | 1999-06-01 00:00:00 |  | 325800 |  | 11 | 2001-11-06 00:00:00 | -143333 | -98291
 |  | 12 | 1999-08-01 00:00:00 |  | 485700 |  | 12 | 2002-02-18 00:00:00 | -14367 | -10059
 |  | 13 | 1999-09-01 00:00:00 |  | -30000 |  | 13 | 2002-04-30 00:00:00 | -28125 | -19310
 |  | 14 | 1999-10-01 00:00:00 |  | 675000 |  | 14 | 2002-10-30 00:00:00 | 1063228 | 682702
 |  | 15 | 1999-11-01 00:00:00 |  | 69600 |  | 15 | 2003-03-01 00:00:00 | 48384 | 30707
 |  | 16 | 1999-12-01 00:00:00 |  | -60000 |  | 16 | 2003-08-29 00:00:00 | 322262 | 203864
 |  | 17 | 2000-01-01 00:00:00 |  | -150000 |  | 17 | 2004-02-20 00:00:00 | -46847 | -30224
 |  | 18 | 2000-01-31 00:00:00 |  | -90000 |  | 18 | 2004-06-14 00:00:00 | 17095 | 9345
 |  | 19 | 2000-03-01 00:00:00 |  | 269700 |  | 19 | 2004-09-28 00:00:00 | 1485 | 828
 |  | 20 | 2000-04-01 00:00:00 |  | 823440 |  | 20 | 2004-11-24 00:00:00 | 5491 | 3328
 |  | 21 | 2000-06-01 00:00:00 |  | -90000 |  | 21 | 2005-03-07 00:00:00 | 589902 | 339017
 |  | 22 | 2000-07-01 00:00:00 |  | 1046790 |  | 22 | 2005-12-16 00:00:00 | 918106 | 510059
 |  | 23 | 2000-09-01 00:00:00 |  | -120000 |  | 23 | 2005-12-28 00:00:00 | 21653 | 12029
 |  | 24 | 2000-12-01 00:00:00 |  | 171900 |  | 24 | 2006-04-04 00:00:00 | 37854 | 21328
 |  | 25 | 2001-01-01 00:00:00 |  | 52800 |  | 25 | 2006-12-20 00:00:00 | 9061 | 4612
 |  | 26 | 2001-03-01 00:00:00 |  | 220500 |  | 26 | 2008-01-17 00:00:00 | 28375 | 14270
 |  | 27 | 2001-06-01 00:00:00 |  | 124178 |  | 27 | 2008-04-09 00:00:00 | 20257 | 10184
 |  | 28 | 2001-09-01 00:00:00 |  | 30749 |  | 28 | 2008-05-12 00:00:00 | 6916 | 3498
 |  | 29 | 2001-11-01 00:00:00 |  | 357960 |  | 29 | 2009-06-24 00:00:00 | 29379 | 15880
 |  | 30 | 2004-03-02 00:00:00 |  | 136926 |  | 30 | 2010-12-13 00:00:00 | 3931 | 2531
 |  | 31 | 2004-03-03 00:00:00 |  | -70146 |  | A1 | 2009-12-31 00:00:00 | 1044 | 645
 |  | 32 | 2004-03-31 00:00:00 |  | 128400
 |  | 33 | 2004-06-28 00:00:00 |  | 139955
 |  | 34 | 2004-07-22 00:00:00 |  | 25800
 |  | 35 | 2004-10-21 00:00:00 |  | 53610
 |  | 36 | 2005-01-20 00:00:00 |  | 247620
 |  | 37 | 2005-06-22 00:00:00 |  | 200850
 |  | 38 | 2005-07-27 00:00:00 |  | 45960
 |  | 39 | 2007-02-14 00:00:00 |  | 87600
 |  | 40 | 2007-11-15 00:00:00 |  | 55995
 |  | 41 | 2009-08-24 00:00:00 |  | 161054
 |  | 42 | 2011-06-10 00:00:00 |  | 76294
 |  | 43 | 2012-02-22 00:00:00 |  | 2191
 |  | A1 | 2011-03-31 00:00:00 |  | 78475