Forum Partners Case Study Real Estate - Private Equity

A tactical modelling exercise for aspiring investors, bankers, and analysts.

Two-part REPE case: an Excel skills test on deal-pipeline data, plus a full warehousing real estate investment case (NPV/IRR/CoC, pro-forma 3-statements, and an Investment Memorandum recommendation).

A two-part real estate private equity case study. Exercise 1 is a self-contained Excel skills test built on a real REPE deal pipeline dataset (deals identified, underwritten, LOI issued, signed PSA, closed) — candidates manipulate, summarise, and visualise the data using formula and pivot techniques. Exercise 2 is a full investment case on a $120m warehousing real estate business with five years of historical financials, structured opex / capex / leverage assumptions, and terminal value mechanics; candidates produce an Investment Memorandum covering NPV, IRR, cash-on-cash, payback, pro-forma 3-statements, and a final recommendation. Suits aspiring real estate PE associates, industrial / logistics REIT analysts, and acquisitions team candidates.

What you get

• Real Estate Private Equity ACTUAL Case Study 2025 - Excel Exercise.xlsx
• Real Estate Private Equity ACTUAL Case Study 2025 - Investment Case.docx

Sourced from a real-world actual case study — sanitised, rebranded, and prepared as a tactical study product.