Waterfall Model

[Yonah Sturmwind]

I am trying to model a deal for someone involving a silent equity investor (LP) with a waterfall analysis, I do not have much experience with that type of modeling. The LP is providing 90% of the funds and the Principals are providing 10%. The agreement states for there to be a 5% pref; afterwich all remaining cash is split at 75% LP and 25% Principal. There is a 7% IRR hurdle where it becomes a 50/50 split.

Does anyone have any advice for modeling this in excel? Or does anyone have a template waterfall with hurdles analysis that I could look at?

TIA