SYD (PQL - xl)
This function returns the sum-of-years digits depreciation of an asset for a specified period
- Library: PQL \ Spreadsheet \ Financial
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
SYD(cost, salvage, life, per)
Function Arguments
Name | Description | Type | Optional |
cost | Initial cost of the asset | Number |
|
salvage | Value at the end of the depreciation | Number |
|
life | Number of periods over which the asset is being depreciated | Number |
|
per | Period for depreciation; must use the same units as the life argument | Number |
|
Comments
This function is the same as the Microsoft Excel 'SYD' function - using the same inputs, logic and outputs.