andrew@agcapitalcfo.com

Stage 3 (2022) “Lease It Up”

Professional Excel Templates for your Business

Stage 3 (2022) "Lease It Up"

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., a multi-unit apartment building in LargeCity, is ramping up occupancy and wants to create a detailed rent forecast for the next three years. The management needs to determine the future leases of the 318 units, the cash flows from them, and some key metrics. The data available includes a rent roll containing information on each unit, unit type, contracted leases, market rents, etc. The forecasted metrics are required on a monthly basis for three years, from 2022 to 2024.

The challenge for LeaseUp Inc. is to accurately forecast the future leases of the units and the cash flows from them. This requires careful consideration of various metrics, including rent, occupancy by SqFt, loss to lease, vacancy, concession, market rent, actual rent, etc. The calculations involve assumptions that each lease term is exactly 12 months, each unit moves to the next lease 20 days after the previous Lease end date, and new lease rates cannot exceed 4.0% higher than the previous lease rate for the same unit.

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

You can also buy tickets to participate in the future FMWC Stages here.

Reviews

There are no reviews yet.

Be the first to review “Stage 3 (2022) “Lease It Up””

Your email address will not be published. Required fields are marked *