Break Even Formula

Break Even Point Formula

A business is said to break even when its revenue equals its expenses and the net income is zero.

It is useful to be able to calculate the revenue needed for a business to break even, and to do this the break even formula is used.

The break even formula is:

 Break Even Point = Fixed Costs / Gross Margin Percentage

To use the break even formula you need to obtain values for the gross margin percentage and the fixed costs.

Using your latest set of accounts or forecast you first need to calculate your gross margin percentage as follows:

  1. Take your current revenue figure (say 200,000).
  2. Total your variable costs (say 80,000). Variable costs are those that only happen if a product is produced and sold e.g manufacturing costs.
  3. Subtract the variable costs from the revenue figure to give a gross margin (200,000 – 80,000) = gross margin = 120,000.
  4. Divide the gross margin by the revenue figure to give a gross margin percentage (120,000/200,000)= gross margin percentage = 60%.

Using the Break Even Formula

To use the break even formula and to calculate break even you now need to proceed as follows:

  1. Total your fixed costs (say 96,000). Fixed costs are those which happen whether you sell anything or not e.g office costs.
  2. Divide your fixed costs by the gross margin (96,000/60%) = break even revenue = 160,000.

What the break even formula is saying is that at revenue of 160,000 and a gross margin percentage of 60% you make a gross margin of 96,000 (160,000 x 60%) which covers the fixed costs of 96,000 to give a net income of zero. Any revenue above 160,000 will result in a profit, any revenue below 160,000 will result in a loss.

Break Even Formula Download

The Excel sheet, available for download below, uses the break even formula to calculate break even point for you by inserting values for revenue, variable costs, and fixed costs.

Break Even Formula November 6th, 2016Team

You May Also Like

Related pages

present value of an annuity due of 1weighted average method of inventory valuationannuity due present valuefuture value lump sumbank reconciliation notes pdflabour rate varianceaccounting for consignment stockcalculate finished goods inventoryunearned revenue in balance sheetexcel double entry bookkeeping templatenet 30 eomcash replenishmentaccumulated depreciation chart of accountscapital lease lessor journal entrieswhat are marketable securities in accountingpv of dividends calculatorreconcile retained earningsexpanded basic accounting equationcost accounting standard costing and variance analysisflexible budget examplesteps of accounting cyclecogs exampleunearned revenue entrydaybook templatepetty cash imprest system templategeneral ledger account balancesamortised cost calculationhow to calculate weighted average of percentagesdebit and credit journal entriessalaries payable journal entrybookkeeping pdf tutorialfixed asset register exceltimes interest earned ratio calculationjob order costing accountingdouble entry bookkeeping explainedexpense ledger templatecost of goods sold formulasprofit formula in excelcredit sales balance sheetdiscounts on bonds payablestraight line depreciation with no salvage valuegross margin and contribution marginaccounts recievable turnoverar credit memodepreciation expense is an example of an accrued expensedebtors accounting definitioncalculate wip inventoryreceivable turnover formulainfinite cash flowcoverage ratios formuladifference between periodic and perpetual inventorydifference between single entry and double entry bookkeepingdebtor collection days ratioformat of debtors accountexamples of accruals in accountinglifo examplesddb depreciation formulafob freight prepaidsales return journal entrycalculate depreciable cost per unitformula for calculating gp6 column worksheet accountingaccounting equation exercisesformula asset turnoverhow to calculate debtors collection periodcontra asset accountsissuing stock journal entrycalculate ratios in exceldebtor collection ratioabsorption of overheadscalculating markup vs marginexample retained earnings statementvertical analysis in accounting