# DDB

## Content

This function calculates the depreciation of an asset for a specified period using the double-declining balance method or another method you specify.

## Syntax

`DDB(cost, salvage, life, period, [factor])`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *cost* | [Required] Initial cost of the asset |
| *salvage* | [Required] Value at the end of depreciation |
| *life* | [Required] Number of periods over which the asset is being depreciated |
| *period* | [Required] Period for which you want to calculate the depreciation in the same units as the *life* argument |
| *factor* | [Optional] Rate at which the value declines; if omitted, the calculation uses 2 (double-declining method) |

All arguments must be positive numbers.

## Remarks

This function uses the following calculation for depreciation for a period:
cost – salvage(total depreciation from prior periods) x factor/life

## Examples

`DDB(B1,1000,10,1)`
`DDB(R1C2,10000,10,1)`
`DDB(500000,5000,5,1,4)` gives the result of 40,0000