24 Comments
 

I guess it depends on the shop but I would argue most use templates. Real Estate Investments are always similar so using a template and modelling in the specifics is a lot quicker and just as good vs. building from scratch. Also most of the time you will look at a lot more deals in real estate vs M&A etc. so building everything from scratch is impractical.

 

Definitely templates. Even if you work for a small family office and you create it the first time, you're going to use that template the next time.

Commercial Real Estate Developer
 

Templates generally, as others have said. But if you can create one in your own time and your manager likes it better, then that would be a great thing.

I'll say though, as a learning experience, the best thing I did was recreate the template my company was using from scratch. Really good for helping learn the ins and outs of the model, how it functions, can be improved etc.

 

Templates but if I have down time (usually around Christmas) I will build a basic model and see how fast I can do it. It is great practice and if you time yourself you'll be forced to focus on the key inputs / return drivers.

The toughest things to model from scratch in my opinion are: 1) Rent roll / lease up. 2) Equity / debt draw schedule and 3) JV waterfall. With some practice you'll have it down though and feel pretty damn good about yourself.

 

Also, forgot to add for the new folks out there the key to modeling is understanding what is going on in the transaction NOT using fancy excel functions. Once you get a basic model built then you start worrying about cute functions and formatting. Seems obvious but I always see young guys fall into the trap.

 

This is key. Whenever I have a timed excel test for an interview I keep the actual excel functions as simple as possible (like I'll create a 10 YR rent/expense schedule tab real quick and just hard code any values that aren't "Y1 is X grown by Y annually" to feed a cash flow statement.)

Some IF statements here and there but at the start definitely focus on getting the numbers correct and knowing how to calculate the shit that matters, while at least laying it out in a way where people can understand it.

I'll finish a modeling test the easiest way with least room for error first, and if I get it done 30 min early I'll go back in and find ways to make it look better / display higher level command of formulas.

 

95% of the time you will use an existing template. The only time you will create from scratch or heavily modify an existing template is when you are looking at a deal that is so unique and has so many nuances or idiosyncrasies that it's easier to build from scratch than use a template.

In my opinion, I think everyone should create all models from scratch in the beginning so you know how to do it, yet as others have stated it's highly impractical to always build from scratch.

 
"goodL1fe" In my opinion, I think everyone should create all models from scratch in the beginning so you know how to do it, yet as others have stated it's highly impractical to always build from scratch.

I agree, and if your new firm prefers their exisiting template, i find it well worth the time to completely rebuild their template into a blank excel file to truly understand how everything ties together.

 

Ut blanditiis eveniet quos. Dignissimos officiis asperiores sit adipisci cupiditate. Sed ratione odit quibusdam laudantium incidunt cum. Sunt et aspernatur labore quia consequatur quae. Est aut eius sit consequuntur tenetur. Quo sunt blanditiis ut dolorem. Optio aperiam accusantium corrupti ut eum.

Aliquid non impedit amet magni. Rerum rerum cum iure nam.

Nam quos quia sunt sit eaque. Et ipsum repudiandae odio optio omnis alias. At eaque eaque doloremque. Ex porro id sed enim. Quod porro et quisquam ducimus. Quia animi quibusdam eligendi quibusdam.

Veniam laboriosam atque nesciunt. Saepe sequi rerum ut temporibus. Quo cupiditate provident consequatur in sed. Aperiam molestiae et ut neque tempora. Ab eius est qui doloribus ipsa est. Sapiente nesciunt ullam itaque corporis.

 

Dolores nihil magni labore qui quas. Dolor nemo autem porro quo magnam et. Tenetur rerum ab quo facere. Quas quis omnis cumque sapiente quidem sed vel. Vitae et vero est hic.

Illum cupiditate atque et laboriosam. Molestiae et modi est quis.

Et et dolore ducimus. Aliquid recusandae aut voluptatem et vel. Eos consequuntur optio voluptas. Totam nihil voluptatem ad et.

Occaecati temporibus impedit voluptatem dolorem praesentium. Ut fugit numquam soluta. Consectetur sunt iste in vel. Cum voluptatem rerum dolores in deleniti.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
GameTheory's picture
GameTheory
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
CompBanker's picture
CompBanker
98.9
10
Linda Abraham's picture
Linda Abraham
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...”