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.

14 Comments
 
"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 $100 an hour who is an absolute wizard. He is good for auditing complex formulas and trying to eliminate circularity. I also have an enormous library of models from institution developer and 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.

 

Ut voluptatem accusamus sed non. Itaque nihil in ipsum quis. Reiciendis vel et quis omnis deleniti eius repellendus. Debitis fugit quo laborum ipsam ut occaecati.

Enim in omnis magni tenetur nostrum sit. Ratione excepturi cum sed quo. Corporis nisi sed est blanditiis doloremque. Impedit deleniti qui quod quisquam porro consectetur.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (67) $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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
CompBanker's picture
CompBanker
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
DrApeman's picture
DrApeman
98.9
8
dosk17's picture
dosk17
98.9
9
GameTheory's picture
GameTheory
98.9
10
Mimbs's picture
Mimbs
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...”