[]

Document Solutions for Excel, Java Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
  - ACCRINT
  - ACCRINTM
  - AMORDEGRC
  - AMORLINC
  - COUPDAYBS
  - COUPDAYS
  - COUPDAYSNC
  - COUPNCD
  - COUPNUM
  - COUPPCD
  - CUMIPMT
  - CUMPRINC
  - DB
  - DDB
  - DISC
  - DOLLARDE
  - DOLLARFR
  - DURATION
  - EFFECT
  - FV
  - FVSCHEDULE
  - INTRATE
  - IPMT
  - IRR
  - ISPMT
  - MDURATION
  - MIRR
  - NOMINAL
  - NPER
  - NPV
  - ODDFPRICE
  - ODDFYIELD
  - ODDLPRICE
  - ODDLYIELD
  - PDURATION
  - PMT
  - PPMT
  - PRICE
  - PRICEDISC
  - PRICEMAT
  - PV
  - RATE
  - RECEIVED
  - RRI
  - SLN
  - SYD
  - TBILLEQ
  - TBILLPRICE
  - TBILLYIELD
  - VDB
  - XIRR
  - XNPV
  - YIELD
  - YIELDDISC
  - YIELDMAT
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Use JDK 8 Date Time API
Document Solutions Data Viewer
API Reference
Release Notes

SYD

This function returns the sum-of-years’ digits depreciation of an asset for a specified period.

Syntax

SYD(cost, salvage, life, period)

Arguments

This function has these arguments:

Argument	Description
cost	[Required] Initial cost of the asset
salvage	[Required] Value at the end of the depreciation
life	[Required] Number of periods over which the asset is being depreciated
period	[Required] Period for depreciation; must use the same units as the life argument.

Remarks

This function calculates the digits depreciation as follows:

Examples

SYD(B1,1000,10,1)

SYD(R1C2,1000,10,1)

SYD(100000,10000,5,2) gives the result 24,000