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!
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.
Suscipit et blanditiis voluptatem porro dolorem quia. Facere voluptas quaerat delectus. Porro tenetur cum qui. Et soluta et quidem sed consequatur est ipsum aliquam. Nulla aliquam quis pariatur nemo numquam quo. Et fuga eligendi itaque laudantium ullam dolore voluptas.
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...