Operating Expense Ratio Excel Template
Originally published: 18/04/2018 11:52
Publication number: ELQ-25785-1
View all versions & Certificate

Operating Expense Ratio Excel Template

A template to calculate the operating expense ratio in Excel.

Operating expenses are required when running a business. When the cost of operations is compared with the revenue generated, we get the operating expense ratio (OER).

OER is commonly used in real estate and is a common ratio used while performing real estate analysis, where analysts judge the cost of operating a property with the income generated by the property.

The formula is the following:

Operating Expense Ratio = Operating Expenses / Revenues

The purpose of the OER is to see how much income a company has been generating in relation to the operating expense it is incurring. All companies want a low OER as this indicates good performance. As an investor, you need to see the OER of a company for a long period of time.

The template provided allows you to easily calculate the ratio. You simply need to provide two inputs of operating expenses and revenues.

This Best Practice includes
1 Operating Expense Ratio Excel Template

Dheeraj Vaidya CFA FRM offers you this Best Practice for free!

download for free

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • Kyaw Thu(last updated: 09/08/2019 05:04)

People using this Best Practice also downloaded


More Best Practices from Dheeraj Vaidya CFA FRM

See all

Any questions on Operating Expense Ratio Excel Template?

The user community and author are here to help. Go ahead!

5.0 / 5 (1 votes)

please wait...