SLN(cost, salvage, life) |
Returns the straight-line depreciation of an asset over a single period of time (Double). |
cost | The initial cost of the asset (Double). |
salvage | The value of the asset at the end of its life (Double). |
life | The 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 learn.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
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top