The Excel DB function is one of many Excel financial functions, and can be used to calculate the declining balance depreciation of a long term asset. It has the syntax DB (cost, salvage, life, period, month).

# Depreciation

## Excel DDB Function

The Excel DDB function is one of many Excel financial functions, and can be used to calculate the declining balance depreciation of a long term asset. It has the syntax DDB (cost, salvage, life, period, factor).

By setting the factor parameter to either one or two, the function can be used to calculate either the declining balance depreciation or the double declining balance depreciation.

## Reducing Balance Depreciation Calculator

## Sum of Years Depreciation Calculator

## Excel SYD Function

## Sum of the Years Digits Depreciation

## Accelerated Depreciation Method

## Reducing Balance Depreciation Calculation

## Units of Activity Depreciation Calculator

## Units of Production Depreciation Calculator

## Units of Production Depreciation Method

## Changes in Depreciation Estimate

Depreciation is calculated based on the chosen method of depreciation, and on estimates of an assets useful life and salvage value.

When there is an indication that a change in depreciation method, salvage value, or estimated useful life is necessary, then the business should revise its depreciation estimates accordingly.