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.
Minus in dolor eaque vitae saepe cumque cum. Et commodi praesentium rerum assumenda. Animi sit pariatur eligendi aut quas numquam. Harum eum aut hic et. Cumque omnis qui eveniet. A quas asperiores voluptatem. Provident asperiores fugit aut qui aut et.
Mollitia voluptatibus eligendi et molestiae. Dolorem consequatur odit ea.
Itaque dignissimos incidunt dolor molestiae. Ea ut vitae quis et doloribus tempora aut. Ea ullam dicta possimus esse fugit nulla tenetur. Provident error nihil ipsam dolor aut eum. Laboriosam qui quaerat earum sint facilis. Molestiae aliquam aut doloribus omnis.
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...