**In excel, there are 5 types of depreciation functions that can be used to calculate the depreciation value of an asset. In this blog post, we will be discussing these functions. Let’s begin!**

## Step-by-Step Guide to SLN Function

SLN function stands for straight-line function. Here is how to use the SLN function in Excel to calculate depreciation value.

- Create a new excel sheet and input the cost of the asset, the residual value, and the useful life of the asset in their respective cells.
- In the cell you want to perform the SLN function, input the formula “
**=SLN(cost, residual value, useful life)**”. - In our case, the formula will be
**=SLN($B$2, $B$3, $B4$4)**. Note that the $ is added to make the cell an absolute reference. Press**Enter**to obtain the result. - Drag the formula down the column to calculate the depreciation value for each year.

## Step-by-Step Guide to SYD Function

SYD function stands for Sum of Years’ Digits. Here is how to use the SYD function in Excel to calculate depreciation value.

- In the cell you want to perform the SYD function, input the formula “
**=SYD(cost, residual value, useful life, period)**”. - In our case, the formula will be
**=SYD($B$2, $B$3, $B4$4, A7)**. Press**Enter**to obtain the result. - Drag the formula down the column to calculate the depreciation value for each year.

## Step-by-Step Guide to DB Function

DB function stands for Declining Balance. Here is how to use the DB function in Excel to calculate depreciation value.

- In the cell you want to perform the DB function, input the formula
**“=DB(cost, residual value, useful life, year, [month])”.** - In our case, the formula will be
**=DB($B$2, $B$3, $B4$4, A7).** - Drag the formula down the column to calculate the depreciation value for each year.

## Step-by-Step Guide to DDB Function

DDB function stands for Double Declining Balance. Here is how to use the DDB function in Excel to calculate depreciation value.

- In the cell you want to perform the DDB function, input the formula
**“=DDB(cost, residual value, life, period, [factor])**”. - In our case, the formula will be =
**DDB($B$2, $B$3, $B4$4, A7)**. - Drag the formula down the column to calculate the depreciation value for each year.

## Step-by-Step Guide to VDB Function

VDB function stands for Variable Declining Balance. Here is how to use the VDB function in Excel to calculate depreciation value.

- In the cell you want to perform the VDB function, input the formula “
**=VDB(cost, residual value, life, start period, end period, [factor], [no switch])**”. - In our case, the formula will be
**=VDB($B$2, $B$3, $B4$4, A7-1, A7)**. - Drag the formula down the column to calculate the depreciation value for each year.

## Conclusion

The step-by-step guide provided in this article can be used as a reference when using these functions in excel. Following these instructions, you can easily and accurately calculate an asset’s depreciation value in Excel.