WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Operating Income Formula

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

Formula to Calculate Operating Income

Operating income Formula (also referred to as EBIT formula) is a profitability formula that helps in the calculation of a company’s profits generated from core operations. The formula is a decision tool for an investor to calculate how much gross income will eventually result in profit for a company. The operating income can be calculated by deducting the cost of goods sold and operating expenses from total revenue.

Mathematically, operating income can be calculated using two methods

Method 1

Operating Income Formula = Total Revenue – Cost of Goods Sold – Operating Expenses

Method 2

Alternatively, the Formula for operating income can also be calculated by adding back interest expense and taxes to the net income (adjusted for non-operating income and expense), which is mathematically represented as,

Operating Income = Net Income + Interest Expense + Taxes
Operating Income Formula

Steps to Calculate Operating Income

Method 1

For the first method can be calculated in the following four simple steps:

Step 1: Firstly, the total revenue has to be noted from the profit and loss account. For example, in a manufacturing company, the total revenue will be computed by multiplying the number of units produced with the average price per unit.

Total Revenue = Number of Units Produced * Average Price Per Unit

Step 2: Now, the cost of goods sold is also available in the profit and loss account. It is calculated by adding the raw material purchase during the accounting period to the beginning inventory and then deducting the closing inventory.

Cost of Goods Sold = Beginning inventory + Purchase of raw material – Closing inventory

Step 3: Now, the operating expenses are also gathered from the profit and loss account. It includes various direct and indirect costs like labor cost, depreciation, administrative expenses, etc.

Step 4: Finally, the EBIT is arrived at by deducting the values derived in Step 2 and Step 3 from the value in Step 1, as shown below.

EBIT = Total revenue – Cost of goods sold – Operating expenses

Method 2

On the other hand, the following four steps help in the calculation of the Operating Income by using the alternate method:

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

Step 1: Firstly, the net income has to be captured, which is easily available in the profit and loss account as a line item. Make sure that non-operating income (deducted) and expense (added back) have been adjusted as these are not part of the core operation.

Step 2: Now, the interest expense is also available in the profit and loss account. It is the product of the effective rate of interest and outstanding borrowing across the year.

Step 3: Now, the taxes are also collected from the profit and loss account.

Step 4: Finally, the EBIT is derived by adding back the values derived in Step 2 and Step 3 to the value in Step 1, as shown below.

EBIT = Net income + Interest expense + Taxes

Calculation Examples of Operating Income

Let’s see some simple to advanced examples of EBIT to understand it better.

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

Example #1

Let us consider an example to calculate EBIT for a company called ABC Limited, which is in the business of manufacturing customized roller skates for both professional and amateur skaters. At the end of the financial year, the company has generated $150,000 in total revenue along with the following expenses.

In the below-given Screenshot is the data used for the Calculation of Operating Income

operating income formula example1.1

For the calculation of Operating Income, we will use the following values first.

Cost of Goods Sold

operating income formula example1.2

Net Income

operating income formula example1.3

Therefore, Net income = $41,000

ABC Limited’s net income at the end of the financial year stood at $41,000.

Now, Using the first method to calculate Operating Income is as follows –

operating income formula example1.4

i.e. EBIT = $150,000 – $70,000 – $25,000

EBIT will be –

operating income formula example1.5

So, EBIT = $55,000

Now, we will do the calculation of Operating Income using the second method mentioned above.

operating income formula example1.6

i.e. EBIT = $41,000 + $10,000 + $4,000

EBIT will be –

operating income formula example1.7

So, EBIT = $55,000

Example #2 (Apple Inc)

Let us take the real-life example of Apple Inc.’s annual report as on September 29, 2018. The following information is available:

operating income formula example2.1

The calculation of Operating Income will be as follows –

operating income formula example2.2

Therefore,

  • EBIT (in Millions) = Net income + Interest expense + Tax – Non-Oper. Income
  • EBIT = $59,531 + $3,240 + $13,372

Operating Income will be –

operating income formula example2.3

  • EBIT = $70,898

Operating Income Calculator

You can use the following EBIT Calculator.

Total Revenue
Cost of Goods Sold
Operating Expenses
Operating Income Formula =
 

Operating Income Formula = Total Revenue - Cost of Goods Sold - Operating Expenses
0 - 0 - 0 = 0

 

Relevance and Use

EBIT is basically a profitability metric that helps to assess how a company is performing which is calculated by measuring profit before payment of interest to lenders or creditors and taxes to the government. This is a profitability calculation which is measured in terms of dollars and not in percentages like most other financial terms.

However, there remains a limitation of the operating income formula that it is particularly useful when comparing similar companies in the same industry. Since the EBIT formula only measures profit in terms of dollar amount, investors and other financial users usually find it difficult to use this metric to compare differently sized (small & medium enterprise, mid-corporate and large corporate) companies across the industry.

Calculate Operating Income in Excel (with template)

Now let us take the Apple Inc.’s published financial statement example for the last three accounting periods. Based on publicly available financial information the EBIT (in dollar terms) of Apple Inc. can be calculated for the accounting years 2016 to 2018.

In below-given screenshot is the data for the calculation of EBIT using both the formula mentioned above.

operating income formula example3.1

Calculation of Operating Income using the first formula.

EBIT = Total revenue – Cost of goods sold – Operating expenses

operating income formula example3.2

So EBIT for Sep 29, 2018, will be –

operating income formula example3.3

Similarly, we will calculate the EBIT for  Sep 30, 2017, and  Sep 24, 2016

Calculation of Operating Income using the Second formula.

EBIT = Net income + Interest expense + Taxes

operating income formula example3.4

So the Income for Sep 29, 2018, will be –

operating income formula example3.5

Similarly, we will calculate the EBIT for  Sep 30, 2017, and  Sep 24, 2016

From the above table, it can be seen that the EBIT of Apple Inc. in dollar terms has been growing during the period which is a positive sign for the company.

Recommended Articles

This has been a guide to Operating Income Formula. Here we discuss how to calculate Operating Income using practical examples along with downloadable excel templates. You may learn more about Financial Analysis from the following articles –

  • Calculate Operating Cash Flow
  • LTM EBITDA
  • EBIT vs Net Income
0 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

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
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 Income Formula Excel Template

Coursera IPO Financial Model & Valuation Free Download