DB
Returns the depreciation of an asset for a specified period by using the fixed-declining balance method.
FinancialFinance & Accounting
What it does
Calculates depreciation using the fixed-declining balance method.
Syntax
DB(cost, salvage, life, period, [month])
Arguments
cost(number) — Initial cost.salvage(number) — Salvage value.life(number) — Useful life.period(number) — Period to calculate.
Examples
Declining Balance
Depreciation in year 1.
FORMULA
=DB(10000, 1000, 5, 1)
RESULT
3690
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 3690 |