Sorry for the cryptic question I am not sure how to word this...
I have attached an example of a typical real estate deal. In the example scenario I show an investment and a stream of cash flows. The investor covers the equity and receives 100% of the cash flow until he reaches an 18% XIRR, after that point he only receives 80% of the cash flow until he reaches a 20% XIRR. Once both preferences are met the investor receives just 50% of the cash flow.
The real question I have is....how do you automate target XIRR returns with a formula?
The excel question i have is....Is there a way to use goal seek within a formula?
Thanks,
-Dude