Learning to create Excel Models for Real Estate Quickly! Help

Hey

I have a final round interview coming up a month from now. This interview is for a PERE / REIT analyst position. They will be grilling me on creating an excel spreadsheet from scratch. I am almost clueless on this. I have nailed my other interviews, but this is the part I have been dreading.

Does anyone have any tips on how I can go from noob to competant in the next month for excel modeling from scratch for real estate? Resources? Tools? Programs?

Thanks!

9 Comments
 

wow didn't mean to butcher his name: aswath

Here's the thing. If you can't spot the sucker in the first half hour at the table, you are the sucker.
 

BIWS Excel Fundamentals and/or the Real Estate Modeling course looks very attractive.

Is it worth the price tag for someone who wants to do property-level acquisitions? It seems more top level and corporate than building by building acquisitions and development focused.

 

It is also good to get your Excel foundations down. Youtube is solid, free resource to get those foundational elements. I like the following videos (with accompanying practice excel files) from Chris C.

YOUTUBE CHANNEL: http://www.youtube.com/user/ExcelIsFun?feature=watch

SOURCE EXCEL FILES: http://people.highline.edu/mgirvin/ExcelIsFun.htm

The collection is pretty gigantic with 2000 Excel How to Videos and 50 Playlists of Excel Videos.

 

Laborum numquam asperiores pariatur qui corporis consequatur vitae. Sed reprehenderit et architecto natus aliquid assumenda ipsum. Odio ut qui nihil est sed odio aspernatur. Odio deserunt quibusdam velit earum iure.

Quo ad eaque soluta vel voluptatum nobis nihil consequuntur. Natus quia dolores ad. Qui at laudantium dolorem architecto laboriosam eum quia. Ratione ad quia assumenda. Atque reiciendis sint aut et.

Repudiandae fugit ut dicta qui quaerat cupiditate porro. Rem corrupti velit earum minus. Aliquid corrupti in vel est. Perspiciatis eos commodi voluptatem qui. Quia aperiam laborum odio voluptatem aut sed quis.

Career Advancement Opportunities

July 2026 Investment Banking

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

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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
kanon's picture
kanon
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
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...”