xdb

Fixed-declining-balance depreciation.

Syntax

v = xdb(cost, salvage, life, period, month)

Description

Returns depreciation for period using the fixed-declining-balance method (Excel’s DB). Optional month (default 12) is the count of months in the first year.

Example

xdb(1000000, 100000, 6, 1, 7)

See also

• ddb — Double-declining-balance depreciation.
• sln — Straight-line depreciation.
• vdb — Variable-declining-balance depreciation between two periods.