Excel
VDB function in Excel
Returns the depreciation of an asset for a specified or partial period by using a declining balance method
=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])VDB syntax and parameters
Seven arguments, five required.
- costnumberRequired
- salvagenumberRequired
- lifenumberRequired
- start_periodnumberRequired
- end_periodnumberRequired
- factornumberOptional
- no_switchbooleanOptional
VDB examples
Formulas you'll actually reuse.
Declining-balance depreciation for the first year:
=VDB(24000, 4000, 5, 0, 1)Result
9600Accumulated over the first three years in one call:
=VDB(24000, 4000, 5, 0, 3)Result
18816
VDB in Google Sheets
Same name — your formula ports as-is.
Try VDB in the playground
Edit the example — nothing to install.
Preloaded with the VDB formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets