[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

DDB

Syntax:

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

Description: Computes the depreciation of an asset for a specified period using the double-declining balance or some other specified method. [Note: Use VDB3.17.7.338) for a straight-line depreciation method when depreciation is greater than the declining balance calculation. end note]

Mathematical Formula:

MIN((cost - total depreciation from prior periods) * (factor/life), (cost - salvage - total depreciation from prior periods))

Arguments:

Name

Type

Description

cost

number

The initial cost of the asset.

salvage

number

The value at the end of the depreciation. (This is sometimes called the salvage value of the asset.)

life

number

The number of periods over which the asset is being depreciated. (This is sometimes called the useful life of the asset.)

period

number

The period for which the depreciation is to be calculated. (period shall use the same units as life.)

factor

number

The rate at which the balance declines. If omitted, it is assumed to be 2 (the double-declining balance method).

 

Return Type and Value: number – The depreciation of an asset for a specified period.

However, if

salvage < 0 #NUM! is returned.

cost life <= 0, #NUM! is returned.

life <= 0 #NUM! is returned.

period <= 0, #NUM! is returned.

factor <= 0, #NUM! is returned.

[Example:

DDB(2400,300,10*365,1) results in 1.32
DDB(2400,300,10*12,1,2) results in 40.00
DDB(2400,300,10,1,2) results in 480.00
DDB(2400,300,10,2,1.5) results in 306.00
DDB(2400,300,10,10) results in 22.12

end example]