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!