Accumulated depreciation is used to calculate an asset's net book value, which is the value of an asset carried on the balance sheet. The formula for net book value is the cost of the asset minus ...

In cell B5, type “straight-line method.” To calculate the depreciation value using the straight-line basis, or straight-line method (SLN), Excel uses a built-in function, SLN, which takes the ...

Here are some of the most commonly used depreciation methods: This straight-line depreciation method evenly distributes the ...