nush
Member of DD Central
Posts: 396 
Likes: 113
|
Post by nush on Sept 26, 2016 7:21:42 GMT
|
|
ablender
Member of DD Central
Posts: 2,204
Likes: 555
|
Post by ablender on Sept 26, 2016 7:45:03 GMT
Should there be a difference between the XIRR calculated with this sheet (used in OpenOffice) and a calc (OpenOffice) spreadsheet?I am getting different results for the same data.Can someone double check please?Forget this. One was calculated as at today 26/9/16, the other was calculated as at 12/9/16, although the amounts did not change.
|
|
nush
Member of DD Central
Posts: 396
Likes: 113
|
Post by nush on Sept 26, 2016 11:47:10 GMT
Should there be a difference between the XIRR calculated with this sheet (used in OpenOffice) and a calc (OpenOffice) spreadsheet?I am getting different results for the same data.Can someone double check please?Forget this. One was calculated as at today 26/9/16, the other was calculated as at 12/9/16, although the amounts did not change. works fine for me as far as i can tell, i am using libreoffice
|
|
james
Posts: 2,205
Likes: 955
|
Post by james on Sept 27, 2016 5:12:55 GMT
Thanks for beating me to it.  I haven't done all platforms but without necessarily updating to today here are three of my XIRRs: Ablrate: 14.8% (ignoring potential bad debt) Bondora: 12.1% (Pounds) 17% (Euros) assuming no debt recovery, 15.8%, 19.9% assuming 70% recovery. MoneyThing: 18.5% (the usual 1% a month now) As wiseclerk observed the Bondora results are not repeatable now and nor is the MoneyThing one that relied on a particular test they were doing at one point. These numbers include all revenue whether that's bonuses or secondary market profits and losses.
|
|
