The operating expense ratio, or OER, measures how much of a property's income is eaten up by the cost of running it. In Excel it is a single division: operating expenses divided by gross operating income, entered as =B2/B1 and formatted as a percent. The formula is trivial. The judgment is in deciding which costs count as operating expenses and which do not, because the mortgage, capital improvements, and depreciation all stay out of the ratio.
Get those inclusions right and the OER tells you, in one number, how efficiently a property runs and whether that efficiency is drifting over time. Here is how to build it in Excel, what belongs in each side of the fraction, and where the number can mislead you.
What is the operating expense ratio?
The operating expense ratio is the share of a property's income that goes to operating it. A 45 percent OER means 45 cents of every income dollar is spent on taxes, insurance, utilities, management, and upkeep, leaving 55 cents as net operating income before debt. Lenders and investors watch it because, unlike a single expense figure, it is comparable across properties of different sizes and because a rising OER on a stable building is an early sign that costs are outrunning rent.
The operating expense ratio formula in Excel
Put the two inputs in their own cells and reference them. Keeping gross operating income and total operating expenses as labeled cells makes the sheet easy to audit later.
| Cell | Label | Value |
|---|---|---|
| B1 | Gross operating income | $240,000 |
| B2 | Total operating expenses | $103,200 |
| B3 | Operating expense ratio =B2/B1 | 43.0% |
Format B3 as a percentage with one decimal. That is the whole calculation. Everything else is making sure B1 and B2 contain the right things.
Which costs count as operating expenses?
Operating expenses are the recurring costs of keeping the property running and rentable. The usual line items are property taxes, property insurance, utilities the owner pays, property management fees, repairs and maintenance, landscaping and cleaning, and general administrative costs. These are the numbers that belong in B2.
Four things are deliberately left out, and mixing them in is the most common way an OER gets distorted. Debt service, the mortgage principal and interest, is a financing cost, not an operating cost, so it stays out. Capital expenditures, like a new roof or an HVAC replacement, are investments in the asset rather than operating costs. Depreciation is a non cash accounting entry, not a cash expense. And income taxes on the owner belong to the owner, not the property. Leave those four out and the ratio compares the building's operations, not the owner's financing or tax situation.
Gross operating income, not gross rent
The denominator should be gross operating income, sometimes called effective gross income, not the gross potential rent. Start from gross potential rent, subtract vacancy and credit losses, then add other income such as parking, laundry, or fees. That effective figure is what the property actually collected, and using it keeps the ratio honest. Dividing expenses by potential rent instead flatters the number, because it pretends every unit was full all year.
Worked example
A small apartment building has gross potential rent of $260,000. Vacancy and credit loss run 10 percent, or $26,000, and other income adds $6,000, so gross operating income is $240,000. Operating expenses total $103,200: taxes $34,000, insurance $9,200, utilities $18,000, management $19,200, and repairs and maintenance $22,800. The OER is 103,200 divided by 240,000, or 43.0 percent. If a new roof is installed the same year for $40,000, resist the urge to add it to the ratio. It is a capital expenditure, so the OER stays at 43.0 percent and the roof is tracked separately.
What is a good operating expense ratio?
There is no single figure that is good for every property, and any source that quotes one number for all of real estate is oversimplifying. The ratio depends heavily on property type, age, location, and which utilities the owner pays versus the tenant. A newer, tenant metered building runs leaner than an older one where the owner covers heat and water. What matters more than the absolute level is the trend: track the same property's OER year over year, and a steady climb with flat rent means expenses are eating into returns and deserves a look. Compare against similar properties in the same market rather than a national rule of thumb.
Common mistakes that distort the ratio
A handful of errors turn up again and again. Slipping debt service into the expenses is the biggest, and it makes a leveraged property look far less efficient than an identical one bought with cash, even though the operations are the same. Lumping a one time capital project into a single year spikes the OER for that year and makes the trend unreadable, so keep capital items in their own line. Using gross potential rent instead of gross operating income understates the ratio by ignoring vacancy. Double counting a cost that a management fee already covers inflates expenses. And comparing a gross lease property, where the owner pays most costs, against a net lease property, where tenants do, produces a gap that has nothing to do with efficiency. The fix for all of them is the same discipline: define the numerator and denominator once, apply them consistently, and note which lease structure the property uses.
Operating expense ratio vs net operating income
The OER and net operating income come from the same statement and are easy to confuse. Net operating income is a dollar figure, gross operating income minus operating expenses, and it is the income the property throws off before debt. The operating expense ratio is the same relationship expressed as a percentage of income rather than a dollar amount. They move in opposite directions: a lower OER means a higher share of income survives as NOI. Report both. NOI feeds valuation and lending, while the OER is the quick read on how tightly the property is run and how that is changing over time.
Where the numbers come from
The inputs live on the property's operating statement or trailing twelve month report, and those often arrive as a PDF from a broker, a seller, or a property manager. Retyping every expense line into Excel is slow and error prone, and one fat fingered figure throws off the ratio. Converting the operating statement PDF to Excel drops each line into its own cell so you can sum the operating expenses and pull gross operating income straight into the formula. The same underwriting sheet usually feeds the net operating income and cap rate calculations, so it is worth getting the statement into spreadsheet form once and reusing it. When the expense detail is buried in the lease documents themselves, teams often pull the recoverable and owner paid costs out with software that abstracts the key terms from each lease before the numbers ever reach the model.