How to use SYD function for calculating depreciation in ms excel

Sponsored Links

SYD function is very important function of ms excel and it is used in accounting and finance . When you want to calculate the value of depreciation of any year , then Accountant can calculate with this SYD function . I am explaining it in following tutorial how to use it .

You can use SYD function with two way

First Way

Going to insert option above the excel sheet and then click function button . After clicking function button , you will see pop up box . In pop up box , you will see drop down button , select finance category from different categories and here you will see SYD function . Select it and then click ok .





After this you will find next pop up box in which you have to put the value of

( a) Cost = Original or initial cost of fixed asset
(b) Salvage = Salvage is the scrap value of fixed asset after use . It may be on estimation basis
(c) Life = Show the active life of fixed asset
(d) Per = Per means period , if you want to calculate depreciation for first year , you have to write 1 , if you have to calculate second year depreciation , then write 2 and so on . You can calculate depreciation of any period .



After this in excel sheet cell , you will find the value of depreciation $ 18000 which is calculated by SYD formula

Second way

You can apply direct following formula for calculating the value of depreciation .

First of write equal sign and then write Syd( cost, salvage, life, period )

formula

= Syd( cost, salvage, life, period )

put the value of cost , salvage , life and period as mentioned above and you will find here also
$ 18000