Hi there!
I'm interviewing for the capital markets analyst position at a equity/debt shop (JLL/CBRE/C&W) and was told to come in for an excel modeling test after 2 interviews. Came from a non-finance background but had 2 internships with IBD and PE. Wanted to know what I should expect in the test. DCF, acquisitions, development, debt underwriting, etc. Thoughts?
Thanks a lot!
| +73 | Hiring Analyst/Associate - Advice | 35 | 7h | |
| +42 | Laid Off - Multifamily Acquisitions Help | 12 | 7h | |
| +39 | Is construction profitable? How do you raise capital? | 8 | 16h | |
| How many days a week are you expected to be in the office? | 24 | 5h | ||
| +23 | NYU MSRE Program | 7 | 5d | |
| +19 | Are Additional Capital Calls Usually Mandatory in REPE? | 8 | 1d | |
| +18 | M&A background to CRE Advice | 3 | 2d | |
| +18 | Multifamily Creative UW Assumptions | 4 | 11h | |
| +15 | How is this not illegal? | 3 | 3d | |
| +15 | OM - Data Room Advice | 13 | 5d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
I'm just thinking out loud here, but:
1) Be able to build out an amortization table with dynamic assumptions like interest only periods, etc.
2) Be able to go from EGI -> Operating Expenses -> NOI -> Cash Flow from Operations ->Before Tax Cash Flow -> calculating things like DSCR, Debt Yield, and Current Loan Balance.
From there, they might have you go through a disposition scenario where you calculate unlevered and levered returns (IRR, cash on cash, equity multiples) based on a terminal cap rate and hypothetical sales price.
Repellendus consequatur occaecati quasi voluptatem doloremque quisquam. Incidunt recusandae quibusdam ullam hic facere sunt.
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...