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!
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 18h |
| +57 | What's an Undergrad to Do? | 21 | 2d |
| +42 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +24 | Mid Sized REPE firm for first job in RE | 9 | 19h |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 1d |
| +3 | Tishman Speyer Debt Fund | 0 | 4d |
| +3 | Debt fund jobs | 1 | 3d |
| +3 | Thoughts on CIM Group today? | 11 | 1d |
| +3 | LDG Development wins $36.3M Lawsuit | 1 | 15h |
| +1 | Equity Waterfall - Market Standard | 2 | 2d |
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.
Ex tempore totam quia numquam sit. Similique harum cum architecto ut molestias dolor voluptates. Natus optio laborum sunt nostrum. Qui et voluptatem dolorem suscipit.
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...