Operating Profit Formula

Publication Date :

Blog Author :

Download FREE Operating Profit Formula Excel Template and Follow Along!
Operating Profit Formula Excel Template

Table Of Contents

arrow

What is the Operating Profit Formula?

The operating profit formula measures the company's efficiency in running its business by calculating the operating profit. Operating profit is the profit generated from the core business after deducting all the related operating expenses, depreciation, and amortization from its revenue before deducting interest and taxes. Also, operating profit does not include profits earned by the company from its ancillary investments.

The term "operating profit formula" refers to the formula used to calculate the operating profit earned by the company. The formula for calculation of the operating profit is mathematically represented as below:

Operating Profit Formula = Revenue from Core Operations – Total Cost of Goods Sold Value - Operating Expenses - Depreciation Expenses – Amortization Expenses

Here,

  • Revenue from core operations is the total value of the amount earned by the company from the sale of the goods or provision of the services with respect to the core business operations.
  • Cost of the Goods Sold is the total cost incurred by the company for creating the goods or services. It includes the cost of material, labor, and overheads.
  • Operating Expenses are the expenses incurred by the company with respect to its normal business operation, excluding the cost of goods sold.
  • Depreciation is the reduction value of an asset due to normal nature wear and tear.
  • Amortization is the amount of reduction in the value of the loan or of the intangible assets during the period.
Operating Profit Formula
You are free to use this image on your website, templates, etc.. Please provide us with an attribution link.

Explanation of Operating Profit Formula

The equation for operating profit can be derived by using the following steps:

Step 1: Firstly, determine the revenue earned by the company from the core business operations. For this, all the amount earned by the company from the sale of the goods or provision of the services concerning the core business operations is added together.

Step 2: After that, the cost of the goods sold by the company during that period is calculated by adding the total cost incurred on the material, labor, and the overheads of the company altogether.

Step 3: Calculate the total operating expenses incurred by the company during the year. Also, determine the total depreciation and amortization expense of the period.

Step 4: Finally, Operating profit will be calculated by deducting values in steps 2 and 3 from step 1 values. The equation for operating profit is expressed, as shown below.

Operating Profit = Revenue from Core Operations - Cost of Goods Sold - Operating Expenses - Depreciation - Amortization Expenses

Operating Profit Margin Explained in Video

 

Examples of Operating Profit Formula (with Excel Template)

To understand them better, let's see some simple to advanced examples of operating profit equations.

Operating Profit Formula Example #1

Let us take the example of the company having a total revenue earned during the year of $5,000,000. The cost of the goods sold and operating expenses during the year are $ 2,000,000 and 1,000,000, respectively, and the depreciation on assets is $50,000. What is the operating profit of the company?

Solution:

Use the given data for the calculation of operating profit.

Operating Profit Formula Example 1

Calculation of Operating profit can be done as follows:

Operating Profit Formula Example 1.1.0

Operating Profit = $5,000,000 - $2,000,000 - $1,000,000 - $500,000

Operating Profit will be -

Operating Profit Formula Example 1.2

Operating Profit = $1,500,000

Therefore, the operating profit of the company for the year is $1,500,000.

Operating Profit Formula Example #2

Let us take another example of a company which is having the following information for the year 2018:

  • Revenues from core business operations: $81,000,000
  • Revenues from non-core business operations: $5,000,000
  • Cost of goods sold: $35,000,000
  • Selling, general and the administrative expenses: $10,000,000
  • Depreciation expenses for the period: $1,000,000
  • Amortization expenses for the period: $500,000
  • Interest Expenses: $1,000,000
  • Taxes expenses for the year: $3,000,000

From the information provided, what is the total amount of operating profit of the company for 2018?

Solution:

Use the given data for the calculation of operating profit.

Example 2

Here,

  • Revenue from core operations is $81,000,000, and the revenue from the non-core operation will not be taken as they are not considered while calculating the operating profit.
  • Selling, general, and the administrative expenses will be part of the operating expenses of the company and hence will be considered while calculating the operating profit.
  • Lastly, Operating profit is calculated before deducting the expenses related to interest and taxes. So, they will not be considered while calculating the operating profit.
Operating Profit Formula Example 2.1

Operating Profit = $81,000,000 - $35,000,000 - $10,000,000 - $1,000,000 – $500,000

Operating Profit will be -

Example 2.2

Operating Profit = $34,500,000

Therefore, the operating profit of the company for the year is $34,500,000.

Operating Profit Formula Example #3

Let us take another example of a company AB. The management of the company wants to know the operating profit earned by the company for a year having the following information:

  • Revenues from core business operations: $1,000,000
  • Cost of direct material: $300,000
  • Cost of direct Labour: $200,000
  • Cost of direct material: $100,000
  • Operating expenses: $100,000
  • Depreciation expenses for the period: $50,000
  • Amortization expenses for the period: $10,000

From the information provided, what is the total amount of operating profit of the company for the year?

Solution:

Use the given data for the calculation of operating profit.

Operating Profit Formula Example 3

Here,

  • The cost of goods sold will be calculated by adding the cost of direct material, cost of direct labor, and cost of direct overhead.

Calculation of Cost of the Goods Sold will be:

Cost of the Goods Sold = Cost of Direct Material + Cost of Direct Labour + Cost of Direct Overhead
Example 3.1

Cost of the Goods Sold = $300,000 + $200,000 + $100,000

Cost of the Goods Sold = $600,000

Now,

Calculation of operating profit can be done as follows:

Operating Profit Formula Example 3.2

Operating Profit = $1,000,000 - $600,000 - $100,000 - $50,000 - $10,000

Operating Profit will be -

Example 3.3

Operating Profit = $240,000

Therefore, the operating profit of the company for the year is $240,000.

Operating Profit Formula Calculator

You can use this operating profit formula calculator.

Relevance and Uses

The operating profit equation shows light on the success of the company. This is because it measures how efficient the company is in controlling its costs and earning profits. Also, it is one of the simple as well as the standard ratio that tells about the company's performance from one period to another as well as concerning the other companies thereby enabling the comparative analysis.