WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Operating Expense Ratio Formula

Operating Expense Ratio Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Operating Expense Ratio is the ratio between the cost of operation to the net revenue and is typically used in evaluating real estate properties, where higher Operating Expense ratio means higher operating expense as compared to its property income and serves as a deterrent and lower operating expense ratio implies lower operating costs and therefore, preferable and investment-friendly.

Operating Expense Ratio Formula

Operating expenses are required for operating a business. When we compare the cost of operation with the revenue generated, we get operating expense ratio (OER).

OER is popular in the real estate industry, and it is a common ratio that is used while doing real estate analysis. In real estate analysis, the analysts judge the cost of operating a property with the income generated by the property.

Here’s the formula for operating expense ratio –

Operating Expense Ratio = Operating Expenses / Revenues

Operating-Expense-Ratio-Formula

Explanation of Operating Expense Ratio Formula

This ratio is more useful in the real estate industry; let’s have a look at OER from that perspective.

In this ratio, there are two components.

  • The first component is the most important one. It is operating expenses. In the case of the real estate industry, operating expenses include utilities, property management fees, maintenance, property taxes, insurance, repairs, etc.
  • The second component is the revenue. Revenues are the income generated from a specific property.

For example, a company has bought a property to rent out to other smaller companies. To find out how the property is doing, the company would look at OER.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • If the operating ratio is higher, the company would think twice about keeping the property.
  • On the other hand, if the operating ratio is lower, the company would consider the property as a great investment.

Example of Operating Expense Ratio Formula

Let’s take a simple example to illustrate the operating expense ratio formula.

You can download this Operating Expense Ratio Excel Template here – Operating Expense Ratio Excel Template

Onus Inc. has been comparing its operating expenses for a property it bought and trying to find out the OER. Here’re the details –

  • Operating expenses – $40,000
  • Revenues – $400,000

Find out the OER of Onus Inc.

Using the operating expense ratio formula, we get –

  • OER = Operating Expenses / Revenues
  • Or, = $40,000 / $400,000 = 10%.

If we compare the ratio with the other companies in the same industry, we will be able to interpret the OER properly.

Use of Operating Expense Ratio Formula

The operating expense ratio formula is used heavily in the real estate industry. But that is not the only industry where it gets used. It is also used in the manufacturing industry and service industry.

  • The purpose of using OER  is to see how much income a company has been generating in relation to the operating expense it is incurring.
  • Every company wants the OER to be lower. The lower the OER, the better the company is performing.
  • If you are looking at a company as an investor, you need to see the OER of the company for a long period of time.
  • If you look at the OER of a company for long, you will be able to discover a trend of how the ratio between operating expenses and revenues are getting shaped.
  • Then you can take that trend and compare it with the OER of other similar companies under the same industry.
  • If the OER of the target company is lower than other companies in the same industry, the target company can be the right company to invest in. However, you also need to look at other financial ratios of the company before you decide.
  • OER measures the flexibility and the competency of the managers of a company. Understanding this will help you a lot as an investor.

Operating Expense Ratio Formula Calculator

You can use the following Operating Expense Ratio Calculator.

Operating Expenses
Revenues
Operating Expense Ratio Formula
 

Operating Expense Ratio Formula =
Operating Expenses
=
Revenues
0
= 0
0

Operating Expense Ratio Formula in Excel (with excel template)

Let us now do the same example above in Excel.

This is very simple. You need to provide the two inputs of Operating Expenses and Revenues.

You can easily calculate the ratio in the template provided.

Operating Expense Ratio Formula in Excel

Video on Operating Expense Ratio Formula

Recommended Articles:

This article has been a guide to the Operating Expense Ratio formula, its uses along with practical examples. Here we also provide you with an Operating Expense Ratio Calculator with a downloadable excel template.

  • Examples of Operating Expense
  • Expense Journal Entries
  • Risk-Reward Ratio Definition
  • Operating Ratio Formula
3 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

WallStreetMojo

Download Operating Expense Ratio Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More