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.

Last modified October 31st, 2019 by Michael Brown
Read more

Double Declining Balance Depreciation Calculator

Depreciation is a business expense reflecting the wear and tear of long term assets as they are used within the business.

The Excel double declining balance depreciation calculator, available for download below, is used to compute the annual depreciation charge using the double declining method.

Last modified July 16th, 2019 by Michael Brown
Read more

Declining Balance Depreciation

The declining balance method sometimes referred to as reducing balance, is a commonly used method of calculating the depreciation charge for an asset.

The depreciation charge is given by the declining balance method formula as follows:

Last modified November 1st, 2019 by Michael Brown
Read more

You May Also Like