SLN(cost, salvage, life)

Returns the straight-line depreciation of an asset over a single period of time (Double).


costThe initial cost of the asset (Double).
salvageThe value of the asset at the end of its life (Double).
lifeThe length of the useful life of an asset (Double).

REMARKS
* The depreciation period must be expressed in the same unit as the "life" argument.
* You can use the DDB function to return the depreciation of an asset in a single period (double or triple declining balance method).
* You can use the SYD function to return the sum-of-years' digits depreciation of an asset.
* The equivalent Excel function is Application.WorksheetFunction.SLN
* The equivalent .NET function is Microsoft.VisualBasic.Financial.SLN
* For the Microsoft documentation refer to docs.microsoft.com

Debug.Print Sln(500, 0, 1)         '=  500  
Debug.Print Sln(500, 0, 2) '= 250
Debug.Print Sln(500, 0, 10) '= 50

Debug.Print Sln(10000, 0, 1) '= 10000
Debug.Print Sln(10000, 9000, 1) '= 1000
Debug.Print Sln(10000, 9000, 2) '= 500
Debug.Print Sln(10000, 9000, 3) '= 333.333
Debug.Print Sln(10000, 9000, 10) '= 100

Debug.Print Sln(30000, 7500, 10) '= 2250
Debug.Print Sln(30000, 7500, 5) '= 4500

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top