Multifamily Acquisition Model

Description
Are you interested in acquiring and evalutating a multfaimly acquisiton deal?


This template is a fully functional, institutional quality, and dynamic Multifamily Acquistion Model. It’s a powerful yet very user-friendly model that will provide the user with a detailed Excel spreadsheet in which the viability of an investment in a multi-family real estate property can be accessed with accuracy.


The user only needs to input information into the cells formatted in the dark blue font. If the contents of a cell are colored black, it means that it is a formula.


The template is provided with information from a hypothetical property for demonstration purposes that must be erased for a real property valuation.


The summary sheet provides an overview of the property based on several key metrics and assumptions.


The Scenario Tab provides a side by side comparison of T12 Financials compared to the Sponsor Projections.


CapEx Reserves Tab provides a budget outlining both initial CapEx requirements broken down by line item as well as ongoing CapEx and Reserves.


The maximum horizon for this model is ten (10) years;


Model includes the following:
- Deal-level NOI, IRR, Cash on Cash, Yield on Cost, etc.
- Unit Mix Upgrade and Renovation Sc
- 10-year cash flow
- As-Is vs Stabilized Pro Forma
- Rent and sale comps
- CapEx budget
- Debt schedules
- Full 3-tier equity waterfall
- Toggle capital events such as refinance / exit
- GP and LP Cash Flow Distributions