Sep 18 2016
07:01 AM
- last edited on
Jul 25 2018
09:21 AM
by
TechCommunityAP
Sep 18 2016
07:01 AM
- last edited on
Jul 25 2018
09:21 AM
by
TechCommunityAP
Excel includes 5 formulas to calculate depreciation (SLN,DB,DDB,VDB,SYD) and all of these formulas do not include cells for Starting Date and end date for the cycle to calculate depreciation using it except for VDB formula. For example if we want to calculate depreciation for a specific asset starting from 1st of july,2010 to 31st of December,2015. Using the current existing Excel formulas, depreciation can not be calculated directly. However it is used to calculate depreciation for the whole calendar year starting 1st January till 31st of December not for a partial period starting or ending in different dates. As An example of how complex to calculate depreciation using Excel formulas is SLN method.----------------------------------------------------------------------------------
=IF($A7=1,SLN($A$1,$A$2,$A$3)*((DATEDIF($A$4,DATE(YEAR($A$4),MONTH($A$5),DAY($A$5)),"M")+1)/12), IF($A7=$A$3+1, ((12-((DATEDIF($A$4,DATE(YEAR($A$4),MONTH($A$5),DAY($A$5)),"M")+1)))/12)*SLN($A$1,$A$2,$A$3),SLN($A$1,$A$2,$A$3)))
so I hope and recommend that every supervisor in the Arabic blog to help and support to add two more cells to depreciation formulas *Starting date *End date These recommendation make depreciation formulas more useful and matching the accounting the standards whereas depreciation expense is a major expense and miscalculating it leads to disaster. Best regards
Sep 19 2016 02:41 AM
Sep 28 2016 04:08 AM
i Agree with you Mr.Mohamed
Sep 28 2016 04:33 AM
Sep 28 2016 05:19 AM
Thank you. I hope that My suggestion is will be beneficial
Sep 28 2016 07:07 AM
i Agree with you Mr.Mohamed
Sep 28 2016 07:29 AM
Sep 28 2016 08:43 AM
Sep 28 2016 10:06 AM
Sep 29 2016 04:53 AM
Mar 27 2017 11:04 AM
=IF($A8=1,SLN($A$1,$A$2,$A$3)*((DATEDIF($A$4,$A$5,"ym")+1)/12), IF($A8=$A$3+1, ((12-((DATEDIF($A$4,$A$5,"ym")+1)))/12)*SLN($A$1,$A$2,$A$3),SLN($A$1,$A$2,$A$3)))
----------------- simple formula
Sep 30 2017 02:08 PM
Oct 01 2017 06:54 AM
Oct 25 2022 08:26 AM