ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XIRR (https://www.excelbanter.com/excel-programming/444163-xirr.html)

W

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