Google Sheets
VDB function in Google Sheets
Returns the depreciation of an asset for a particular period (or partial period). .
=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])VDB syntax and parameters
Seven arguments, five required.
- costanyRequired
- salvageanyRequired
- lifeanyRequired
- start_periodanyRequired
- end_periodanyRequired
- factoranyOptional
- no_switchanyOptional
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 Excel
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 Google Sheets gets this done.
- ACCRINTCalculates the accrued interest of a security that has periodic payments.FinancialExcel
- ACCRINTMCalculates the accrued interest of a security that pays interest at maturity.FinancialExcel
- AMORLINCReturns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.FinancialExcel
- COUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement.FinancialExcel
- COUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.FinancialExcel
- COUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment.FinancialExcel