deepcalc
DocsDDB

DDB

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

Returns double-declining balance depreciation.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=DDB(10000, 1000, 5, 1)
Result 4000

Syntax

DDB(cost, salvage, life, period, [factor])
cost
number required
salvage
number required
life
number required
period
number required
factor
number optional
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.