Excel DB Function

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).

Read more

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.

Read more

Sum of Years Depreciation Calculator

This free sum of years depreciation calculator with depreciation schedule can be used for any asset with a maximum useful life of 600 periods. The calculator will wok our the depreciation for any period, and produce an asset depreciation schedule over the useful life.

Read more

Units of Production Depreciation Method

The units of production depreciation method is used to calculate the annual depreciation expense of property, plant and equipment based on its usage, and is sometimes referred to as the units of activity depreciation method or the usage method of depreciation.

Read more

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.

Read more