Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

DDB

Description: Returns the asset depreciation for a specified period using the double-declining balance method, or another method you specify.

Syntax: DDB(Cost, Salvage, Life, Period, [Factor])

Remarks:

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

Example:

Suppose a factory purchases a new machine. The machine costs $2,400 and has a lifetime of 10 years. The salvage value of the machine is $300. The following examples show depreciation over several periods. The results are rounded to two decimal places.

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.