![]() |
XIRR
Is XIRR known to give a bad result when you have only two dates and values?
I have an investment that costs $29 on 1/29/2011 and generates $30.25 on 3/20/2011, so profit is $1.25. XIRR gives 36.1%, whereas a simple interest calculation gives 31.5%. Simple interest was calculated as: ( $1.25 / $29 ) / (( End-Date - Start-Date ) / 365 ) -- W |
All times are GMT +1. The time now is 10:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com