Timeline for Excel XIRR function producing unexpected IRR
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 10, 2017 at 17:04 | vote | accept | mbmast | ||
| Jan 9, 2017 at 9:38 | answer | added | Chris Degnen | timeline score: 3 | |
| Jan 9, 2017 at 2:11 | comment | added | mbmast |
@AlexC Extremely slight improvement. I used DAYS to compute the days between dates and then used =C4/(1+C$31/365)^E4 (etc.) and the rate that gives a sum of zero (0.11 actually) was 33.016%. Still significantly different than the 39.098% given by Excel's XIRR function.
|
|
| Jan 8, 2017 at 22:19 | comment | added | Alex C | Suggestion: XIRR is based on exact day counts between dates divided by 365, your manual calc is based on month counts divided by 12. But months differ in length. Change you manual calculation to be on a day basis and see what happens | |
| Jan 8, 2017 at 21:06 | history | asked | mbmast | CC BY-SA 3.0 |