The Multi-Units tab is available to users of the Pro Version only. This tab will help you review multi-unit properties and large apartment complexes.
The tab is divided in two sections:
This section is divided in 3 sub-sections: 1) General Operating Assumptions, 2) Overhead Expenses Assumptions, 3) Rule of Thumb.
General Operating Assumptions
In the General Operating Assumptions section, you can precise the scope, unit (% of rent or a # of weeks / months per year) and value of your vacancy rate.
Rent increase assumption can apply to all units (if scope is General) or be set on a per-unit type basis. When “Per Unit” is selected as the applicable scope, the general value cell is automatically grayed out. Your individual assumptions then have to be entered in the “Unit Details” section rather than in the General Assumptions Section.
Enter your assumptions regarding fixed and variable expenses. Fixed expenses assumptions automatically apply to all units (scope is global by default). Scope of variable expenses (including capex) can be adjusted as required.
Overhead Expenses Assumptions
Enter the overhead expenses of your multi-family property in the Overhead Expenses Assumptions sub-section. These expenses can be entered using various units:
For each overhead expense, it is possible to enter an annual rate of increase (unless you have selected % of GSI, in which case the expense will grow proportionally with GSI).
Rule of Thumb
If you don’t want to enter detailed operating assumptions regarding your property, you can use the Rule of Thumb feature to quickly estimate operating expenses (including capex) as a % of GSI.
The Unit Details section lets you enter specific operating assumptions for each unit type. Up to 10 unit types can be used in the spreadsheet and an unlimited number of units can be associated with each unit type.
Use the “# of units” to indicate how many units compose each unit type. For instance, if your property includes 3 studios and 4 one-bedrooms, enter 3 in the first column and 4 in the second column, then enter the assumptions applicable to each unit type:
Once information has been entered for all applicable unit types, the spreadsheet will automatically calculate the consolidated monthly and yearly amounts which will then flow to the Unit Data tab.
Terms & Conditions
© 2021 RealEstateSpreadsheets.com – All rights reserved.