Financial Statement Analysis
 Ratio Analysis of Financial Statements (Formula, Types, Excel)
 Ratio Analysis Advantages
 Ratio Analysis
 Liquidity Ratios
 Cash Ratio
 Cash Ratio Formula
 Quick Ratio
 Quick Ratio Formula
 Current Ratio
 Current Ratio Formula
 Acid Test Ratio Formula
 Defensive Interval Ratio
 Working Capital Ratio
 Working Capital Formula
 Net Working Capital Formula
 Changes in Net Working Capital
 Change in Net Working Capital (NWC) Formula
 Cash Flow from Operations Ratio
 Cash Flow Per Share
 Cash Reserve Ratio
 Operating Cycle Formula
 Current Ratio vs Quick Ratio
 Bid Ask Spread
 Liquidity vs Solvency
 Liquidity
 Solvency
 Solvency Ratios
 Equity Ratio
 Capital Adequacy Ratio
 Liquidity Risk
 Altman Z Score
 Turnover Ratios
 Inventory Turnover Ratio
 Accounts Receivable Turnover
 Accounts Receivables Turnover Ratio
 Accounts Payable Turnover Ratio
 Days Inventory Outstanding
 Days in Inventory
 Days Sales Outstanding
 Days Sales Uncollected
 Average Collection Period
 Days Payable Outstanding
 Cash Conversion Cycle
 Cash Conversion Cycle (CCC) Formula
 Fixed Asset Turnover Ratio Formula
 Debtor Days Formula
 Working Capital Turnover Ratio
 Profitability Ratios
 Profitability Ratios Formula
 Common Size Income Statement
 Vertical Analysis of Income Statement
 Profit Margin
 Gross Profit Margin Formula
 Gross Profit Percentage
 Operating Profit Margin Formula
 EBIT Margin Formula
 Operating Income Formula
 Net Profit Margin Formula
 EBIDTA Margin
 Degree of Operating Leverage Formula (DOL)
 NOPAT Formula
 OIBDA
 Earnings Per Share
 Basic EPS
 Diluted EPS
 Basic EPS vs Diluted EPS
 Return on Equity (ROE)
 Return on Capital Employed (ROCE)
 Return on Invested Capital (ROIC)
 Return on Sales
 ROIC Formula (Return on Invested Capital)
 Return on Investment Formula (ROI)
 ROIC vs ROCE
 ROE vs ROA
 CFROI
 Cash on Cash Return
 Return on Total Assets (ROA)
 Return on Average Capital Employed
 Capital employed Employed
 Return on Average Assets (ROAA)
 Return on Average Equity (ROAE)
 Return on Assets Formula
 Return on Equity Formula
 DuPont Formula
 Net Interest Margin Formula
 Earnings Per Share Formula
 Diluted EPS Formula
 Contribution Margin Formula
 Unit Contribution Margin
 Revenue Per Employee Ratio
 Operating Leverage
 EBIT vs EBITDA
 EBITDAR
 Capital Gains Yield
 Tax Equivalent Yield
 LTM Revenue
 Operating Expense Ratio Formula
 Overhead Ratio Formula
 Variable Costing Formula
 Capitalization Rate
 Cap Rate Formula
 Comparative Income Statement
 Capacity Utilization Rate Formula
 Total Expense Ratio Formula
 Markup Percentage Formula
 Efficiency Ratios
 Dividend Ratios
 Debt Ratios
 Debt to Equity Ratio
 Debt Coverage Ratio
 Debt Ratio
 Debt to Asset Ratio Formula
 Coverage Ratio
 Coverage Ratio Formula
 Debt to Income Ratio Formula (DTI)
 Capital Gearing Ratio
 Capitalization Ratio
 Overcapitalization
 Interest Coverage Ratio
 Times Interest Earned Ratio
 Debt Service Coverage Ratio (DSCR)
 DSCR Formula (Debt service coverage ratio)
 Financial Leverage Ratio
 Financial Leverage Formula
 Degree of Financial Leverage Formula
 Net Debt Formula
 Leverage Ratios
 Leverage Ratios Formula
 Operating Leverage vs Financial Leverage
 Current Yield
 Debt Yield Ratio
 Solvency Ratio Formula
Related Courses
Flow of the Article
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 real estate industry and it is a common ratio that is used while doing the 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 –
Explanation of Operating Expense Ratio Formula
This ratio is more useful in 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 real estate industry, operating expenses include utilities, property management fees, maintenance, property taxes, insurance, repairs etc.
 The second component is 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.
4.9 (831 ratings)
 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.
Recommended Courses
Example of Operating Expense Ratio Formula
Let’s take a simple example to illustrate operating expense ratio formula.
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
Operating expense ratio formula is used heavily in real estate industry. But that is not the only industry where it gets used. It is also used in 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. Lower the OER, 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 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 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.
Video on Operating Expense Ratio Formula
Recommended Articles:
This has been a guide to Operating Expense Ratio formula, its uses along with practical examples. Here we also provide you with Operating Expense Ratio Calculator with downloadable excel template.