Learning to create Excel Models for Real Estate Quickly! Help

mcnameo's picture
Rank: Monkey | 60

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!

Comments (10)

Jun 2, 2011

Breaking Into Wall Street just added a Real Estate & REIT Modeling section.

Jun 2, 2011

asworth damodoran has a book out there somewhere on building excel models....

surf his website - http://pages.stern.nyu.edu/~adamodar/

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

Jun 2, 2011

second biws, its worth the investment.

Jun 2, 2011

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.

Jun 2, 2011

I would get the wiley corporate finance modeling book and learn from there. They take you through step by step so you'll learn it thoroughly. Also the VBA section is very valuable and can make you stand out.

Learn More

Side-by-side comparison of top modeling training courses + exclusive discount through WSO here.

Jun 2, 2011

Has anyone bought the BIWS Excel Fundamentals and/or the Real Estate Modeling course?

Jul 10, 2013

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.

Jul 13, 2013

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.

Jul 15, 2013
Comment
    • 1