1000 Unit Rent Roll Template (Excel XLSX)

If you ever wanted to drive your real estate pro forma off individual units, this template is for you. There are slots for up to 1,000 individual units and each one has its own input for the unit type, unit category, starting monthly rent, start month of rent, annual rent escalation, and average monthly expenses per unit, annual expense increase, and square feet.

In order to complete the pro forma, the model has additional assumption tabs for general operating expenses, other ancillary income sources, and starting debt amortization (if applicable).

All the assumptions are consolidated on a monthly, quarterly, biannual, and annual pro forma report that displays information for up to 20 years. You will see the net operating income as well as cash flow per period.

To make the real estate analysis easier to digest, there is a dashboard with visuals for all key metrics and financial performance over time.

The template is downloadable Excel file, but is also available in Google Sheets format. The link to the Google Sheets version is provided in the first tab of the model.

One interesting aspect of this real estate model is that you can define the units in high level categories and see resulting revenue and expenses based on those four categories. This would be relevant if you had two types of residential units and two types of commercial units. If you wanted to see the revenue coming from each type, it will be possible. If there is only a single high level category to report on, that is fine as well and you can just use a single type in that selection column. Dropdown validation is used to avoid data entry errors.