Financial Statement Analysis
- Ratio Analysis of Financial Statements (Formula, Types, Excel)
- Ratio Analysis
- Liquidity Ratios
- Turnover Ratios
- Profitability Ratios
- Profit Margin
- Gross Profit Margin Formula
- Operating Profit Margin Formula
- Net Profit Margin Formula
- EBIDTA Margin
- 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 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
- Revenue Per Employee Ratio
- Operating Leverage
- EBIT vs EBITDA
- Capital Gains Yield
- Tax Equivalent Yield
- LTM Revenue
- Operating Expense Ratio Formula
- Overhead Ratio Formula
- Capacity Utilization Rate Formula
- Total Expense Ratio Formula
- Efficiency Ratios
- Dividend Ratios
- Debt Ratios
- Debt to Equity Ratio
- Debt Coverage Ratio
- Debt Ratio
- Debt to Income Ratio Formula (DTI)
- Capital Gearing Ratio
- Capitalization Ratio
- Interest Coverage Ratio
- Times Interest Earned Ratio
- Debt Service Coverage Ratio (DSCR)
- Financial Leverage Ratio
- Net Debt Formula
- Leverage Ratios
- Operating Leverage vs Financial Leverage
- Current Yield
- Debt Yield Ratio
Overhead Ratio Formula
The overhead formula is specifically useful for banks. Here we take the operating expenses into account and compare the expenses with the total income that can’t be attributed directly to the production of goods and services.
Here’s the overhead ratio formula –
Alternatively, many argue that overhead can be expressed as the proportion between operating expenses and the revenue; however, this proportion is called the operating expense ratio, not an overhead ratio.
Overhead Ratio Example
Let’s take a simple example to calculate overheads.
HoHey Restaurant has the following information –
- Operating Expenses – $23,000
- Operating Income – $115,000
- Taxable Net Interest Income – $46,000
Find out this ratio of HoHey Restaurant.
We know both the numerator and the denominator of this ratio.
- Operating expenses are $23,000.
The denominator would be the sum of operating income and taxable net interest income.
Using the overhead formula, we get –
- Overhead Formula = Operating Expenses / (Operating Income + Taxable Net Interest Income)
- = $23,000 / ($115,000 + $46,000)
- = $23,000 / $161,000 = 14.29%.
To interpret this ratio of HoHey Restaurant, we need to look at the ratios of other restaurants serving the similar food and providing the similar services.
Explanation of Overhead Formula
In this ratio, we have to consider two components.
The first component is the operating expenses. Operating expenses are the day to day expenses that the company needs to run the business. For example, utilities, machinery maintenance, office rent, professional fees, insurance etc. are operating expenses.
The second component of overhead Ratio is a tricky one.
- We will take the operating income and also the taxable net interest income.
- When we deduct the operating expenses from gross profit, we get the operating income.
- To get the net interest income, we need to look at the difference between how much a company receives interest and how much it pays off.
- Net interest income is a common measure for banks. But we can calculate the same for companies also.
- We will add the operating income and the taxable net interest income to get the denominator.
Use of Overhead Formula
Overhead Formula is a significant measure for any company; because if it is lower, better would be the performance of the company. On the other hand, if it is higher, the company isn’t utilizing its resource prudently.
Every company should try to lower the ratio as much as it can.
There are two portions of the operating expenses that a company can look at.
- The first component of the operating expenses is expenses that can’t be curbed at all. In this case, the company should try to reduce this component as much as they can.
- The second component of the operating expenses can be removed completely. The company should take steps to pare down this second component to reduce this ratio.
However, reducing the ratio shouldn’t affect the company’s performance. Too much reduction in operating expenses may affect the company negatively. The company should try to maintain a balance and reduce only that much which doesn’t reduce the efficiency of the company.
Overhead Ratio Calculator
You can use the following Overhead Ratio Calculator
|Overhead Ratio Formula =|| |
Overhead 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 three inputs of Operating Expenses, Operating Income, and Taxable Net Interest Income.
You can easily calculate the ratio in the template provided.
You can download this ratio template here – Overhead Ratio Excel Template
This has been a guide to Overhead Ratio formula, its uses along with practical examples. Here we also provide you with Overhead Ratio Calculator with downloadable excel template. Learn more from the below articles –