This product is best for
Fastest possible basic feasibility by solving for a stabilized yield on purchase price
Overview
An Excel-based annual spreadsheet analysis tool for the acquisition of an existing apartment/multi-family rental building that allows for modeling of the renovation of individual apartment units while continuing to operate the building.
A blended average building-level approach is used to simulate the income and expense profiles of both pre- and post-renovated unit states. By design, there is no rent roll or unit mix, and the model does not key off of specific unit rollovers and renovations. Rather, it approximates the unknown sequencing of the unit rollovers using an average unit renovation budget and the aforementioned blended average income and expense values.
The model is a 100% unlocked Excel file with fully transparent formulas that can be further tailored to suit the particulars of your transactions.
User-friendly Features
- Compatible with Excel on PC, Mac and iPad
- Includes detailed annotations of input cells
- Data validation protections to prevent faulty inputs
Functional Highlights
The model supports the following:
- Use of T12, T9, T6 or T3 historical data for inputting income and expenses
- One layer of acquisition financing (amortizing or interest-only, or amortizing with an interest-only period)
- Ability to renovate units in Years 1, 2, or both.
Model Timeline
2 years
Reports
Print-ready 1-page presentation