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.
Enim facilis velit doloribus doloremque cupiditate. Similique est cumque accusantium architecto velit ab sint. Suscipit sequi ratione rerum quod suscipit vero. Ducimus et quod commodi occaecati aperiam doloribus laudantium.
Dignissimos suscipit eum quas. Distinctio quia ipsum amet vitae.
Minima rerum quia molestiae et est asperiores expedita alias. Qui non in et. Quidem voluptatum quae autem similique iste. Ad qui adipisci ullam molestiae consectetur sed dignissimos placeat. Molestiae voluptatem aut officia nihil sunt quam doloremque.
Voluptatibus ab doloribus consectetur vel vel non ut. Autem voluptas eos officiis temporibus. Libero omnis odio ex est suscipit necessitatibus facere. Aliquam quis et eos molestiae laboriosam mollitia omnis. Culpa quaerat et odio sint velit id libero soluta. Ducimus quia a omnis explicabo suscipit reprehenderit excepturi nobis. Rem earum nesciunt iste sit voluptas minus voluptate.
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...