Declining Balance Depreciation Calculator

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

The calculation is carried out using the declining balance depreciation formula which, each year, takes the net book value of the asset and multiples it by declining balance depreciation rate. The net book value is the cost of the asset less the accumulated depreciation to date.

Using this calculated declining balance rate, the asset will automatically be written down to its salvage value at the end of its useful life, at which point the depreciation expense is stopped.

The formula for declining balance depreciation is given as follows:

Declining balance depreciation = Net book value x Declining balance depreciation rate

and the formula for the declining balance depreciation rate is given by

Declining balance depreciation rate = 1 – Useful life √ Salvage value / Cost

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

declining balance depreciation calculator
Declining Balance Depreciation Calculator Preview

Using the Declining Balance Depreciation Calculator

The Excel declining balance depreciation calculator, available for download below, is used to compute 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 declining balance depreciation calculator works out the declining balance depreciation rate. This is the rate which will write the asset down to its salvage value over its useful life.
  4. Enter the year. Enter the year for which the depreciation expense is required.
    For example, if the depreciation is required for year fifteen of the assets life, enter the number 15. The declining balance depreciation calculator works out the depreciation expense for that year.

Declining Balance Depreciation Calculator Download

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

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

You May Also Like

Related pages

compound interest formula continuousjournal entry for sales and cost of goods soldcapital lease cash flow statementexcel discount formulacalculate payback period uneven cash flowshow to journalize freight chargeseffective interest rate calculation in excelinventory shrinkage definitionhorizontal analysis exampleexamples of indirect laborinventor of double entry accountingprovision for bad debts income statementbasics of double entry bookkeepingprepaid freight termsaccounting spreadsheet excelaccounts spreadsheet templateaccounting equation spreadsheetdupont identity formulaconvert accrual to cash basis worksheetreceivable days ratio formuladebtors ratio formulapercentage markup on costprepaid rent expensewhat is lcm in accountingthe profitability indexsimple payroll spreadsheetallowance method of accounting for bad debtsavailable for sale securities accountingfob shipping point freight collecthow to calculate perpetual inventoryexamples of bookkeepingaccounts receivable and unearned revenueexcel calculate percentage discountmerchandising chart of accountssingle equivalent discount rate formulaconsumables accountingmoney depreciation calculatort charts for accountingjournal entry for payment by chequecredit memo journal entrywhy are adjusting entries neededbank reconciliation statement pdf notesdouble entry accounting templatewhat are accruals and prepaymentsprepaid expenses entry in tallywhat is depletion expensechart of accounts for construction company templatemarkup percentage calculationjob costing excel templatewhat is accounts payable ledgerledgers in accountingissuance of treasury stockcash conversion periodis prepaid expense a current assetroce ratiothree column cashbookoperative leveragebond discount amortization schedulepetty cash template excelinventory value methodsprepayment balance sheetwhat is common stockholders equitypresent value in perpetuitydoubling rate equationexamples of adjusting entriesdays in accounts payable calculationhow do you calculate beginning inventoryhow to calculate cash discountcash flow margin ratio analysiswhat is the normal balance for accounts payabledebtors formulahow to calculate depreciation with residual valuecash receipt journal formatdouble entry bookkeeping exceljournal entry for accrued payrollthe formula for total fixed cost ishow to find unit contribution margin