Break Even Analysis Formula

Break Even Analysis Formula (Table of Contents)

• Break Even Analysis Formula
• Examples of Break Even Analysis Formula (With Excel Template)
• Break Even Analysis Formula Calculator

Break Even Analysis Formula

A Break Even point is a point where the total cost of product or service is equal to total revenue. It calculates the margin of safety by comparing the value of revenue with covered fixed and variable cost associated with sales. A break-even point is a saturation point where company neither makes profit nor loss. So, it is relation between variable cost, fixed cost, and revenue. Break Even points in units is fixed cost upon contribution margin per unit. It can be expressed as:-

Examples of Break Even Analysis Formula (With Excel Template)

Let’s take an example to understand the calculation of Break Even Analysis formula in a better manner.

Break Even Analysis Formula- Example #1

A fixed cost of the product is $1,000 and contribution margin per unit is $100. Calculate Break Even points in unit.

Break Even Point in Units is calculated using the formula given below

Break Even Point in Units = Fixed Cost / Contribution Margin per Unit

Put the value in the formula.

• Break Even Point in Units =$1000 / $100
• Break Even Point in Units = 10

The Break Even point is 10 units.

Contribution Margin per Unit

Contribution margin of a product is the difference between selling price minus variable cost and formula of contribution margin per units can be written as:-

Contribution Margin per Unit = Sales Price per Unit – Variable Cost per Unit

So, the formula of Break Even points in a unit can be written as:-

Break Even Analysis Formula- Example #2

A product has a fixed cost of $50,000, variable cost per unit of product is $200 and selling price per unit $400. Now let us calculate Break Even point.

Break Even Point in Units is calculated using the formula given below

Break Even Point in Units = Fixed Cost / Sales Price per Unit – Variable Cost per Unit

Put a value in the formula.

• Break Even Point in Units = $50,000 / ($400 – $200)
• Break Even Point in Units = $50,000 / $200
• Break Even Point in Units = $250

The Break Even point is 250 units.

Break Even Points in Dollars

The Break Even formula in sales in dollars is calculated by sales price per unit into Break Even point in units. It gives the total amount of sales in order to achieve zero loss or zero profit. It helps to calculate the number of units sold in order to achieve profitability which one gets after Break Even point.

Now, let us take an example to understand it better.

Break Even Analysis Formula- Example #3

A Break Even point of a product is 500 and sales price per unit is $100, now let us find Break Even point in dollars.

Break Even Point in dollars is calculated using the formula given below

Break Even Point in Dollars = Sales Price per Unit * Break Even points in Units.

Put a value in the formula.

• Break Even Point in Dollars = 500 * $100
• Break Even point in Dollars = $50,000

So, Break Even point in dollars is $50,000. 

Number of Units to Produce the Desired Profit –

This is an analysis of Break Even point. It helps to find the number of units one needs to sells in order to produce profit without taking the fixed cost into consideration. Number of units to produce the desired profit is the sum of Break Even point of unit and desired profit in dollars upon contribution margin per unit.

Let us see an example to understand it better.

Break Even Analysis Formula- Example #4

The desired profit against sales of the product is $100,000, contribution margin per unit of product is $200, and the value of Break Even point unit is 2,500. Now, let us calculate no of a unit to produce the desired profit.

No. of Units to Produce the Desire Profit is calculated using the formula given below

Number of Units to Produce the Desire Profit = (Desired Profit in Dollars / Contribution Margin Per Unit )+ Break Even points of Unit 

Put a value in the above formula.

• No. of Units to Produce the Desire Profit = (100,000 / 200) + 2500
• No. of Units to Produce the Desire Profit = 3,000

So, 3000 units are required to produce to get the desired profit.

Break Even Chart

Break Even point is a point where the total cost of product or service is equal to total revenue. The difference between total revenue and the total cost is profit or loss. Now let see below graph. Through this one can compute profit or loss of the company.

Now, let us take another example.

Break Even Analysis Formula- Example #5

A factory wants to study Break Even point and want to generate a profit of $500,000, the total fixed cost of a product is $100,000, variable cost per unit $200, sales price per unit is $300.

First, let us calculate Break Even points

Break Even Point in Units is calculated using the formula given below

Break Even Point in Units = Fixed Cost / Sales Price per Unit – Variable Cost per Unit

• Break Even point in Units = 100,000 / (300 – 200)
• Break Even Point in Units = 100,000 / 100
• Break Even Points in Units = $1000

Then, calculate Break Even Point in Dollars

Break Even Point in dollars is calculated using the formula given below

Break Even Point in Dollars = Sales Price per Unit * Break Even points in Units.

• Break Even point in Dollars = 300 * 1000
• Break Even point in Dollars = $300,000

Then, calculate Number of Units to Produce Desired Profit

No. of Units to Produce the Desire Profit is calculated using the formula given below

Number of Units to Produce the Desire Profit = (Desired Profit in Dollars / Sales Price per Unit – Variable Cost per Unit )+ Break Even points of Unit 

• No. of Units to Produce the Desire Profit = [500,000 / (300 -200) ]+ 1,000
• No. of Units to Produce the Desire Profit = 6,000

You can download this Break Even Analysis Template here – Break Even Analysis Formula Excel Template

Relevance and Uses

There are multiple uses of Break Even Analysis formula they are as follows:-

• It helps to decide to a price of a product.
• Break Even points helps to take a crucial financial decision in business.
• Break Even Analysis formula computes production unit for a profit.
• Helps to take production and production chain related decisions.

Break Even Analysis Formula Calculator

You can use the following Break Even Analysis Calculator.

Conclusion – Break Even Analysis formula

Break Even Analysis formula helps to increase profitability by reducing the number of unit of product which needs to be produced using Beak Even point formula. It helps to set a target for sales and to generate revenue. But, these models reflect non- cash expenses like depreciation to get exact Break Even point non-cash expenses needs to be subtracted.

Recommended Articles

This has been a guide to Break Even Analysis formula. Here we discuss How to Calculate Break Even Analysis along with practical examples. We also provide Break Even Analysis Calculator with downloadable excel template. You may also look at the following articles to learn more –

1. Calculator for Markup Price Formula
2. How to Calculate Cost of Equity?
3. Average Collection Period Formula
4. Examples of Free Cash Flow