Hello,
i am seeking some helping building a formula using XIRR to calculate the IRR over a certain range that could be a subset of the entire cash flow strip. my thought was to use relative references to offset from a starting point and use the CELL address formula to build the cell references. I am not married to this approach if anyone has a better way i would really appreciate it. please see attached example and please let me know if i can further explain anything, thank you!
Bookmarks