Home   Electrical Contractor   Free Electrical Contractor Business Plan Templates   8.2 Break Even Point Analysis Template

8.2 Break Even Point Analysis Template

What is the Break Even Point template and why is it so important in a business plan for Lights On Electrical, Inc.?

The Break Even Point is one of the most key pieces of financial analyis that a small business owner likeAndy Powell can undertake when writing out the business plan for a small business like Lights On Electrical, Inc.. This analysis tells Andy Powell just how many units of products or service have to sold in order to cover the fixed costs faced by the business. This analysis tells the business owner how much they need to sell in order to stay alive and stay in business.

The Break Even Point Template allows Andy Powell the ability to analyse the costs and present a numerical and graphic analysis of just how much the business needs to sell to say alive. Also the template allows the businEss owner to conduct what if analysis by plugging in different unit sales prices amounts to arrive at the break even points for each.

How does the Break Even Point Analysis Template work? What goes into it?

The Break Even Point analysis template can be easily completed by following these steps:

  1. Put in the name of the small business like Lights On Electrical, Inc..
  2. Input the Sales Price for Unit of Product or Service. In the case of a realtor office you would enter a typical sales ticket, a dentist office would put in the sales of a typical patient visit on average.
  3. Gross Margin - this is the inverse of the cost of goods sold. To arrive at this number you would subtract your cost of goods sold from the total projected sales number to get the gross profit. The Gross Margin is the gross profit as a percentage of the Sales. The Gross Profit per unit of sales will be automatically calculated by the template.
  4. Next enter in the description of your operating expense one line at at time and enter in the dollar amount in the column to its rigth followed by that percentage of that particular operating expense you think is fixed. The template will calcualte the amount that is variable automatically.

That's it. As you finish up the operating expenses the template will automatically calculate the break even point and represent that on the graph and also update the chart that shows both your sales and fixed cost lines. The meeting point of these two lines if of course your break even point.

All you have to do is to click on the output tab from where you can copy and paste the updated Break Even Point analysis directly into your business plan word document.

Quick Links:

  1. Go to the Corresponding Questionnaire section for this industry.
  2. Go to the Corresponding Business Plan section for this industry.

Small Business Owner Resource Center


Articles on the Small Business Financing Sources, the Small Business Loan Basics, small business loans Checklist and SBA Loans are incredible sources of knowledge for the small business owner.



Credit Report and Credit Score Analysis, how to Read a Personal Credit Report and all about Business Credit cover the intricacies of credit and are required reading for everybody.



The Foundation Grant Directory is a free listing of sources for grants by state. Why not look if there is some free money out there for your business. Hey - you never know!



The Business Loan Application covers every item you will need in your loan package and tells you how to get approved for business loans.



Fire your loan broker and use our Free Business Loans Bank / Lender Directory to find every bank in the country lending to small businesses.



If you are looking to start a business - look no further.  Check out the Free Incorporation Guide discussion and the State Incorporation Resource Directory.

Rate this page
Your feedback is important to us | Please rate this page
1 2 3 4 5