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)


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...