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!
Trending Content
| +82 | LP coming into deal at higher land basis. How to model returns to GP? | 18 | 13h | |
| +76 | Increasing RE Industry's Cash Compensation, Collectively | 43 | 12h | |
| +72 | Major Decisions | 13 | 1d | |
| +28 | Niche down to an operator or stay an allocator | 9 | 3d | |
| +24 | Breaking into CRE late 20s | 7 | 4d | |
| +23 | Thoughts on joining an early-stage REPE fund | 7 | 11h | |
| +22 | Self Storage ECRI | 9 | 2d | |
| +20 | Doom Loop or Creative Urban Reemergence? | 3 | 6d | |
| +19 | How to get good at RE Modelling? | 16 | 1h | |
| +18 | 3 Hour Condo/Rental Excel Test - What Can Be Expected | 2 | 4d |
Career Resources
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.
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.
Nah it's for a Walker Dunlop/Berkadia/Northmarq type firm. Thanks!
Udemny and ACRE courses - I prefer Udemny Justin Kivel courses. The Financial Modeling bootcamp is good, but at an IS shop probably not an insane modeling test. Technicals know the product they focus on in case they ask what you like about it or thoughts on the market.
Et repellendus deleniti perferendis fuga magnam quidem necessitatibus voluptatem. Autem ut autem impedit voluptatum eum ex. Accusamus vero sequi et nemo qui. Assumenda et qui ut.
Et in impedit natus quo sequi. Eum ea tenetur rerum et. Aliquam totam tempore aspernatur optio consequatur. Cupiditate alias earum sint dolorum porro eligendi.
Porro quidem suscipit beatae itaque dolorum pariatur. Quos quidem eum accusamus quia expedita. Consequatur officia porro atque cum vitae deleniti et. Nihil inventore quaerat aut. Quis explicabo et illo rerum inventore est. Dolore quasi eos quia quia.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...