Business plan financial plan break even analysis chart

The reason why the father wished to close down the branch was that it appeared to be making a loss. However, it is quite the reverse; if the branch was closed then, the positive contribution from the branch would be lost and overall profits would fall. This is because the indirect costs of production do not vary with output and, therefore, closure of a section of the firm would not lead to immediate savings. This may mean that closing the branch would be a mistake on financial grounds.

Business plan financial plan break even analysis chart

In break-even analyses in which are are solving for the break-even price or number of sales, the payback period is defined ahead of time. Depending on rate of change in your market, this may be a few months or a few years. Or, if you are just starting a business, your bank may want to see evidence that you will start making a profit after 18 months, or some other period.

So, the total revenue TR is just the price P multiplied by number of units sold X. However, prices typically decrease with increasing demand, so be aware that the linear CVP model is a simplification.

Variable Costs Variable costs include the production, direct labor, materials, and other expenses which depend on the number of units produced and sold.


Some variable costs may be percentage-based like commissions while others may be dollar-based like material costs. In the break-even calculator, you can split the cost between the percentage-based and dollar-based categories. You should be aware that this is a simplification. For example, when labor is involved in production, productivity can have a significant effect see ref [1].

Fixed Costs Fixed costs are those which are assumed to be constant during the specified payback period and which do not depend on the number of units produced. Advertising, insurance, real estate taxes, rent, accounting fees, and supplies would all be examples of fixed costs.

Fixed costs also include salaries and payroll taxes for non-direct labor such as administrative assistants and managers, or in other words, the payroll not included as variable costs.

In reality, increasing production may also increase the expenses that are listed as "fixed costs" because they increase as the business grows and hires new employees. After you run the break-even analysis, and especially if you use the CVP model to calculate sales required to reach a target profit, you should revisit your cost analysis to ensure that the costs match the level of production and sales required to reach your goals.

Break Even Chart The spreadsheet includes a break-even chart like the one shown below, which shows the Break-Even Point BEP as the intersection between the Total Revenue and Total Cost when plotted with the number of units on the x-axis.

Actually, there are many ways to define the break even point.

business plan financial plan break even analysis chart

You may also want to calculate how long it will take you to break even, which is officially called the payback period. Break-Even Units The following formula is for calculating the number of units X you will have to sell over the specified period of time.

The formula for solving for the break-even price requires you to break down the variable costs into dollar-based and percentage-based costs: Payback Period For very simple sales scenarios, the CPV model can be used to solve for the Payback Period, or the number of months required to break even.

Both the revenue and the costs may depend on time so we have to define a few new terms. To calculate the payback period, the number of units sold X is specified as a number of units per month. Start-Up Costs are the costs required to develop the product, or create the very first product.

Recurring Fixed Costs are those which are paid monthly or annually but which are not directly tied to the number of units sold, like web-hosting fees, monthly advertising expenses, insurance premiums, etc.The Break-even Analysis lets you determine what you need to sell, monthly or annually, to cover your costs of doing business--your break-even point.

Illustration 1 shows the Break-even Analysis table from Business Plan Pro. The Break-even Analysis table calculates a break-even point based on fixed. Indecision and delays are the parents of failure. The site contains concepts and procedures widely used in business time-dependent decision making such as time series analysis for forecasting and other predictive techniques.

BASICS AND GETTING STARTED. Basics of Financial Management. Role of Treasurer and Board Finance Committee. If your small business is a corporation, you would do well to find someone experienced in financial management and encourage them to be your board treasurer (your board chair has this responsibility to find someone suitable, as well).

If you are using your business plan to attract investment or get a loan, you may also include a business financial history as part of the financial section.

Break-Even Point in units - Examples and Formulas | Business Plan Hut

This is a summary of your business from. A startup business will utilize a Break Even Analysis to calculate whether or not it would be financially viable to produce and sell a new product or pursue a new venture.

This analysis is a common tool used in a solid business formulas for the break even point are relatively simple, but it can be difficult coming up with the projected . An analysis to determine the point at which revenue received equals the costs associated with receiving the revenue.

Break-even analysis calculates what is known as a margin of safety, the amount.

Business Plan Pro - Easy Business Planning Financialse