What is Operating Profit Formula?

Operating profit formula measures the efficiency of the company to run its business by calculating the operating profit of the company. Operating profit is the profit generated from the core business after deducting all the related operating expenses, depreciation and amortization from its revenue but 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 which is used as the measure for calculation 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 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.

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 with respect to 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 amount of 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 value arrived 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

Examples of Operating Profit Formula (with Excel Template)

Let’s see some simple to advanced examples of operating profit equation to understand it better.

Popular Course in this category

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

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

Operating Profit Formula Example #1

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

Solution:

Use the given data for the calculation of operating profit.

Calculation of Operating profit can be done as follows:

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

Operating Profit will be –

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.

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 be not be considered while calculating the operating profit.

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

Operating Profit will be –

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.

Here,

Cost of goods sold will be calculated by adding the cost of direct material, cost of direct labour 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

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 = $1,000,000 – $600,000 – $100,000 – $50,000 – $10,000

Operating Profit will be –

Operating Profit = $240,000

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