Free Practice Case · Acquisition

Multifamily Acquisition Case Study

A 1-hour practice case built like a real REPE modeling test. You are an analyst deciding whether a stabilized 120-unit apartment community in Charlotte works at the $27.5M asking price.

  • Level 1: Foundational
  • Best for Analysts
  • 1 Hour
Multifamily Acquisition Case Study PDF, page 1, showing the overview and assumptions

What's inside

Case Contents

  • Overview. The deal, your role and the question your VP needs answered.
  • Property assumptions. Units, in-place rent, other income, vacancy, operating expenses, reserves and growth rates.
  • Purchase and sale. Asking price, closing costs, a 5-year hold, exit cap rate and selling costs.
  • Financing. A 65% LTV loan at a 6.0% fixed rate on a 30-year amortization.
  • Required outputs. Year 1 cap rate, DSCR and cash-on-cash, plus unlevered IRR, levered IRR and equity multiple.
  • Assignment questions. Does the deal hit a 12.0% levered IRR, what is the most you would pay, and does the loan meet a 1.25x DSCR?

How to use it

Work It Like a Test

Set a 1-hour timer and build the 5-year pro forma in a blank Excel workbook, starting with sources and uses. Then calculate the required outputs and answer both questions in a sentence or two, the way you would for a VP.

Stuck, or want someone to check your work? Book a 1-on-1 session, or learn the full build in our real estate financial modeling course. You can also compare your model with the free multifamily acquisition model.

Free download

Download the Case Study

Answer a few quick questions and the PDF is yours. Browse all case studies.