Degree of Operating Leverage Calculator

What does it do?

The degree of operating leverage calculator shows the effect on operating income of the cost structure of a business.

The use of the degree of operating leverage is discussed more fully in our operating leverage tutorial.

The calculator works out both the degree of operating leverage and the operating leverage, and allows for details relating to two businesses or accounting periods to be entered so that comparisons can be made.

Degree of Operating Leverage Formula

This calculator works out the degree of operating leverage using the following formula:

Degree of operating leverage = Contribution margin / Operating income

In addition the calculator also works out the operating leverage of the business using the formula:

Operating leverage = Fixed cost/ Total cost
degree of operating leverage calculator v 1.0
Degree of Operating Leverage Calculator Preview

Instructions

The Excel degree of operating leverage calculator, available for download below, is used to calculate the degree of operating leverage by entering details relating to the quantity of units sold, the unit selling price and cost price, and the fixed costs of the business. The calculator is used as follows:

Step 1

Enter the titles for the two columns. This might be for the same business for different accounting periods, or for different businesses requiring comparison.

Step 2

Enter the quantity of units sold, unit selling price and unit cost price information for each business. The degree of operating leverage calculator works out the contribution margin per unit sold.

Step 3

Enter the fixed costs of the business. The calculator produces the income statement of the business based on the quantity of units entered in Step 2.

Step 4

The calculator uses the formulas above to calculate the degree of operating leverage and the operating leverage for each business.

Degree of Operating Leverage Calculator Download

The degree of operating leverage calculator spreadsheet is available for download in Excel format by following the link below.

The degree of operating leverage calculator is one of many financial calculators used in bookkeeping and accounting, discover another at the links below.

Notes and major health warnings
Users use this degree of operating leverage calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of an accounting tool that you might use when considering how to calculate operating leverage. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this degree of operating leverage excel calculator, please let us know and we will try to fix it.
Degree of Operating Leverage Calculator February 21st, 2017Team

You May Also Like


Related pages


formula of operating cyclemarkup margin calculatordepreciation journal entrieswhen is the balance in a prepaid expense account reducedfuture value of annuity formulapremium xxx accountshow to calculate direct labor ratenotes on consignment accountingannuity due chartpresent value annuity table pdfjournal entry for accrued rentjournal entry accumulated depreciationoperating lease accounting entriesaccounting quizesnet realizable value of inventorymanufacturing variancesgoodwill accounting treatment examplenet realizable value formulahalf year convention depreciationdividend journal entriesjournal entry to record impairment lossperpetual inventory income statementfuture value annuity equationimprest system meaningfinancial accounting worksheetis prepaid insurance a deferraldisposal of intangible assetscalculating roceturnover of accounts receivablefuture value lump sumfuture value of perpetuitydouble entry journal templatereconciliations in accountingaccrued salaries and wageshow to calculate cash discountuses of a trial balancethe balance of an unearned revenue accountjournal entries for variancesmarkup vs margin formulaannuity formula proofsalvage value and residual valuebookkeeping t accountsthe rule of 78sdifference between markup and marginhow to calculate days sales in inventoryamortization spreadsheet excelfactory overhead cost formulamarkup margin calculatormargin to markup calculatordefine deferred taxmonetary unitswhat is double declining balance depreciationbalancing accounts receivableequation for roajournal entries for share capitalhistorical accounting conceptprove it test tutorialdupont formulapurchase of marketable securitieshow to use the pmt function in excelwhat is a accrued expensetrial balance entries exampleswhat is the purpose of the bank reconciliation statementcalculating annuities duefob ship pointclosing entries for partnershipdebit accounts receivable creditblank income statement and balance sheetis bonds payable a current liabilitydeferred tax liability definition