Modeling pref equity, and two co-gp equity sources
currently looking to raise $10m of equity. In breaking down the equity structure we have a pref equity piece of $5m. For the remaining $2.25M, were looking at taking on a Co-GP equity source taking half of that and then for the other half we would also be speaking to a shop who would come in for half of the $2.25M with us.
You gotta build the model, my dude. Start by reading up on waterfall structures and understanding promotes, preferred returns, claw-backs, etc. There's a bunch of great Primers and guides out there on waterfall structures. (Check out the "Real Estate Finance Journal - Real Estate JV Promote Calculations: Basic Concepts and Issues (Updated 2013)"). After that make sure to get a handle on how your capital stack is organized.
The Waterfall (provided I understand your structure correctly) would flow something like this: 1) Preferred Equity Payment (Can also be a PIK/Current Pay structure so make to understand how that works) 2) Construction Loan Debt Service 3) Co-GP Payment 4) Payment to yourself
For 3 and 4, your payments may be Pari-Passu (get paid at the same time based on your equity split of the remaining cash flow) or its a clawback structure (equity partner gets paid first until they get to a certain agreed upon Return %, and then your equity gets paid out until you reach a different (or same) agreed upon Return %. In the end, its really going to be dependent on how the JV agreement is organized, but it sounds like your question is geared towards how to actually set up the model, so for that I'm going to refer you to our good friend google. (Hint: "Adventures in CRE - Library of Excel Models").
Good luck!
Think I can translate what you're saying:
I'm trying to do an institutional grade development but have no equity or experience to contribute to this deal. Please help me.
Honestly...the deal you mentioned has maybe a 1% chance of actually happening. Even if you find people to provide the equity and find someone who can guarantee the loan...the numbers won't pencil when you start paying points to co-sponsors.
I can easily do this for a fee to any degree of complexity and subordination.
Qui quod molestiae alias ipsam. Voluptatem aliquid odio debitis velit illo. Inventore et distinctio eum debitis. Consequuntur eum et et veniam in.
Sit dolor voluptatibus ipsum maiores. Aperiam accusantium amet ipsam in veniam. Maiores laborum quidem fugit et.
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...