"Break-Even Analysis Template"

What Is a Break-Even Analysis?

A Break-Even Analysis is an analytical tool that allows an entity to determine at what point its business may reimburse all of the investments made in this project, and the subsequent income that can be called profit. This point is called the break-even point, break-even threshold, or profitability threshold. When this point is reached, the enterprise or investment project has no profit and no losses. Even before the start of investment activity, it is necessary to determine the volume of products to sell or the volume of services to provide to compensate for current costs.

A comprehensive break-even analysis entails getting a dynamic view of the correlation between its sales, costs, and profits. This analysis also helps to understand the feasibility of increasing production volumes, calculate and schedule a sales plan, determine the number of product units that must be sold to work without losses, and evaluate how changes in prices, costs, and sales volumes affect the company's revenue. A Break-Even Analysis template available in Excel can be downloaded through the link below.

ADVERTISEMENT

How to Do a Break-Even Analysis?

In order to use the break-even analysis formula, you must correctly divide all of the costs of the current period into fixed and variable costs. Fixed costs are those costs that do not depend on and do not change with changes in production and sales volumes. These costs include property and real estate taxes, depreciation charges for a linear method of accrual, rental and security payments, accounting and insurance expenses, utility costs, and wages of administrative personnel.

Variable costs are those costs that change as production and sales volumes change. These costs include the cost of raw materials and component materials, energy and fuel costs, wages of workers engaged in the production process, including accruals and commission fees.

The break-even threshold can be defined in units of production, in monetary terms, or based on the expected amount of profit. To determine the break-even threshold in units of production or natural terms, you should take the following calculations:

  • Determine the margin profit per unit of production. For this purpose, subtract the average variable costs from the unit sale price;
  • To obtain the value of the desired point, you need to divide total fixed costs by marginal profit per unit of production.

To determine the break-even threshold in monetary terms, you should take the following calculations:

  • Calculate the entire costs, which is the sum of variable and fixed costs necessary for a specific volume of output;
  • Determine the gross revenue amount, which is equivalent to the sum of the total costs. It is required to know that the gross revenue is equal to the product of price and sales volume;
  • To calculate gross margin profit, subtract the sum of variable costs from the gross revenue amount;
  • To obtain the value of the desired point, you need to multiply gross revenue by total fixed costs and divide the received value by gross margin profit.

Based on the obtained calculations, it is necessary to build a linear or non-linear break-even analysis graph that displays the obtained results.


Haven't found the template you're looking for? Take a look at the related templates below:

ADVERTISEMENT

Download "Break-Even Analysis Template"

119 times
Rate (4.6 / 5) 8 votes
Break-Even Analysis
2018
2019
2020
2021
Current BE Chart
Current Pie
Projected BE Chart
Projected Pie
Sales $
($
2,010,000)
Fixed %
15.78%)
Sales $
($
2,391,800)
Fixed %
13.26%)
$2,010,000 $2,060,000 $2,121,800 $2,391,800
Fixed $
($
317,133)
Total Variable %
52.99%)
Fixed $
($
317,133)
Total Variable %
39.51%)
Sales
Total Variable $
$1,065,000)
Profit %
31.24%)
Total Variable $
$945,000)
Profit %
47.23%)
Less Variable Expenses
Materials
$320,000
$329,600
$339,488
$389,088
Current
Projected
©
TEMPLATEROLLER.COM
Labor
$500,000
$515,000
$530,450
$545,450
Sales $
$2,010,000)
$2,391,800)
Variable overhead
$125,000
$128,750
$132,613
$186,363
Fixed $
$317,133)
$317,133)
Other
$0
$0
$0
$0
Total Variable $
$1,065,000)
$945,000)
Contribution Margin
(1,065,000) (1,086,650) (1,119,250) (1,270,900)
Total Variable %
53%
40%
Contribution Margin Ratio
52.99%
52.75%
52.75%
53.14%
$627,867)
$1,129,667)
Operating Profit $
Break-Even %
34%
22%
Fixed Expenses
BE Dollars
$674,537)
$524,273)
Salaries and wages
$190,000
$190,000
$190,000
$190,000
BE Date
May 01
Mar 20
Employee benefits
$50,000
$51,500
$53,045
$54,545
Payroll taxes
$30,000
$30,900
$31,827
$32,727
Rent
$5,000
$5,150
$5,305
$5,455
Utilities
$3,000
$3,090
$3,183
$3,273
Repairs and maintenance
$1,000
$1,030
$1,061
$1,061
Insurance
$1,000
$1,030
$1,061
$1,061
Travel
$2,133
$2,197
$2,263
$2,263
Telephone
$11,000
$11,330
$11,670
$12,670
Postage
$4,000
$4,120
$4,244
$4,244
Office supplies
$6,000
$6,180
$6,365
$6,365
Advertising
$1,000
$1,030
$1,061
$1,061
Marketing/promotion
$3,000
$3,090
$3,183
$3,183
Professional fees
$1,000
$1,030
$1,061
$1,061
Training and development
$1,000
$1,030
$1,061
$1,061
Bank charges
$1,000
$1,030
$1,061
$1,061
Depreciation
$1,000
$1,030
$1,061
$1,061
Interest Expense
$6,000
$6,000
$6,000
$6,000
Other
$0
$0
$0
$0
Total Fixed Expenses
(317,133)
(320,767)
(324,510)
(328,150)
Total Fixed Expenses Ratio
15.78%
15.57%
15.29%
13.72%
Break-Even Sales
(598,533)
(608,089)
(615,185)
(617,570)
Break-Even %
29.78%
29.52%
28.99%
25.82%
Operating Profit
(747,867)
(765,883)
(794,740)
(942,750)
Break-Even Analysis
2018
2019
2020
2021
Current BE Chart
Current Pie
Projected BE Chart
Projected Pie
Sales $
($
2,010,000)
Fixed %
15.78%)
Sales $
($
2,391,800)
Fixed %
13.26%)
$2,010,000 $2,060,000 $2,121,800 $2,391,800
Fixed $
($
317,133)
Total Variable %
52.99%)
Fixed $
($
317,133)
Total Variable %
39.51%)
Sales
Total Variable $
$1,065,000)
Profit %
31.24%)
Total Variable $
$945,000)
Profit %
47.23%)
Less Variable Expenses
Materials
$320,000
$329,600
$339,488
$389,088
Current
Projected
©
TEMPLATEROLLER.COM
Labor
$500,000
$515,000
$530,450
$545,450
Sales $
$2,010,000)
$2,391,800)
Variable overhead
$125,000
$128,750
$132,613
$186,363
Fixed $
$317,133)
$317,133)
Other
$0
$0
$0
$0
Total Variable $
$1,065,000)
$945,000)
Contribution Margin
(1,065,000) (1,086,650) (1,119,250) (1,270,900)
Total Variable %
53%
40%
Contribution Margin Ratio
52.99%
52.75%
52.75%
53.14%
$627,867)
$1,129,667)
Operating Profit $
Break-Even %
34%
22%
Fixed Expenses
BE Dollars
$674,537)
$524,273)
Salaries and wages
$190,000
$190,000
$190,000
$190,000
BE Date
May 01
Mar 20
Employee benefits
$50,000
$51,500
$53,045
$54,545
Payroll taxes
$30,000
$30,900
$31,827
$32,727
Rent
$5,000
$5,150
$5,305
$5,455
Utilities
$3,000
$3,090
$3,183
$3,273
Repairs and maintenance
$1,000
$1,030
$1,061
$1,061
Insurance
$1,000
$1,030
$1,061
$1,061
Travel
$2,133
$2,197
$2,263
$2,263
Telephone
$11,000
$11,330
$11,670
$12,670
Postage
$4,000
$4,120
$4,244
$4,244
Office supplies
$6,000
$6,180
$6,365
$6,365
Advertising
$1,000
$1,030
$1,061
$1,061
Marketing/promotion
$3,000
$3,090
$3,183
$3,183
Professional fees
$1,000
$1,030
$1,061
$1,061
Training and development
$1,000
$1,030
$1,061
$1,061
Bank charges
$1,000
$1,030
$1,061
$1,061
Depreciation
$1,000
$1,030
$1,061
$1,061
Interest Expense
$6,000
$6,000
$6,000
$6,000
Other
$0
$0
$0
$0
Total Fixed Expenses
(317,133)
(320,767)
(324,510)
(328,150)
Total Fixed Expenses Ratio
15.78%
15.57%
15.29%
13.72%
Break-Even Sales
(598,533)
(608,089)
(615,185)
(617,570)
Break-Even %
29.78%
29.52%
28.99%
25.82%
Operating Profit
(747,867)
(765,883)
(794,740)
(942,750)