Break-even in Accounting - Cost Volume Profit Analysis

Posted on:  07/15/2019
Break-even in Accounting - Cost Volume Profit Analysis

The break-even point is when a company has Net Income of zero ($0.00). The revenues generated covered the expenses. There are two types of costs:

  • fixed
  • variable

To find the break-even point, you need to know the Contribution Margin. The contribution margin can be shown as either a percentage or per unit number.

Calculate the Break-even point

The breakeven point is equal to the total fixed costs divided by the contribution margin per product. The contribution margin is the difference between the unit price and variable costs. 

Variable Cost

Variable costs vary based on the amount of output. If you produce more products - going from 80 units to 90 units - variable costs go up. If you produce fewer products, variable costs go down.

Examples of variable cost:

  1. Direct material
  2. Direct labor
  3. Sales commissions
  4. Credit card fees
  5. Freight out
Breakeven point in units - Excel

Breakeven point in units

Other Excel articles

Fixed Expenses

Fixed costs stay the same regardless of the amount of output. Producing more or less does not affect fixed costs.

Examples of fixed cost:

  1. Supervisors' salaries
  2. Rent
  3. Insurance
  4. Utilities
  5. Depreciation

Calculate the break-even based on contribution margin per unit.

Divide the fixed cost by contribution margin per unit to get the number of units to break-even. In the example below, our contribution margin is $25 per unit (52-27), and we have fixed expenses of $15,000. Divide 15,000 by 25 and to get 600 units. Below 600 units is a net loss. Above 600 units is a net profit. Every unit produced over 600 generates $25 in net profit.

Breakeven in Excel - net income is zero

Breakeven in Excel - net income is zero

YouTube video on Break-even in Excel with a chart

Latest Blog Post on Excel Intermediate

Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories