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


ebit interest coverage ratioallowance method for bad debtsstraight line depreciation rate formulaoverhead cost variance isfuture value of annuity calculatorstock turnover ratio formula examplebanking trivia questionsiou voucher templateaccounts ledgersanuity dueaccrued expenses in balance sheetfuture value function in exceldefine note payabledefine duesnotes on consignment accountingjournal entries for accounts receivable processsundry expenses definitionconvert accrual to cashannuity due financial calculatoraccounts recievable ledgerhow to calculate account receivableaccounting overheadspmt excellweighted average method equivalent unitsimprestsaccrual accounting explainedhow do you calculate asset turnoverexample of overstatementeconomic entity assumption definitionaverage receivables turnoverfixed asset turnover ratio formulaaverage contribution margin formulathe account type and normal balance of unearned revenue isbeginning bookkeepingmodified irr formulareceivables ledgerentry for unearned revenueimpairment loss on intangible assetsar turnover days formulathe final step in the accounting cycle is to preparemeaning of journal vouchercontribution margin income statement formatwhy are adjusting entries neededmargin or markupcalculate yield to maturity in excelprepaid rent debit or creditaccounts payable credit or debitcost accounting spreadsheetdifference between capital and drawingscash payback period formularevaluation loss journal entrydefine drawings in accountingaccounts receivable turnover formulafob destination collectaccounting adjustment entriesbasic accounting debit creditrevenue recognition percentage of completion methodintercompany receivables and payablesnet realisable value of inventoryreceipt ledgerfixed asset depreciation calculatorcreditor control accountinventory sale journal entryclassification quizconsignee consignoraccounts payable journal entrytriple column cash bookaccrued income examplemarkup formulaunderstanding bookkeepingvariable expenses examplesamortization expense journal entrybad debt expense and allowancespreadsheet examples for small businesshow to compute cost of goods manufacturedbad debt provision ifrsaccounting entry for retained earningsnon profit balance sheet template excel