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

cash payback period calculatorcalculating rocemargin multiplierannuity present value calculatorinterest expense journal entrylinear depreciation calculatordouble declining balance method formulacompounding periods per yearpetty cash statementpresent value of a growing annuityfixed asset inventory templatenet receivables turnoveraccounting adjusting entries practice problemsreceived invoice journal entrydebits and credits accountingdebtors balance sheetaccurred definitionexample of process costingwhat is the difference between accounts payable and bills payablecalculating present value of an annuitydupont analysis templatestraight line method of depreciation examplebills receivable discountedbookkeeping tutorial philippineswhat is ledger in accounting with exampleledger examples of bookkeepingexcel formula mortgagefob shipping destinationnpv annuitysubsidiary ledger accountsfob destination prepaidpresent value annuity due tablejournal entry for provision of income taxdepreciation and amortization formulasum of digits depreciationhow to calculate stock turnover ratiohire purchase journal entrymonthly ledger templatecontra revenue accountsgeneral journal adjusting entrieshow to calculate unit contribution marginformula of dividend payout ratiopractice bookkeeping testrecording adjusting entriesdirect material efficiency variancemock bank statementsimple interest calculation formula in excelprepaid freight definitioninstallment loan examplewhat is a cash disbursement journalexcel depreciation scheduleppv purchase price varianceaccounting equation and balance sheetformula for calculating debt equity rationet present value calculator in excelwhat is declining balance depreciationmultiple step income statementstock repurchase journal entrydaily timesheet template freeexamples of income statementsfreight in income statementlease payment calculator exceldeferred tax calculation worksheetdouble declining balance calculatorpresent value of a lump sum formulaentry for bad debtsprepaids accountingformula for debtors collection periodaccruals deferralsexamples of retained earningsannuity npvaccrued expense journal entryincreasing annuity immediate formulasample chart of accounts for personal financeaccounts receivable turnover ratio measuresdelayed perpetuity formulais accounts receivable a credit or debitwhere to find marketable securities on balance sheetcontra receivable