Simple Rental Units (Apartments) Model – 5 Year Forecast

General considerations for the model:

All blue elements are inputs you need to adjust according to your assessment.
Forecast feeds from all your inputs.

What is the model for?

The model is designed to evaluate a simple rental unit business, based on a linear increasing rental and expenses adjusted for inflation that could affect your business along with all the required elements to design your capital structure (Equity and Debt assumptions), including the costs of closing and possible upgrades the building requires or unit.

What is included in the template?

The template is divided into two major sections, assumptions, and forecasting. On the first one, you will be able to detail all the closing costs of the building such as title, legal fees, appraisal, and site inspection among others to gather the all-in price of the building.

Afterward, you will find the Loan & Equity calculator which will help you detail your equity and loan details to derive your monthly debt payments. In the third section of the assumptions part, there will be the tac calculator based on the assessment tax factor will is inputted into the model according to your reality, the same goes for the tax rate.

The expenses calculator allows you to detail expenses according to your major expense lines such as the vacancy factor, the property management fee, the maintenance, and repair reserves required for the units or building, insurance, calculated taxes, and utilities.

On the forecasted P&L there is also an “others” line in case you need to include additional expenses. Below the expenses input, you will find the expense increase per year, simulating inflation increases. Lastly, you will have the income and appreciation section, on the first one you will be able to detail the rental for each apartment on the monthly basis and the model will automatically calculate the yearly basis, annual rent increases can be input as well.

On the appreciation side, after the P&L you will see the appreciation of the building following your annual cash flow and appreciation rate to get to your Return on Investment (ROI) and Capitalization Rate (Cap Rate). For credit purposes, the P&L includes Debt Service Coverage Ratio (DCSR) so you can monitor your debt service cushion.

For any inquiries on the model or specific modifications, please feel free to reach out using the Contact Author button on the right side of this page. Happy modelling!

You must log in to submit a review.