While every company needs to know the answer to this question, the answer is even more vital for start-ups that do not have much margin for error. This is because the revenues will exactly equal the expenses at the breakeven point. In other words, the company does not incur a loss nor does it realize a profit.

Breakeven analysis or CVP (cost-volume-profit) analysis is the type of analysis that answers these important questions. It is an accounting tool to understand the relationship between revenues, variable costs, and fixed costs. The purpose of this article is to illustrate how you can perform a breakeven analysis and calculate the breakeven point of your business in different scenarios.

What activity level is required to break even or realize a target income level?

The financial results of a business are heavily dependent on the total number of sales. In the short run, a company can estimate fairly accurately the sales price per unit, the variable costs per unit, and the fixed costs. However, the demand for the company’s goods and/or services is unknown. As a result, the company does not know in advance whether it will be profitable or not. CVP analysis allows you to determine the quantity, irrespective of whether it is a good or service, that needs to be sold to avoid a loss.

Breakeven analysis: The basics

The basic version of the break even formula is a 2-step approach to calculate the breakeven point. The first step is to determine the contribution margin and the second step is to calculate the breakeven point. 

Throughout the rest of this article, we will make use of the below case study. A prerequisite is that you split your expenses between fixed expenses and variable expenses.

Smartphone Cover Inc., a fictitious company, is a manufacturer of smartphone covers. The company is a single product company. The following assumptions are made:

CVP basic assumptions

Management of Smartphone Cover Inc. would like to know its breakeven point. 

Step 1: Calculate the contribution margin

First, the unit contribution margin (UCM), and the contribution margin ratio (CMR) need to be calculated. The contribution margin per unit is 5.0 $ and the contribution margin ratio is 40%. 

Unit Contribution Margin (UCM) = Unit Sales Price (USP) – Unit Variable Costs (UVC)

Contribution Margin Ratio (CMR) = Unit Contribution Margin (UCM) / Unit Sales Price (USP)

Calculation unit contribution margin and contribution margin ratio

Step 2: Calculate the breakeven point

Subsequently, the breakeven point for Smartphone Cover Inc can be calculated. The breakeven point is 50,000 units or 625,000 $. In both cases, the numerator is the fixed costs of 250,000 $. To calculate the breakeven point in units, you need to divide the fixed costs by the Unit Contribution Margin. If you divide the fixed costs by the Contribution Margin Ratio, you obtain the breakeven point in dollars.

Breakeven point in units = Fixed Costs (FC) / Unit Contribution Margin (UCM)

Breakeven point in dollars = Fixed Costs (FC) / Contribution Margin Ratio (CMR)

Beyond the breakeven point, the company’s operating income is increased by the unit contribution margin for every additional unit sold. This is explained by the fact that all the variable expenses and fixed costs are covered at the breakeven point. So, Smartphone Cover Inc’s operating profit will increase by the unit contribution margin of 5.0 $ for every additional unit sold beyond 50,000 units.

Breakeven analysis: The break even formula expanded

The basic break even formula can be tweaked in several ways. In the next sections, you will learn how to:

  1. calculate the number of units that you need to sell to achieve a target operating income level
  2. incorporate a safety margin
  3. calculate the contribution margin for a multiproduct company

Key assumptions & limitations

Before we can expand on the break even formula, it is important to highlight the underlying assumptions and limitations of breakeven analysis. CVP analysis is simple to apply and provides powerful insights, but it relies on some major simplifications.

  1. Costs and revenues behave linearly over the relevant range of activity and period. The results can become unreliable beyond this relevant range.
    • ‘Relevant range of activity’ means that the business has experience in the field and can therefore make accurate estimates.
    • ‘Relevant range of period’: The classification of fixed and variable expenses is constant over the relevant period. Over the long-term all costs are variable.
  2. Costs are split between variable expenses and fixed expenses. In practice, some costs might be semi-fixed, such as a lease agreement that has a fixed component and a variable component that is dependent on the sales amount. Fixed expenses are also variable in the long run.
  3. Volume is the only variable that has an impact on revenues and expenses. All other variables, such as selling price per unit, unit variable costs, sales mix, and fixed costs are constant. In CVP analysis economies of scale, volume discounts, productivity and efficiency gains, etc. are not considered.
    • Total variable costs change with the level of output, but unit variable cost remains constant.
    • Fixed costs are constant, but unit fixed costs decrease (increase) when output increases (decreases).
  4. Inventory levels are constant. The number of units produced is equal to the number of units sold.

Target Operating Income and Net Income

If Smartphone Cover Inc. wants to achieve a specific target profit (pre-tax), for example, 150,000 $, they can simply include a target operating income in the numerator. In other words, you need to treat the target operating income as an additional fixed cost.

Target Operating Income and Net Income Assumption

To realize a target operating income of 150,000, the company must sell 80,000 units or 1,000,000 $ (12.5 $ * 80,000 units). 80,000 units * 5.0 $ unit contribution margin is equal to 400,000 $. If you subtract 250,000 $ fixed costs from this amount, you will also arrive at 150,000 $ operating profit.

Target income calculation in units and in dollars

In our example, the target operating income is a pretax amount. The target income might also be defined as an after-tax amount. Beware that you need to convert target net income (an after-tax amount) to target net operating income (pretax amount). Target Net income can easily be converted into target operating income by dividing target net income by the factor (1 – tax rate). For example, let us assume that Smartphone Cover Inc’s tax rate is 35%. Target net income of 97,500 $ (97,500 / 0.65) is equal to target operating income of 150,000 $.

Net Income / (1 – 0,35) = Target operating income

Safety Margin

The safety margin is the excess of budgeted sales over breakeven sales. It exhibits how much sales can decrease before the company reaches its breakeven point or worse breaches it! Thus, the safety margin provides a cushion against operating losses. The safety margin is calculated as follows:

Safety Margin (in units) = Budgeted Sales – Breakeven Sales

Safety Margin (in $) = (Budgeted Sales – Breakeven Sales) * Unit Selling Price (USP)

Safety Margin (in %) = Safety Margin / Budgeted sales

For example, Smartphone Cover Inc. might have budgeted sales of 55,000 units while their breakeven sales were 50,000 units. Total revenues at budgeted sales level amount to 687,500 $. The margin of safety is 5,000 units (55,000 – 50,000). The safety margin is 9.1% (5,000 units divided by 55,000 units) and the safety margin in $ is 5,000 units * 12.50 $ per unit or 62,500 $. You can also calculate the safety margin in % by dividing 62,500 $ / 687,500 $.

Safety margin calculation

Sensitivity tables

Sensitivity analysis allows you to quickly re-run your calculations under various circumstances. This method allows you to verify the impact of changes in input variables (changes in sales price per unit, unit variable costs, fixed costs, or sales mix) on the dependent variable. The dependent variable is usually the breakeven point, target profit, or net profit.

If you do not know how to create a data table in Excel, please check the following link. This guide will help you troubleshoot setting up your data tables.

In a single product company, the breakeven point in units is very dependent on a correct estimation of your selling price per unit and the unit variable cost. However, your actual unit selling price may deviates from the anticipated unit selling price, for example, because of volume discounts or competitive pressure. The actual unit variable cost might also differ from the expected unit variable cost because of changes in the commodity prices, freight rates, FX rates, etc. To model this uncertainty, we can make use of a data table to obtain an indication of the number of units that need to be sold in case these two variables change.

Breakeven_point_sensitivity_analysis

As can be seen in the table, the breakeven point will decrease to 35,714 units from 50,000 units in case the Unit Contribution Margin (UCM) would increase to 13.5 $ from 12.5 $ and the unit variable cost would decrease to 6.5 $ from 7.5 $. If the unit selling price would decrease to 12 $ from 12.5 $ and the unit variable cost would increase to 8.0 $ from 7.5 $, the breakeven point would increase by 12,500 units to 62,500 units from 50,000 units.

Another input variable that could have been sensitized in our breakeven analysis is the fixed expenses. However, this seems to be a poor choice considering that fixed expenses are fairly predictable, and they are fixed in the short term.

We also sensitized net income. The two input variables we sensitized are unit contribution margin and budgeted sales. Through the unit contribution margin, we can capture both changes in the unit selling price and the unit variable costs. Units sold are the major driver of net income in CVP-calculations. As can be expected, Smartphone Cover Inc.’s net income would deteriorate in case of declining unit contribution margins or a decline in units sold.

Net income sensitivity analyss

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories
Subscribe

Don’t miss new content and join my monthly newsletter. It is spam-free and you can unsubscribe at any time.