Returns the straight-line depreciation of an asset for one period. The amount of the depreciation is constant during the depreciation period.
SLN (Cost as Double, Salvage as Double, Life as Double)
Custo é o custo inicial dun activo.
Salvage é o valor dun activo ao final da depreciación.
Life is the depreciation period determining the number of periods in the depreciation of the asset.
REM ***** BASIC ***** Option VBASupport 1 Sub ExampleSLN REM Calculate the yearly depreciation of an asset that cost $10,000 at REM the start of year 1, and has a salvage value of $1,000 after 5 years. Dim y_dep As Double y_dep = SLN( 10000, 1000, 6 ) print y_dep ' returns 1500. End Sub