Operating expense ratio is the ratio of individual operating expenses or of total operating expenses to the gross operating income (GOI).
Operating expenses are items such as property insurance and taxes, repairs, utilities, and management fees. Operating expenses include any costs that are necessary to keep the revenue stream flowing. Mortgage payments and depreciation are not considered operating expenses, nor are capital expenditures.
Recall that the GOI is the revenue after vacancy and credit loss. Think of GOI not as the amount that you ought to collect, but rather the amount that you really collect. In that context, operating expense ratios tell you how the money you spend to operate the building relates to the money you receive.
You can use a property's expense ratios to decide if the operation of a particular investment opportunity appears typical, based on your knowledge of other similar properties. These ratios can also alert you to possible problem areas, both in regard to how the property has been run and to how accurate are the seller's representations.
It's important to look at the individual ratios of each operating expense and not just the ratio for total expenses. The total could appear entirely plausible while some of the individual items raise red flags.
Zilculator helps real estate professionals perform operating analysis quickly. Never use a spreadsheet again! Analyze your own property or create investment reports for your clients.
- Professional-grade branded investment reports
- Loading data from MLS®, Zillow®, and Rentometer Pro®
- Sales and Rental comps
How to Calculate Operating Expense Ratio of an Investment Property
- Calculate total operating expenses for a given year. Remember that depreciation and capital expenditures are not considered as operating expenses.
- Calculate gross operating income (see this artilcle for more info).
- Use the formula below:
Excel Spreadsheet Example
We prepared a simple example and calculation of operating expense ratio in an excel spreadsheet file. You can download the file, input your own numbers and calculate results in no time. The only thing we ask in return is for you to like our facebook page or follow us on twitter.