Break-even Analysis for Bookkeeping

Break-even Analysis for Bookkeeping
  • Sep 17, 2018

Break-even Analysis for Bookkeeping

Original article 17  Sep 2017 - Updated Nov 2024

At a recent meeting an accountant asked a group of small business owners to estimate given a certain amount of fixed costs and variable costs what % per product sold would sales need to increase to gain a $20,000 increase in net profit. The various answers given indicated some deficiencies in small business strategies.

Calculations like this fall into the realm of Break-even Analysis.

Calculating for example what an increase or decrease in price of a product would do to your bottom line.

Break-even Point

Why is Break-even Analysis so important?

As a leading Gold Coast SEO I was staggered at the variation in estimates small business owners used to guess the figure - they ranged from a 400% increase to a 10% increase with the correct answer being 20% (I didn't get it right either).

These are experienced small business owners, many running successful businesses. Some of them appear clueless as to the basics of Break-even Analysis (at what sales volume point your business breaks even - covers it's costs).

Break-even analysis can really help quantify important business decisions.

Break Even Point Calculation
Can you understand the above Cost-volume Profit (CVP) Analysis and Break-Even Point (BEP) calculations?

Formula's used

BEP = Total Fixed Costs / (Price Per Unit - Variable Cost Per Unit)
Contribution Margin = Item Price - Variable Cost Per Unit
CVP = (Fixed Costs Dollar + Targeted Profit Dollar) / Contribution Margin Dollar Per Unit
Cost-volume Profit (CVP) Analysis and Break-Even Point (BEP)

For example you are a Brisbane Commercial Electrical Company and your competitors are using Google AdWords to attract customers - given your fixed and variable costs, the number of call-outs you do a week with the average Cost of Sales what price is the maximum you can bid in Google Adwords to attract a sale and make your profit target?
These are not simple calculations. This is further complicated by the fact that it may take 4 contacts (yes pay for 4 clicks and get 1 sale) to gain a sale. It's now getting scary as clearly many small businesses are not factoring the cost of a sale their advertising strategy needs to break-even. An efficient bookkeeper could help you make these decisions.
This is now entering the realm of Cash Flow Analysis.

Motor Mechanic Hoist
A motor mechanic may need to know whether purchasing a new hoist is going to be an effective business decision based on the extra overhead of the purchase.
A new hoist may then allow more clients per day to be serviced - however if a new hoist costs XXXX how much extra profit can be earned from the investment?
Is it a good investment?

Using a Bookkeeper to manage your books

Experienced bookkeepers help businesses collate and categorise expenses so effective analysis of profit can occur.
First a few common accounting terms to help us along. We need to classify your costs according to how they behave (are they fixed or variable) -:

Fixed Costs FC

Fixed costs are those that occur regardless of whether we make a sale.

Variable Costs VC

Variable costs are those that occur in making a sale, and they increase in proportion to our sales. For example a custom furniture manufacturer uses more timber as more tables are created.

Property Investment

Investing in Property

Break-even ratio is part of the tools you could use to analyse a property Investment. For property investors these calculations are quite complex-:

  • Rents
  • Loan Repayments
  • Water Rates / Council Rates
  • Repairs and maintenance

On the land

Wine producers need to decide whether to invest in shiraz for export or perhaps diversify into other varieties.

The calculation of BEP in vineyards is useful. This is the point the primary producer makes a profit. Given these are often seasonal calculations they are very important. A typical small business can adjust quickly. A primary producer has to plan often years ahead to harvest a crop.

Selling your business

At some stage you may need a business broker to sell your business

Calculations like break-even analysis can be used to demonstrate the viability of your business in laymen's terms rather than complex profit and loss statements.

Yoga Studio

Any business can benefit from Break-even analysis

Whether adding another employee is going to benefit your bottom line depends upon those fixed and variable costs.

A Yoga studio based on Gold Coast is not the first type of business you would expect to be using break-even analysis, however a quick look at the business model shows many good reasons for doing so.

At a certain number of monthly subscriptions the centre will break-even. Rent, Electricity, Insurance etc will be covered and additional subscriptions will be largely profit. Knowing you break-even with an average class attendance of say 4 students helps make a decision to setup the studio.

A Yoga studio will have initial setup costs like yoga mats etc however the ongoing costs apart from fixed costs are low.

How many yoga studios analyse these costs to determine the number of monthly subscriptions required to break-even?

SEO and Profit

How about skill upgrades and Training

Back to the topic of SEO (search engine optimisation) here are some of the variables involved-:

The price of SEO from a clients perspective must always deliver more value than you spend. Otherwise why bother. To be an effective SEO there is a certain amount of qualifications and training required.

Somewhere in the mix we need the skill and training to be an effective SEO at a price that is attractive to clients.

More Resources

A Gold Coast SEO and Web Developer