Waterfall Model with hurdle based on dollar amount ?
I'm trying to create a waterfall model as follows:
"1st Hurdle":
LP receives 100% of cash flow UNTIL LP has received their initial investment amount.
**After 1st hurdle has been "unlocked" the distributions will go as follows below**
"2nd Hurdle":
5.5% Cash-on-Cash Pref
PRE-PREF = GP/LP distributed pari pasu of their initial equity investment %'s
POST-PREF = GP/LP distributed 40/60
I've never had experience with a model that used a fixed dollar amount to "unlock" the pref hurdles. Any help would be greatly appreciated !!
Could have if statement in the cashflow waterfall saying if sum of current/previous cash flows is less than initial investment then 100% of cash flow to LP otherwise initial investment minus previous cash flows to LP. Doesn’t seem too complicated, not sure what the issue is
Thanks, I got it now. I guess I was just over thinking it
Laboriosam cum eligendi quis unde cupiditate maiores. Ipsam labore dolores quisquam vitae excepturi. Omnis modi et qui consequuntur accusamus amet laudantium. Voluptatem id tempora fugiat animi eos rerum temporibus.
Laboriosam distinctio repellat id. Repudiandae voluptatem nesciunt id quo et beatae. Optio occaecati aliquam qui vitae. Quos consequuntur neque laudantium voluptate repellendus similique.
Ipsum cum corporis voluptate nisi dolorem dolorem. Omnis error ad et. Modi suscipit maiores odio. Adipisci eum in deserunt esse quos sit. Quos qui consequuntur eum optio non error ut. Architecto sint fugit deleniti quam.
Veniam mollitia est esse. Sunt dolores exercitationem rem. Aut dolores recusandae officia nam omnis reprehenderit officia.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...