Formualizer Docs
ReferenceFunctionsFinancial Functions

SYD

SYD: Returns sum-of-years'-digits depreciation for a requested period.

Summary

SYD applies accelerated depreciation by weighting earlier periods more heavily.

Remarks

  • Formula: (cost - salvage) * (life - per + 1) / (life * (life + 1) / 2).
  • life and per must satisfy: life > 0, per > 0, and per <= life; otherwise returns #NUM!.
  • The function uses the provided numeric values directly (no integer-only enforcement).
  • Result sign follows (cost - salvage): positive for typical depreciation expense, negative if salvage > cost.

Examples

First SYD period
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3000
Final SYD period
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
600

FAQ

Does SYD require integer life and per?

No strict integer check is enforced; it uses provided numeric values directly after domain validation.

Which period values are valid?

per must satisfy 0 < per <= life, and life must be positive; otherwise #NUM! is returned.

Runtime metadata

Category

Financial

Signature

SYD(arg1: Number, arg2: Number, arg3: Number, arg4: Number)

Arity

min 4, max 4

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

arg4

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/financial/depreciation.rs

SLN

SLN: Returns straight-line depreciation for a single period.

XIRR

XIRR: Calculates annualized internal rate of return for irregularly dated cash flows.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes SYD require integer life and per?Which period values are valid?Runtime metadata