ddb

Double-declining-balance depreciation.

Syntax

v = ddb(cost, salvage, life, period, factor)

Description

Returns depreciation for period using the declining-balance method. factor controls the rate (default 2 = double declining). Most aggressive front-loading of any common method.

Example

ddb(30000, 7500, 10, 1)

See also

• sln — Straight-line depreciation.
• syd — Sum-of-years’ digits depreciation.
• vdb — Variable-declining-balance depreciation between two periods.
• xdb — Fixed-declining-balance depreciation.