Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xirr | Excel Worksheet Functions | |||
XIRR | Excel Worksheet Functions | |||
tir... is the same as xirr?? | Excel Discussion (Misc queries) | |||
To XIRR or Not To XIRR | Excel Worksheet Functions | |||
Xirr? | Excel Discussion (Misc queries) |