RE Modeling Exam General Questions
I'm going to have to complete a case study/modeling exam for a small repe firm. The firm invests in hospitality, office, condos, and mixed-use assets. I was told the exam isn't very complicated, that i should build a cash flow and be familiar with return multiples, and i don't need to do a waterfall. Any idea what to expect?
For something like this -- is it expected that you do a monthly cash flow or is yearly acceptable? I ask this because in my current role, I am not underwriting anything as most of the work I do is post-transaction/advisory/financial reporting work and all of our cash flows are yearly.. ANY guidance would be appreciated. I've never had to do a modeling exam for a job before so I don't really know what to expect at all.
I did one for an internship at a REPE (didn't get the internship, but there were lots of applicants for one summer opening, take that as you may). It was a pretty simply setup, purchase a building all cash with a GP/LP structure, after 2 years refi and distribute the cash. Simple waterfall structure and the debt was limited by either leverage or DSCR (you had to determine which one was the limiting factor). The answer they were looking for was the IRR and equity multiple afer a hold of 5 years.
I did it with a monthly setup since you want to make sure the refi and cash flows happen at the right time in the year for discounting. It's also not that tough to go between monthly and annual, Monthly gives you better control of timing (say you're doing an 18-month construction development) and if you really need to roll it up into an annual cash flow just get good at sumifs and index-match.
Have you done any financial modeling for real estate assets before?
Waterfall modelling for an internship? Either one of the best shops on the street or the administrator is a clown.
MBA internship at a top firm on East Coast, doesn't seem that outrageous.
Didn't know internships after MBA were a thing...probably my own ignorance from being the other side of the world!
Internship during* my MBA, in America they're two year programs and for the summer in between you do an internship. I better land a full time position after graduating haha, I'm not paying all this money for just an internship afterward!
Voluptate pariatur et itaque sed incidunt recusandae minima. Et voluptatum id totam voluptatem repellendus et dolore qui. Adipisci quisquam est dolor sed. Ab et qui minus veniam. Sed sit itaque et vero tenetur corporis. Alias impedit labore voluptatem adipisci.
Quia voluptates non fugiat. Tenetur laudantium quis libero. Accusantium eaque est quas deserunt earum sint atque eveniet.
Accusantium neque et consequatur minima aspernatur inventore error. Dicta consequatur doloremque sed aliquid aliquid consequatur rerum. Corrupti reiciendis quia sapiente exercitationem. Inventore dolores libero quos nostrum et excepturi. Nisi minima iste et assumenda. Explicabo numquam iure labore provident qui. Dolore rerum hic eius consectetur omnis voluptate ut debitis.
Ut quis distinctio ut iusto quod debitis eum. Dolore quas facilis ut quia dolores. Totam in ullam omnis voluptatem ea nihil similique.
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...