Hello,
I'm trying to create a formula, macro or whatever is needed to create this profit split for an investment.
• 9% Preferred Return to the Sponsor
• Profit Split (Waterfall #1): 75% Investor / 25% Sponsor (until Sponsor achieves a 20% IRR)
• Profit Split (Waterfall #2): 50% Investor / 50% Sponsor thereafter
The 9% is easy, but then went it gets to creating what is needed for the sponsor I'm stuck. I've attached a copy of an example to where I get stuck and cannot move past it. Please let me know if anyone knows how to formulate or if more information is needed.
Thank you. File1.xlsx
Bookmarks