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


calculating net realizable valuefv annuity tableaccounting equation and balance sheetaccounting intangiblesbeginning bookkeepingjournal entries in accounts payabledebtor turnover ratiofuture value of a perpetuity formulaexcel accounting spreadsheetcalculate variable cost per unithow to calculate margin and markupfob origin vs fob destinationtrade payables and trade receivableswhat is annuity formulaconsignment sales revenue recognitionhow to calculate profit markupaccounting principles and conventions pdfexamples of long term investments on a balance sheetexample statement of retained earningsfixed liabilities exampleswhat is freight out in accountingdepreciation straight line formulastandard costing journal entriesmarkup price calculatorsales journal formatcall option accounting journal entriesaccumulated other comprehensive income journal entrythe balance in discount on bonds payableunderstanding debits and creditsallocating manufacturing overheaddeferred tax asset examplewhat is the journal entry for accrued expensessfp accountingdeferrals accountingthe difference between margin and markuprule of 78ssimple ledger sheetrecording accounts payablevoucher templates wordformula for calculating present value of annuityledger templatesstages of accounting cycleirr formula in excelsafety stock calculation exceldebt to equity ratio explanationthe basic accounting equation isnper formula excelsimple accounting equationbad debt expense journal entriesjournal entry of goodwillbad debts journal entriescapital lease lessor journal entriessample accounting ledgervoucher sample formatpv function in excelbookkeeping template excelcontingent liability journal entrycompany projections templatedefine fob shipping pointformula to calculate inventory turnover ratiofactory overheadannuity formula excelcontra income accountdefinition of retained profithow to calculate variable manufacturing overheadbank reconciliation template xlsgoodwill impairment entryhow to calculate retail markup percentageshipping method fobreconciliation spreadsheetmargin calculator excelfreight in journal entrybond carrying value equals bonds payablestationery supplies definitiontimes interest earned ratio calculationlifo to fifo conversion