deepcalc
DocsVDB

VDB

View as markdown/docs/functions/vdb.md Ask Claude about this pageOpens Claude with this page's address

Depreciation over a period, declining balance with switch.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=VDB(10000, 1000, 10, 0, 1)
Result 2000

Syntax

VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
cost
number required
salvage
number required
life
number required
start_period
number required
end_period
number required
factor
number optional
no_switch
boolean optional defaults to 0

Errors

#NUM!
=VDB(2, 2, 2, 2, 2)
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.