Excel SYD Function

The Excel SYD function has the syntax shown below.

SYD(Cost, Salvage, Life, Per)
Arguments used in the Excel NOMINAL function
SYD = Sum of the years digits depreciation
Cost = Cost of the asset
Salvage = Salvage value of the asset at the end of its useful life
Life = Number of periods in the useful life of the asset
Per = The period for which the depreciation expense is required

Use of the Excel SYD Function

The Excel SYD function is used to calculate the sum of the years digits depreciation for a given period.

Excel SYD Function and Annual Depreciation

A business purchases an asset for 9,000 and estimates it has a salvage value of 1,000 at the end of its 4 year useful life. Calculate the sum of the years digits depreciation for year 3.

The sum of the years digits depreciation for year 3 is given by the Excel SYD function as follows:

Cost = 9,000
Salvage = 1,000
Life = 4 years
Per = 3 
SYD Depreciation = SYD(Cost, Salvage, Life, Per)
SYD Depreciation = SYD(9000, 1000, 4, 3)
SYD Depreciation = 1,600

The sum of years digits depreciation for year 3 is calculated as 1,600.

Excel SYD Function and Monthly Depreciation

In the above example the depreciation was calculated on an annual basis and the period was defined in terms of years. However, the Excel SYD function can be used with any period simply by defining the length of the period. For example, if the life of the asset above was defined as 48 months instead of 4 years, then the SYD depreciation for month 11 can be calculated as follows:

Cost = 9,000
Salvage = 1,000
Life = 48 months
Per = 11
SYD Depreciation = SYD(Cost, Salvage, Life, Per)
SYD Depreciation = SYD(9000, 1000, 48, 11)
SYD Depreciation = 258.50

The sum of years digits depreciation for month 11 is calculated as 258.50.

Depreciation calculated using Excel SYD function is higher in the earlier periods than in the later periods of the assets useful life, and for this reason is known as an accelerated depreciation method.

The Excel SYD function is one of many Excel financial functions used in accounting calculations, discover another at the links below.

Excel SYD Function November 6th, 2016Team

You May Also Like


Related pages


interpretation of gearing ratioprovision for losses on accounts receivableperpetuity growth model formulaprepaid expenses treatment in balance sheetcash flow to creditors formulabank reconciliation excel templatewhat are adjusting entriesunearned revenue on balance sheetinternal rate of return discount ratestandard variable overhead rate formulafinance lease ifrs exampleconsigned inventory accountingjob costing excel templatecapital owners equityformula of working capital turnover ratiodisadvantages of internal rate of returnformula for quick ratio in accountingfifo method inventorysfp accountinginterest expense adjusting entryactivity ratios measureblank inventory sheetwhat is the purpose of closing entrieshow to calculate operating leveragecost of merchandise sold equals beginning inventoryadjusting entries affect onlycalculate ratios in excelhow to replenish a petty cash fundformula for gearing ratiounearned revenue in income statementexpanded basic accounting equationlcm valuationwhat is consumable suppliesthe accounting cycle stepscalculate interest expense on bondspayment receipt format docbasics of double entry bookkeepingadjusting inventory journal entryallowance for bad debt accountasset contra accountexample of lifo methodformula of shareholders equityentry for bad debtsdeclaring dividendsperpetual lifo exampleinventory turnover is calculated by dividingweighted average contribution margincalculating depreciation using reducing balance methodwhat is double entry bookkeeping definitionwhat accounts belong in the general ledgercontra revenue accountdividend journal entriesquick ratio formula financewhat are the steps in the accounting cyclewhat are closing entriest accounts journal entriesimprest account definitionrumus future valuetotal variable costs formulawhat is transposition in accountinghow to calculate manufacturing overhead costdisposal of asset journal entrydefine daybookfob destination meaningdays receivable formularecording bad debt expense journal entryfob transportationcoupon bond calculationaccounting equation transactions worksheetthe formula for the gross margin percentage ishow to calculate depreciation using straight line methodhow do you calculate asset turnoveruses of petty cash bookutilization formula call centerbad debts entriescapital lease journal entrycash receipts journal example