Units of Activity Depreciation Calculator

The units of activity depreciation method can be used to calculate the depreciation expense for property, plant and equipment based on the level of activity or usage of the asset.

The units of activity method is often used when the lifetime of an asset depends on the amount of activity or use it receives rather than on a specific number of years as used in the straight line depreciation method.

The asset depreciation for an accounting period is based on the level of activity in that accounting period. Activity units can be defined in any number of ways to suit the asset and the business, such as number of hours used, or number of miles driven.

The calculation is carried out using the units of activity depreciation formula which takes the cost of the asset less any expected salvage (residual) value, and divides this by the expected lifetime activity of the asset in units. The units of activity depreciation formula used in this calculator is as follows:

Units of activity depreciation = (Cost – Salvage value) / Expected lifetime units

If the unit of activity is defined as a unit of production, the method is sometimes referred to as the units of production depreciation method, and full details of how the method is used can be found in our units of production depreciation tutorial.

units of activity depreciation calculator v 1.0
Units of Activity Depreciation Calculator Preview

Using the Units of Activity Depreciation Calculator

The Excel units of activity depreciation calculator, available for download below, is used to compute units of activity depreciation by entering details relating to the asset and unit activity levels. The calculator is used as follows:

  1. Enter the cost of the asset. The cost of the asset can be found in the long term asset account, asset register, or on the original source document (invoice) for the asset
  2. Enter the salvage value. The salvage or residual value is the amount the asset is expected to be worth at the end of its useful life. The units of activity depreciation calculator works out the cost which is subject to depreciation, known as the depreciable cost.
  3. Enter the lifetime units of activity. The lifetime units of activity is the number of units which the asset is expected to be used for during its lifetime with the business. For example, if the asset is expected to last for 80,000 miles over its lifetime, then 80,000 is entered. The units of activity depreciation calculator works out the depreciation cost per unit for the asset.
  4. Enter the period units of activity. The period units of activity is the number of units the asset is actually used for during the accounting period. For example, if the asset was driven for 2,000 miles during the accounting period then 2,000 is entered. The units of activity depreciation calculator works out the depreciation expense for the asset for the accounting period.

Units of Activity Depreciation Calculator Download

The units of activity depreciation spreadsheet is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this units of activity depreciation 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 a units of activity depreciation method calculator that you might use when considering how to calculate units of activity depreciation. 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 units of activity depreciation method calculator, please let us know and we will try to fix it.
Units of Activity Depreciation Calculator November 6th, 2016Team

You May Also Like


Related pages


prepayments and accruals double entryconsignee agent meaningsample of bank reconciliation statementwhat is the formula for total variable costsales ledger double entrycash ledger book formatincome statement from trial balanceprepare a multiple step income statementmeasurement of information about a business in the monetary unitamortisation costfifo calculationsaccounts receivable credit or debit balanceaccrued expenses cash flowamortisation scheduleuk margin calculatordeferred expenses meaningaccumulated other comprehensive income journal entrybad debt reserve journal entrypetty cash floatdebtors days outstandingwhat is accrued expense payablejournal entry for accounts receivable collectedsalvage value formulanet profit margin ratio formulabookkeeping tutorialstrade debtor collection periodinventory bookkeepingvoucher payment sampletimesheet template pdftime sheet spreadsheetdebtor days formula monthlyperiodic quizstock turnover formulastraight line depreciation schedulefree purchase order form template exceldebt to equity calculatorexample of inventory turnoverpetty cash voucher definitionmargin markup tabletrade payablesundry debtors in balance sheetpresent value of a future annuity calculatorstock turnover rate formulagearing ratio formula calculationpercentage completion method examplediscounting a note receivableaccounting treatment of buyback of sharesdoes bad debt expense go on the income statementowners equity debit or credittimes interest earned calculationstockholders equity exampleamortization calculator excelaccrued expenses and outstanding expensescash vs accrualscalculating debt to equity ratio from balance sheetsales ledger definitioncalculate margin excelmateriality constrainthow to calculate absorption costing per unitexamples of double entry bookkeepingactivity ratios definitionpaid creditor on account journal entrywhat is verifiability in accountingwhat is prime cost in cost accountingnpv formula excel exampleoperating cash flow calculatorrevaluation loss journal entryassets equals liabilities plus capitaldepreciation schedule calculatoradjusting entries for prepaid expensescalculate present value annuityworksheet examples accountingcalculate depreciation straight line methodpost closing trial balance accountsamortization chart excel