SYD(cost, salvage, life, period) |
Returns the sum-of-years' digits depreciation of an asset (Double). |
cost | The initial cost of the asset (Double). |
salvage | The value at the end of the depreciation (Double). |
life | The length of the useful life of the asset (Double). |
period | The period you want to calculate the depreciation over (Double). |
REMARKS |
* The "life" and "period" arguments must be expressed in the same units. * 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 SLN function to return the straight-line depreciation of an asset over a single period of time. * The equivalent Excel function is Application.WorksheetFunction.SYD * The equivalent .NET function is Microsoft.VisualBasic.Financial.SYD * For the Microsoft documentation refer to learn.microsoft.com |
Debug.Print Syd(500, 0, 1, 1) '= 500
Debug.Print Syd(500, 0, 2, 1) '= 333.334
Debug.Print Syd(500, 0, 2, 2) '= 166.667
Debug.Print Syd(500, 0, 3, 1) '= 250
Debug.Print Syd(500, 0, 3, 2) '= 166.667
Debug.Print Syd(500, 0, 3, 3) '= 83.333
Debug.Print Syd(10000, 9000, 1, 1) '= 1000
Debug.Print Syd(10000, 9000, 2, 1) '= 666.667
Debug.Print Syd(10000, 9000, 3, 1) '= 500
Debug.Print Syd(10000, 9000, 10, 1) '= 181.818
Debug.Print Syd(30000, 7500, 10, 1) '= 4090.909
Debug.Print Syd(30000, 7500, 10, 10) '= 409.091
Debug.Print Syd(10000, 500, 24, 12) '= 411.667
Debug.Print Syd(10000, 9000, 1, 2) 'Run-time error 5
Debug.Print Syd(10000, 9000, 3, 10) 'Run-time error 5
Debug.Print Syd(10000, 500, 3, 10) 'Run-time error 5
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top