Excel Straight Line (SLN) Depreciation YouTube Video
The straight line value is an excel formula which calculates the total depreciation amount of an asset you may hold for you business. Such as manufacturing machines.
Theory:
=SLN(Cost of item, Lowest depreciated value, Life span of asset in years)
Example with number values:
=SLN(6789,1000,10)
Example using cell references:
=SLN(A2,A3,A4)
Where cells:
A2 = Cost of item
A3 = Lowest depreciated value
A4 = Life span of asset in years
The straight line value is an excel formula which calculates the total depreciation amount of an asset you may hold for you business. Such as manufacturing machines.
=SLN(Cost of item, Lowest depreciated value, Life span of asset in years)
Example with number values:
=SLN(6789,1000,10)
Example using cell references:
=SLN(A2,A3,A4)
Where cells:
A2 = Cost of item
A3 = Lowest depreciated value
A4 = Life span of asset in years
0 comments:
Post a Comment