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
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
Comments