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

what is the annuity formulareserve for bad debts journal entrydays accounts receivable formulaltd company accounts template exceldeferred revenue adjustmenteir accountinghow to calculate receivable daysexamples of trade receivableshow to calculate depreciation using double declining methodtotal asset turnover exampleincome account normal balancetable of present value of annuityamortize bondhow to find total fixed cost formulagross margin percentage formulaprepaid rent adjusting entryjournal entry for depreciation on machinerytotal conversion cost formulacn accounts payablemultiple step income statement templatethe double declining balance methodroce ratio calculationperpetual inventory system examplecredit debit chartmoney ledger printableformula for degree of operating leveragesample nonprofit chart of accountsannuity function excelthe fifo methodreconciliation booksmarkup vs margin charthow is cogs calculatedimprest cash accountaccounts receivable and accounts payable meaningmerchandise accounting definitiontemplate for receipt of moneyreducing balance depreciation calculatorunearned revenue is what type of an accountwhat is sales ledger control accountannuity due definitionnet fixed asset turnover ratioexcel basics quizperpetual inventory method journal entriesjournal entry to record depreciationbank reconciliation explanationledger t accountscapital lease amortization calculatorcash receipt book formatbookkeeping transactionsexcel ledger templatemargin & markup tablebill of discountingjournal entries in accounts payable process6 column worksheet accountingjournal entry for bills receivablecalculating periodic interest ratewhat is nsf checkfob shipping destinationadjusting entries examplessample of retained earnings statementhow to calculate retained profitunearned revenue arereducing balance interest calculatorleasehold premises in accountinggearing ratio calculationsample accounting worksheetsample cash voucherwhat is allowance for doubtful accountswhat is the journal entry for prepaid expensesmerchandise inventory beginningexcel function irradjusting entry for inventorydues and subscriptions definitioncreditors reconciliation template