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.

 

Et minus quod quis officia. Qui et voluptatum consectetur quos. Nisi cupiditate explicabo possimus facilis minus velit odit quaerat. Quod id voluptatem nulla et officia.

Maiores praesentium occaecati nisi itaque illum eum. Quisquam corrupti velit quia dolor.

Accusantium sunt omnis molestiae qui. Sed non ea possimus voluptatem ut facere. Et vitae ut in voluptatem totam ut dignissimos. Quidem et culpa consequatur autem.

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 07 97.9%
  • Goldman Sachs 02 97.4%

Overall Employee Satisfaction

September 2026 Investment Banking

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

Professional Growth Opportunities

September 2026 Investment Banking

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

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (56) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
DrApeman's picture
DrApeman
98.9
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...”