EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Operating Expense Formula
 

Operating Expense Formula

Madhuri Thakur
Article byMadhuri Thakur

Operating Expense Formula

Operating Expense Formula (Table of Contents)
  • Formula
  • Examples
  • Calculator

What is the Operating Expense Formula?

The term “operating expense” refers to all the running costs incurred during the normal course of the business in a given period of time, which is not directly assignable to the production process.

In other words, operating expense is the aggregate of all the expenses other than the cost of goods sold (COGS), and it primarily includes rental expenses, marketing costs, payroll tools and expenses, etc. Thus, it is also known as an operational expenditure or “Opex.”

 

 

The formula for the operating expense can be simply expressed as a summation of various selling, general, and administrative (SG&A) expenses like office staff salaries, sales commissions, promotional & advertising costs, rental expenses, utilities, etc. The mathematical representation of it is:

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Operating Expense = Salaries + Sales Commissions + Promotional & Advertising Cost + Rental Expense + Utilities

On the other hand, the formula for operating expenses can also be expressed as revenue minus operating income (EBIT) minus COGS. The mathematical representation of it is:

Operating Expense = Revenue – Operating Income – COGS

Examples of Operating Expense Formula (With Excel Template)

Let’s take an example to understand the calculation of Operating Expense in a better manner.

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

Example #1

Let us take the example of a manufacturing company to illustrate the computation of operating expenses. According to the latest annual report, the following information is available from the income statement of the company:

Example of a Manufacturing Company-1.1

Solution:

Calculate the operating expense of the company based on the above information.

The formula to calculate Operating Expense is as below:

Operating Expense = Sales Commission + Advertising Expense + Salaries + Depreciation + Rent + Utilities

Operating Expense Formula-1.2

  • Operating Expense = $1.20 million + $2.00 million + $1.00 million + $0.75 million + $0.50 million + $0.30 million
  • Operating Expense = $5.75 million

Therefore, the company’s operating expense during the given period was $5.75 million.

Example #2

Let us take the example of a company to illustrate the computation of operating expenses using the alternate approach. The following financial information is available about the company:

Operating Expense Formula-2.1

Solution:

The formula to calculate COGS is as below:

COGS = Direct Labor + Raw Material Cost + Manufacturing Overhead

COGS-2.2

  • COGS = $5.25 million + $9.75 million + $1.25 million
  • COGS = $16.25 million

The formula to calculate Operating Income is as below:

Operating Income (EBIT) = Net Income + Interest Expense + Taxes

Operating Expense Formula-2.3

  • Operating Income = $6.00 million + $2.00 million + $2.50 million
  • Operating Income = $10.50 million

The formula to calculate Operating Expense is as below:

Operating Expense = Revenue – Operating Income – COGS

Operating Expense Formula-2.4

  • Operating Expense = $40.00 million – $10.50 million – $16.25 million
  • Operating Expense = $13.25 million

Therefore, the company’s operating expense during the given period was $13.25 million.

Example #3

Let us take the example of Apple Inc. to illustrate the computation of operating expenses using both approaches. According to an income statement for 2018, the following information is available:

Example of Apple Inc-3.1

Solution:

First Approach

The formula to calculate Operating Expense is as below:

Operating Expense = Research and Development Expense + Selling, General, and Administrative Expense

Operating Expense Formula-3.2

  • Operating Expense = $14,236 million + $16,705 million
  • Operating Expense = $30,941 million

Alternate Approach

The formula to calculate Operating Expense is as below:

Operating Expense = Revenue – Operating Income – Cost of Sales

Operating Expense Formula-3.3

  • Operating Expense = $265,595 million – $70,898 million – $163,756 million
  • Operating Expense = $30,941 million

Therefore, Apple Inc.’s operating expense for the year 2018 was $30,941 million.

Operating Expense Formula-3.4

Source Link: Apple Inc. Balance Sheet

Explanation

The formula for the operating expense can be derived by using the following steps:

Step 1: Firstly, determine the COGS of the subject company during the given period. COGS is the aggregate cost of production that is directly assignable to the production process, which primarily includes raw material cost, direct labor cost, and manufacturing overhead.

COGS = Raw Material Cost + Direct Labor Cost + Manufacturing Overhead

Step 2: Next, determine the company’s operating income for the period from the income statement.

Step 3: Next, determine the revenue achieved by the company for the period. It is usually the first line item in the income statement.

Step 4: Finally, the formula for the operating expenses can be derived by deducting COGS (step 1) and operating income (step 2) from its revenue (step 3) as shown below.

Operating Expense = Revenue – Operating Income – COGS

Relevance and Use of Operating Expense Formula

It is important to understand the concept of operating expenses because it is very crucial in the assessment of the overall profitability of a company. Given that these expenses are periodic in nature and not directly related to the production level, companies usually intend to control these expenses to improve their profitability. The management team’s competency and ability to take the initiative can be reflected in their performance assessment through the utilization of operating expenses for decision-making, which enables the construction of competitive advantage.

Operating Expense Formula Calculator

You can use the following Operating Expense Formula Calculator

Salaries
Sales Commissions
Promotional & Advertising Cost
Rental Expense
Utilities
Operating Expense
 

Operating Expense = Salaries + Sales Commissions + Promotional & Advertising Cost + Rental Expense + Utilities
0 + 0 + 0 + 0 + 0 = 0

Recommended Articles

This is a guide to the Operating Expense Formula. Here we discuss how to calculate Operating Expenses along with practical examples. We also provide an Operating Expense calculator with a downloadable Excel template. You may also look at the following articles to learn more –

  1. Formula for Depreciation
  2. How to Calculate Net Operating Income
  3. Example of Bank Efficiency Ratio
  4. Calculation for Operating Ratio
  5. Difference between Trial Balance vs Balance Sheet

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Operating Expense Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Operating Expense Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW