Financial Modeling help - Urgent

So I have an interview for a Real estate investment position, had the phone interview and it went well so got an in person interview for this friday.

Now I get an email asking me to send them a financial model that I have built, created, or worked on so that the managers can speak to me about it.

So my request is does anyone have a link for a basic model template with which I can learn in the next few days and learn to make some basic modifications

I know this is not something that I can learn in a few days which is why I am asking for a basic model with which I can get somewhat familiar with

I would really appreciate your help guys as a fellow job seeker, thanks in advance

 

I don't think anyone is going to give out their own models (for work reason). You best bet is to buy this course. They have templates (shell models) and also competed ones. You still have 48 hours.

I suggest you finish the entire online course. I think it would be beneficial for you this way since you will really learn how the model really works. This will help out especially at the technical parts of the interview. Real Estate (plus Financial Institutions and Oil & Gas) modeling is very different from other type of modelings (the remaining groups Technology, Consumer, Industrial). Hope it helps. Good luck with the interview.

"I am the hero of the story. I don't need to be saved."
 

Question - does the group you are interviewing with know that you dont have any modeling experience? It seems they are expecting someone who can put together investment models from scratch. Its best to be honest with them.

Man made money, money never made the man
 

I've heard bad things about BIWS, so not sure if you want to do that. Wall Street Prep was actually not bad. If you don't want to learn or pay, check out finance 3.0 or google damodaran's models. He has a ton floating out there and may have an RE one.

"It is hard to fail, but it is worse never to have tried to succeed." Theodore Roosevelt
 

I have seen the Damodaran RE model, its dated, not very sophisticated, and difficult to understand if you dont have exp in real estate finance. BIWS actually seems legit, but it has a heavy emphasis on REITs. I just checked out WSP, I didnt see any courses that focused on RE investments. Besides, none of this info will help you learn modeling in a 2-day time frame. I wouldnt recommend any of those resources.

Man made money, money never made the man
 

To RE Capital Markets: I never listed modeling as a skill on my resume, nor did they ask for it as a skill in the phone interview.

I am going to tell them that I do not have experience with modeling but I want to show some initiative by showing familiarity with a basic model atleast

 

financial models of devel. projects (measuring, among other things, pro forma IRRs and NPVs), to assist analysis of proposals for financial incentives; performing sensitivity analyses to corroborate and test assumptions and other pertinent information provided by applicants

this is the type of modeling inolved in the position, but they are just asking for any type of model that I have worked on

 
hifromrohit:
financial models of devel. projects (measuring, among other things, pro forma IRRs and NPVs), to assist analysis of proposals for financial incentives; performing sensitivity analyses to corroborate and test assumptions and other pertinent information provided by applicants

this is the type of modeling inolved in the position, but they are just asking for any type of model that I have worked on

Are you comfortable with doing any one of those?

"I am the hero of the story. I don't need to be saved."
 
Best Response
hifromrohit:
financial models of devel. projects (measuring, among other things, pro forma IRRs and NPVs), to assist analysis of proposals for financial incentives; performing sensitivity analyses to corroborate and test assumptions and other pertinent information provided by applicants

this is the type of modeling inolved in the position, but they are just asking for any type of model that I have worked on

Huh. That's the type of work that's expected of a more senior hire, typically with at least 2 yrs of RE modeling exp. I am afraid your interviewer is expecting something above and beyond of what you can actually do.

Man made money, money never made the man
 

Et consequuntur amet iure quibusdam voluptates. Tenetur et vero nesciunt minima fugit repudiandae maiores. Necessitatibus sit ea est nemo omnis eos.

Molestias quam nam in quisquam nemo ullam. Cupiditate aut praesentium hic repellendus perferendis id.

Man made money, money never made the man

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.8
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...”