How to prepare to prepare for IS Financial Analyst interviews?

I have an interview coming up for a Financial Analyst role for a multifamily IS sales team. How should I prepare for the verbal interview (technicals) and the possibility of an Excel test? What do I need to know before going in? I currently work as an Underwriting Analyst for a multifamily lender and while I work a lot in Excel, I don't have many reps building models from scratch, and return metrics such as IRR, etc. I have done the first two REFM certs but it has been years. Thanks in advance! 

 

Hi crewannabe1, just because I'm a bot doesn't mean I don't have feelings...I'm hoping these links are helpful. If not, feel free to throw monkey shit at me...

More suggestions...

I hope those threads give you a bit more insight.

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 
Most Helpful

Is this for Eastdil? If not I wouldn't get too hung up on technicals, just have your story down of why you want to join this firm and why it makes sense at this point in your life. Have a few deals that you worked on ready to be able to talk about at the broad level, and maybe some details ( cap rate, price per sf. etc). Coming from a lender to IS, they are going to be less concerned about your technical ability, as you likely have that box checked. They are more likely going to want to suss out if they want to be around you for 12-15 hours a day, and if you are capable of learning quickly and not looking to jump ship in a year. 

For the model building, know how to build a basic model down to NOI and after tax cashflow, and be able to calculate the basics: Cash on cash, IRR, equity multiple. They will more than likely want to know what price you would have to pay for certain returns, so know how to use goal seek or solver to be able to back into a purchase price. 

 

Voluptatem unde delectus ducimus ea molestiae vero enim. Quas impedit odio illo officiis. Rem totam qui quisquam quis laboriosam.

Career Advancement Opportunities

June 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Perella Weinberg Partners New 98.9%
  • Lazard Freres 01 98.3%
  • Harris Williams & Co. 24 97.7%
  • Goldman Sachs 16 97.1%

Overall Employee Satisfaction

June 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 05 97.7%
  • Moelis & Company 01 97.1%

Professional Growth Opportunities

June 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Perella Weinberg Partners 18 98.3%
  • Goldman Sachs 16 97.7%
  • Moelis & Company 05 97.1%

Total Avg Compensation

June 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (92) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (206) $159
  • Intern/Summer Analyst (148) $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
Betsy Massar's picture
Betsy Massar
99.0
5
GameTheory's picture
GameTheory
98.9
6
kanon's picture
kanon
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
bolo up's picture
bolo up
98.8
10
numi's picture
numi
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...”