Real Estate Private Equity - Underwriting Template | Development | REPE | Credit |

My fellow Monkeys -

Trying to gauge how the industry would react to another excel model prep course. I have been working on a pretty kick-ass underwriting model that I use daily in my REPE role. Keen on finding some way to generate income from the file.

What type of price point are people comfortable with?
What is the best way to market the product?

Any advice is appreciated - thank you in advance.

 
CaptainCapRate:
What makes it kick ass?

Several reasons:

  1. Built with an institutional mindset and has been used in over $1.5B of RE transactions (1 year). It was not built with the intention of selling, but due to demand from my network, am considering making a business out of it.

  2. Easy to understand and would include troubleshooting services (could be free). Could serve as a study tool for incoming analysts. Analysts at my firm love it.

  3. Asset Class Agnostic - would offer private 1 on 1 sessions to adjust for specific asset classes or deals.

Plenty more benefit - but the gist of it is that it has served as a training tool for over 25 analysts over the past year. Most of those analysts still use it to this day.

 

I work with a lot of funds that have models that could be described just like that. Most everyone just has different templates for different asset classes and all are institutional/easy to understand. Some potential benefits that might allow you to separate yourself from others could be the ease of modeling expense reimbursements for office/retail, superior flexibility of the cap stack, tools for modeling investor returns, etc.

Happy to discuss further if you want to PM me.

 

I'm very interested in discussing a potential partnership opportunity with you if teaming up would be accretive. I've built a dynamic waterfall that can handle subordination of pref and/or return of capital, promote or CF split, funding priority, project IRR versus LP IRR hurdles, etc... Want to add clawback/catch-up capability and make sure it could be used for the European market.

In the process of developing an asset management tool that would be on a separate tab which would calculate actual daily capital/pref balances and distribute profit as funds are distributed. There could be a comparison sheet which shows actual vs. projected capital allocated, CF distributed, estimated future contribution/distribution, etc...

I've got this Indian guy I work with for PE shops.

 

Having come from ibd restructuring and in repe in development you simply cannot build a template model to fit all deals. Capital structuring is unique to each project and excel isnt built for that prolly best bet is to build a vba based input model that can accustom all the potential intricacies of debt and equity and then perhaps that may be worth buying but remember if the investment firm cant understand the model they will never issue a term sheet.

 

The potential could be to have some kind of personal blog with access to training modules or You tube excel modelling on underwriting. Most companies have in house excel models with specific rules on fees and structure built over a period of time adding attributes as needed. And there are the big wig applications like Argus, so might be a tough sell on excel modelling when the goal is to get away from it in the long run.

 

Aspernatur sit accusantium eum autem explicabo animi. Quis ullam nihil quidem esse quo unde consequatur. Qui et officiis dolores quod impedit voluptatem. Sit nihil sapiente quos magnam qui a enim.

Suscipit et nemo illum qui. Repudiandae itaque maiores occaecati aut facere quasi. Asperiores et eius fuga quia cupiditate illo qui.

Voluptatem excepturi quia qui provident est voluptates earum. Iusto iusto fugit ad ut voluptate.

Career Advancement Opportunities

May 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 04 97.1%

Overall Employee Satisfaction

May 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

May 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

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (20) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $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
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
numi's picture
numi
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...”