关注我们

JavaScript 中的 SYD函数

描述

SYD函数返回指定期间资产的年折旧数字。

SYD (cost, salvage, life, per)

Argument	描述	Required/Optional
Cost	The initial cost of the asset.	Required
Salvage	The value at the end of the depreciation (sometimes called the salvage value of the asset).	Required
Life	The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).	Required
Per	The period and must use the same units as life.	Required

SYD的计算如下-

$$SYD =\frac {\left(成本-残废权\right)*\left(生命-每+1\right)* 2} {\left(life\right)\left(life + 1\right)} $$
If the specified salvage argument is < 0, SYD returns #NUM! error.
如果指定寿命或每个参数指定的值≤0,则SYD返回#NUM!错误。
链接：https://www.learnfk.comhttps://www.learnfk.com/javascript/advanced-excel-financial-syd-function.html

来源：LearnFk无涯教程网
如果指定的per大于指定的寿命参数,则SYD返回#NUM!错误。
如果任何指定的值都是非数字的,则SYD返回#VALUE!。错误。
无涯教程网