Double Declining Balance Depreciation Calculator

Depreciation is a business expense, it represents the reduction in value of a long term asset due to wear and tear.

There are various methods used to calculate the depreciation expense one of which is the double declining balance depreciation method. This calculator will perform the double declining balance depreciation calculation for you, and work out the annual depreciation expense and the depreciation rate.

The calculation is carried out using the double declining balance depreciation formula which, each year, takes the net book value of the asset and multiples it by double the straight line depreciation rate.

Double declining rate = 2 / Useful Life

The net book value is the cost of the asset less the accumulated depreciation to date. The method is sometimes referred to as the 200 declining balance method.

Using this method, when the net book value reaches the salvage value, the depreciation expense is stopped.

The formula for double declining balance depreciation is given as follows:

Double Declining Balance Depreciation = Net Book Value x 2 / Useful life

Full details of how the declining balance depreciation method is used can be found in our depreciation tutorials.

double declining balance depreciation calculator v 1.1
Double Declining Balance Depreciation Calculator Preview

Using the Double Declining Balance Depreciation Calculator

The Excel double declining balance depreciation calculator, available for download below, is used to compute double declining balance depreciation by entering details relating to the asset. 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.
  3. Enter the useful life. The useful life is the anticipated time in years which the asset is expected to be useful to the business. The double declining balance depreciation calculator works out the double declining balance depreciation rate.
  4. Enter the year. Enter the year for which the depreciation expense is required.
    For example, if the depreciation is required for year eight of the assets life, enter the number 8. The double declining balance depreciation calculator works out the depreciation expense for that year.

Double Declining Balance Depreciation Calculator Download

The double declining balance depreciation spreadsheet is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this double declining balance 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 double declining balance method calculator that you might use when considering how to calculate double declining balance depreciation. It is purely illustrative of a double declining balance calculator. 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 200 declining balance depreciation calculator, please let us know and we will try to fix it.
Double Declining Balance Depreciation Calculator June 14th, 2017Team

You May Also Like


Related pages


adjusted trial balance worksheet templatefavorable variancesdividends declared income statementimportance of suspense accountstraight line depreciation graphaccrued revenue balance sheetpresent value annuity tableannuity growth ratecost ledger control accountcalculating interest on notes payabledefine freight collectcalculate annuity factorexample accounting worksheetthe income summary account is a permanent accountfixed asset ratio formulameaning deferred revenue expenditure give examplessingle entry ledger bookpayback method formulafixed asset disposal journal entrycogs journal entryproveit excel test tutorialformula for reducing balance depreciationworking capital turnover interpretationaccounts receivable journal entry examplepresent value of growing perpetuitymeaning of fob destinationadjusting entries for accrued salariescash count spreadsheetsample of income statement in excelwork in progress accounting entriesdefine contrasadjusting entries for inventoryrealizable valuebookkeeping and accounting notesexamples of income statementsdupont roaunearned revenue journal entrybeginners bookkeepinginventory turnover accountingsuspense account entry in tallycost accounting fifo methodbonds payable on balance sheetsalaries expense debit or creditdefine consignee and consignordefine amortisepromissory note journal entryunrealized loss journal entryselling price calculator with markupamortize bond discountprepayments and accruals double entrypresent value of dividends calculatorpayment formula excelwhat is implicit interest ratematerial price variance formulawhat is the pmt formulahow to reconcile accounts payableintangible items exampleswhere does accrued interest go on the balance sheetpaid accounts payable journal entryrental income journal entryinventory turnover equationfuture value of lump sum calculatorguide to bookkeepingwhat is factoring of accounts receivablepercent complete formulagross profit margin percentage formuladepreciation half year conventioncalculating the future value of an annuityexcel accounts spreadsheetlessor accounting for capital leasecalculation of profitability indexis prepaid insurance a current assetstandard chart of accounts for restaurantsretained earnings journal entryaccounting equation transactions worksheetaccumulated depletionimprest fundpresent value growing annuitydefinition of capital expenditure and revenue expenditure