A small truck is purchased for 28000 It is expected to be of
A small truck is purchased for $28,000. It is expected to be of use to the company for 5 years, after which it will be sold for $6,900 . Determine the depreciation deduction at the fifth year ‘using SLN.
Solution
Excel function of using straight line depreciation year is SLN( cost, salvage, life )
Accordingly, SLN(28000,6900,5) = $ 4220
OR (28000-6900)/5 = $ 4220
