See Also:
Contribution Margin
Cost Volume Profit Model
How to Prepare an Investor Package
ProForma Financial Statements
Net Profit Margin Analysis

Break-Even Analysis

Purpose

The break even analysis serves to provide the company with a very important piece of information: "How much revenue does the firm need to make in order to break even."

This break even analysis is quite easy to do. The only critical piece of information that you will need to attain is a breakdown of the your firm's expenses into Fixed Expenses and Variable Expenses.

Once you have a breakdown of fixed costs and variable costs, input these costs into the template. You will also be able to conduct various "What if" scenario analyses to see how the breakeven revenue will change.

Once you are able to arrive at the break even analysis you can show the Owner(s)/Management this metric and make it part of their sales planning. Another idea might be to incorporate this metric into the Flash Report review meeting. This way your staff can know on a weekly basis if they are on track to at least breaking even. See document: Break Even What If.xls

Accumulate Expense Information

In order to successfully do the break even analysis, the following financial information will need to be gathered and/or created: Current Monthly Fixed Expenses (Dollar Basis), Current Monthly Variable Costs (as a Percentage of Revenue) and any "What if" scenario changes that you would like to consider. Note: This is optional depending on whether or not you would like to conduct a sensitivity analysis.

Depending on the robustness of your financial system, you may or may not have some of the above inputs. As such, it may be necessary to first create them prior to working on the break even analysis.

Once the initial break even analysis has been done, it will just be a question of maintaining it by inputting the most recent financial information. This maintenance can be done on either a monthly or quarterly basis. The CFO/controller should set it up. Another consideration would be to "outsource" the task to a consultant. Once you get the expense info, you will need to separate the list into a Fixed Expense portion and a Variable Expense portion.

Also, as part of your break even analysis, you may want to discuss any "What if" scenarios with the Owner(s)/Management. They will be able to provide any direction you need with regards to changes in expenses going forward.

Input Expense Information/Scenario Analysis

Once the initial break even analysis is done, you can also input alternative scenarios under the “$ Change” OR “% Change” columns. Do not input data into both columns as the program will sum up both together.

Once you have gathered and/or organized all the expenses into either the Fixed or Variable group, it will now be time to enter the appropriate data into the template.

Fixed Expenses - List each type of fixed expense under the "General and Admin/ Fixed Expenses" header. You can usually get this information off of your income statement. NOTE: Fixed expenses are expressed in dollars. Input the dollar value of each fixed expense item under the "Base" heading.

Variable Expenses - List each type of variable expenses will be entered under the "Variable Costs" header. You can usually get this information off of your income statement. NOTE: Variable expenses are expressed in terms of percentage of revenue. Input each variable expense item as a percentage of total revenue under the "Base" heading.

Scenario Analysis - Once the initial breakeven analysis is done, you can also input alternative scenarios under the “$ Change” OR “% Change” columns. Do not input data into both columns as the program will sum up both together.

Fixed Expenses - Input your changes in the areas highlighted EITHER in yellow or aquamarine. DO NOT enter changes in both columns as the program will sum up both columns.

Variable Expenses - Input your changes in the yellow highlighted area only.

The program will calculate the contribution margin and the sales necessary to achieve breakeven status. Please note that this break even analysis assumes a single/composite product line. You may want to use a more sophisticated approach to ascertain the break even point for a mixed product group.

Maintain Monthly/Quarterly

Once the break even analysis has been done, it will be very easy to update it. Line items on the income statement usually don't change. However, it may be worth double-checking to make sure that no additional expense line items have been made. Having done so, it will simply be a matter of updating the figures for the expense line items.

Once the initial break even analysis template has been set up, it will just be a question of maintaining it by inputing the most recent financial information. This maintenance can be done on either a monthly or quarterly basis.