The Excel SLN Function

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: