# Fillable Printable Break-Even Analysis Sample Template

# Fillable Printable Break-Even Analysis Sample Template

## Break-Even Analysis Sample Template

1

Management, Richard Hodgetts & Donald Kuratko, Second Edition, 1986.

ADC Info #3

Break-Even Analysis

September 1998

Rob Holland

Assistant Extension Specialist

Agricultural Development Center

One of the most common tools used in evaluating the economic feasibility of a new enterprise or product is the

break-even analysis. The break-even point is the point at which revenue is exactly equal to costs. At this point, no

profit is made and no losses are incurred. The break-even point can be expressed in terms of unit sales or dollar

sales. That is, the break-even units indicate the level of sales that are required to cover costs. Sales above that

number result in profit and sales below that number result in a loss. The break-even sales indicates the dollars of

gross sales required to break-even.

It is important to realize that a company will not necessarily produce a product just because it is expected to break-

even. Many times, a certain level of profitability or return on investment is desired. If this objective cannot be

reached, which may mean selling a substantial number of units above break-even, the product may not be produced.

However, the break-even is an excellent tool to help quantify the level of production needed for a new business or a

new product.

Break-even analysis is based on two types of costs: fixed costs and variable costs. Fixed costs are overhead-type

expenses that are constant and do not change as the level of output changes. Variable expenses are not constant

and do change with the level of output. Because of this, variable expenses are often stated on a per unit basis.

Once the break-even point is met, assuming no change in selling price, fixed and variable cost, a profit in the

amount of the difference in the selling price and the variable costs will be recognized. One important aspect of

break-even analysis is that it is normally not this simple. In many instances, the selling price, fixed costs or

variable costs will not remain constant resulting in a change in the break-even.. And these changes will change the

break-even. So, a break-even cannot be calculated only once. It should be calculated on a regular basis to reflect

changes in costs and prices and in order to maintain profitability or make adjustments in the product line.

1

There are three basic pieces of information needed to evaluate a break-even point:

Average Per Unit Sales Price: ____________________

Average Per Unit Variable Cost: ____________________

Average Annual Fixed Costs: ____________________

The basic equation for determining the break-even units is:

Average Annual Fixed Cost

÷

(Average Per Unit Sales Price - Average Per Unit Variable Cost)

The basic equation for determining the break-even sales:

Annual Fixed Cost

÷

1 - (Average Per Unit Variable Cost ÷ Average Per Unit Sales Price)

Break-even analysis can be very helpful in the evaluation of a new venture. In most instances, success takes time.

Many new enterprises and products actually operate at a loss (at a point below break-even) in the early stages of

development. Knowing the price or volume necessary to break-even is critical to evaluating the time-frame in

which losses are permissible. The break-even is also an excellent benchmark by which a company’s short-term

goals can be measured/tracked. Break-even analysis mandates that costs be analyzed. It also keeps a focus on the

connection between production and marketing.

Example: A local livestock producer utilizes compost waste to develop an organic fertilizer product. The fertilizer

is prepared for retail sale in 50 pound bags. The retail sales price is $5.00 per bag. The average variable cost per

bag is $2.80 and average annual fixed costs are $60,000. These three pieces of information are:

Average Per Unit Sales Price = $5.00 per bag

Average Per Unit Variable Cost = $2.80 per bag

Average Annual Fixed Costs = $60,000.00

The above assumption can be utilized to calculate the number of bags that must be sold in order to break-even as

well as the total dollar of sales needed to break-even. Using the formulas explained earlier, the following

calculations can be made:

Break-Even Units: $60,000.00 ÷ ($5.00 - $2.80) = 27,273 bags

Break-Even Sales: $60,000.00 ÷ 1 - ($2.80 ÷ $5.00) = $136,365

Therefore, no profits are made from the sale of this product until more than 27,273 bags are sold or more than

$136,365 in gross sales is generated.