Related Functions:

The SLN function calculates the straight line depreciation of an asset for one period.

### Syntax

=SLN(cost,salvage,life)

#### Arguments

Argument | Description |
---|---|

cost | The initial cost of the asset |

salvage | The value of the asset at the end of the depreciation |

life | The number of periods over which the asset is to be depreciated |

#### Examples

A | B | C | E | |
---|---|---|---|---|

1 | Data | |||

2 | $30,000 | Initial cost | ||

3 | $3,000 | Salvage value | ||

4 | 10 | Life (years) | ||

5 | ||||

6 | Formula | Result | Notes | |

7 | =SLN(A2,A3,A4) | $2,700.00 | The depreciation allowance for each year = (30000-3000)/10 |

#### Common Function Error(s)

Problem | What went wrong |
---|---|

#VALUE! | Occurs if any of the supplied arguments are not numeric values |

#DIV/0! | Occurs if the supplied life argument is 0 |

Straight line depreciation is most simple way of calculating the depreciation of an asset.

This method simply subtracts a fixed amount from the value of an asset during each period of the asset’s lifetime. Therefore, the straight line depreciation for one period is calculated by the following equation: