Suppose,if we have to calculate the straight-line depreciation for equipment that costs $80,000, lasts five years, will have a salvage value of $13,000 at the end of the fifth year.
Since it is Straight Line Balance method, the depreciation value for each year will be the same and can be calculated using MS Excel (R) as below.