I am calculating IRR for a series of cash flows using the XIRR formula.
Please see attached excel. I invest 500 on 12/31/2011, earn dividends on 12/31/2012, 2013 and 2014 and finally exit the investment for 600 on 12/31/2015. This gives me an IRR of 6.2% using the XIRR formula.
Now i have a fixed desired IRR of 10%. How can i calculate the value at which to exit the investment to obtain the desired IRR?
I can do this using the goal seek function here, but the actual implementation of this concept has multiple conditions and scenarios attached, so goal seek is not a practical options, as I would have to run a goal seek each time the scenario or any condition was changed.
Has anyone ever used this before? Any help is appreciated, as always.
Bookmarks