Sample financial modelling tests?
Hi All,
I am teaching a few of my analysts basic RE modeling (I am far from a modeling wizard and joke that I am a bit of caveman but know enough to get by) with the end goal of being able to successfully pass a test like those a lot of analysts take as part of the interview.
If anyone has any sample tests they could share would be appreciated. I am going to put together a sample test based on the stuff below but would like to see how others structure their models and what expectations usually are.
Below is per https://www.getrefm.com/what-to-expect-on-an-inte…
Assumptions:
(if development) development budget and timeline
capital structure set-up detailing the layers of financing
rent roll or market rent
exit cap rate
market leasing assumptions for when tenant leases end
Tasks:
(if development) sources and uses of funds projection modeling
property operating cash flow projection
integration of debt financing, either interest-only or amortizing
integration of sale event and debt repayment
calculation of deal-level unlevered and levered IRRs, equity multiple and average cash-on-cash return
joint venture equity waterfall construction and calculation of IRRs and equity multiples to each of the partners
answers to the questions: “Should we do this deal? Why or why not?”
Thanks!
Et rerum minima dolorem nostrum. Odit aliquid laborum enim consectetur nesciunt sint deserunt. Vitae fuga necessitatibus quo deserunt sint. Quo velit consectetur voluptas odit vitae ex.
Quod possimus excepturi quod voluptas. Ducimus repellat laboriosam ad fuga asperiores consequatur minus. Quo dolorum eius dignissimos nesciunt. Corrupti impedit commodi quo impedit praesentium.
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...