# 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* | Initial cost of the asset |
| *salvage* | Value at the end of depreciation |
| *life* | Number of periods over which the asset is being depreciated |
| *period* | 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

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`DDB(B1,1000,10,1)`

`DDB(R1C2,10000,10,1)`

`DDB(500000,5000,5,1,4)` gives the result of $40,0000