[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

DDB

This function calculates the depreciation of an asset for a specified period using the double-declining balance method or another method you specify.

Syntax

DDB(cost, salvage, life, period, [factor])

Arguments

This function has these arguments:

Argument

Description

cost

[Required] Initial cost of the asset

salvage

[Required] Value at the end of depreciation

life

[Required] Number of periods over which the asset is being depreciated

period

[Required] Period for which you want to calculate the depreciation in the same units as the life argument

factor

[Optional] Rate at which the value declines; if omitted, the calculation uses 2 (double-declining method)

All arguments must be positive numbers.

Remarks

This function uses the following calculation for depreciation for a period:

cost – salvage(total depreciation from prior periods) x factor/life

Examples

DDB(B1,1000,10,1)

DDB(R1C2,10000,10,1)

DDB(500000,5000,5,1,4) gives the result of 40,0000