XIRR Monthly CF / offset function, etc.
Can someone help with a dynamic XIRR calculation? The GP in the deal puts in all equity through a particular month and the LP starts to contribute capital after that. I am looking for an off-set type equation that will calculate XIRR if the date ranges change. Would appreciate if someone can share an equation for this. Pain in the ass to keep dragging between month 8 or 15 due to timing of first negative CF. Thanks in advance.