VDB
Returns the depreciation of an asset for a specified or partial period by using a declining balance method.
FinancialFinance & Accounting
What it does
Calculates variable declining balance depreciation.
Syntax
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Arguments
cost(number) — Cost.salvage(number) — Salvage.life(number) — Life.start_period(number) — Start.end_period(number) — End.
Examples
Variable Depreciation
Depr for first 6 months.
FORMULA
=VDB(2400, 300, 10*12, 0, 6)
RESULT
200
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 200 |