Stage 3 (2022) "Lease It Up"


This is an actual case study that was presented to the participants of the Financial Modeling World Cup 2022, Stage 3 (April 22-25).

Case study description:
LeaseUp Inc. owns a multi-unit apartment building in LargeCity in BigCountry. The property was constructed in 2020 and has been leased up over the last year. The property is rapidly ramping up occupancy and is likely to stabilize soon.
The management wants to create a detailed rent forecast for the next three years considering the leases in place, contracted future leases, market rents, etc. You need to forecast the future leases of the units, the cash flows from them and some key metrics.

The downloadable file consists of the following:
Task: PDF file with Case Materials; PDF file with Questions; Excel file with initial data and case assumptions
Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold