Cost-Volume-Profit (Breakeven) Analysis

A template to perform cost-volume-profit (CVP, or breakeven) analysis

by Andrei Okhlopkov
Associate Director, Private EquityFollow 265

16 reviews1,141 views|Start the discussion!|Bookmark download for free

Description
Cost-Volume-Profit analysis (also known as breakeven analysis) is one of the fundamental types of analysis which deals with product profitability. It classifies the costs into variable (which change in line with volumes produced) and fixed (which do not change with volumes produced). The purpose of a business is to cover both types of costs and to make a profit.

Assuming the selling price is above the variable cost of the product, this product generates a contribution margin equal to the selling price less variable cost. We need to sell a sufficient volume of products so that the total contribution margin covers fixed costs. The point at which this is achieved is called a breakeven point. This point is measured in terms of volumes.

If we sell above breakeven we are making a gross profit. The difference between the current volumes/revenues and breakeven volumes revenues is called margin of safety and is measured in terms of volumes and revenues. It shows the “buffer” which we have to stay profitable.

A traditional breakeven analysis has a number of limitations.

Firstly, it assumes all costs can be classified into fixed and variable, while in reality a fixed cost (e.g. depreciation) will increase if the volumes go above the current production capacity and additional equipment is required. Economists argue that in the long run all costs tend to become variable.

Changes in volumes are often driven by changes in prices. The “classic” analysis ignores this, assuming the prices remain constant.

If a company manufactures more than one product, changes in mixes might affect the contribution margin and the whole analysis.

This Best Practice includes
1 Excel File, 1 pdf file