DDB function in Google Sheets
Calculates the depreciation of an asset for a specified period using the double-declining balance method.
=DDB(cost, salvage, life, period, [factor])DDB syntax and parameters
Five arguments, four required.
- costnumberRequired
The initial cost of the asset.
- salvagenumberRequired
The value of the asset at the end of depreciation.
- lifenumberRequired
The number of periods over which the asset is depreciated.
- periodnumberRequired
The single period within life for which to calculate depreciation.
- factornumberOptional
[ OPTIONAL - 2 by default ] - The factor by which depreciation decreases.
DDB examples
Formulas you'll actually reuse.
Double-declining balance, year 1 — twice the straight-line rate on the full cost:
=DDB(24000, 4000, 5, 1)Result
9600Year 2 — the same rate on what's left:
=DDB(24000, 4000, 5, 2)Result
5760
DDB in Excel
Same name — your formula ports as-is.
Try DDB in the playground
Edit the example — nothing to install.
Preloaded with the DDB formula from Example 1 — change anything and watch it respond.
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