Hello,
I wanted to calculate the return on an investment with variable payment dates.
The XIRR() function seemed appropriate, but I can’t figure it out with a simple example…
I imagine it’s a misunderstanding on my part and not a bug, but I’d like to understand.
In my attached example, how can I explain that XIRR() finds an annual return of 9.51% when I applied an annual return of 10% over 757 days?
tri.paiements.ods (13.6 KB)