DDB
Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.
FinancialFinance & Accounting
What it does
Calculates depreciation using double-declining balance.
Syntax
DDB(cost, salvage, life, period, [factor])
Arguments
cost(number) — Asset cost.salvage(number) — Salvage value.life(number) — Useful life.period(number) — Period.
Examples
Double Declining Balance
Depreciation in year 1.
FORMULA
=DDB(10000, 1000, 5, 1)
RESULT
4000
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 4000 |