Multifamily Development Model/Mixed-Use

Description
Are you interested in evaluating a multifamily/mixed-use development opportunity?

This template is a fully functional, institutional quality, and dynamic Multifamily/Mixed-Use Development 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 a multifamily/mixed-use development 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 cash flow tab shows a monthly projection going up to 150 months as well as returns both on a levered and unlevered basis.


The loan schedule shows a draw down schedule for both euqity and debt.


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

Model includes the following:
- Project assumptions including land basis, parking, and retail components
- Deal-level NOI, IRR, Yield on Cost, Equity Multiple, etc.
- 12.5-year cash flow
- Timing Assumptions- Sources and Uses (Levered and Unlevered)
- Operating Assumptions
- Financing (Construction and Perm Loans)
- Returns Summary
- Lease Up Schedule
- Draw Schedule