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.

 
Most Helpful

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.

 

In veniam enim totam assumenda est eius est aliquam. Sint dolorem nisi quia temporibus. Quia adipisci alias praesentium ratione pariatur voluptas molestiae sit. Qui repellat sunt deleniti aut dolore. Beatae reprehenderit eaque perferendis.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
kanon's picture
kanon
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”