Docstoc

Depreciation Calculator Excel Template

Document Sample
Depreciation Calculator  Excel Template Powered By Docstoc
					            DEPRECIATION INFORMATION                                 DEPRECIATION CALCULATION

Item Name     :       Mobile Phone                     End of Year    Debet         Total       Book Value
Category      :       Electronics                           0                -            -       100,000.00
Cost          :                   100,000.00 USD            1          14,200.00    14,200.00      85,800.00
Salvage       :                    10,000.00 USD            2          12,183.60    26,383.60      73,616.40
Life          :                           15 year(s)        3          10,453.53    36,837.13      63,162.87
Method              Straight Line Depreciation              4           8,969.13    45,806.26      54,193.74
                  3 Sum of Years Digits Depreciation        5           7,695.51    53,501.77      46,498.23
                    Declining Balance                       6           6,602.75    60,104.52      39,895.48
                                                            7           5,665.16    65,769.68      34,230.32
                                                            8           4,860.71    70,630.38      29,369.62
VISIT EXCELTEMPLATES FOR MORE TEMPLATES AND UPDATES         9           4,170.49    74,800.87      25,199.13
                                                           10           3,578.28    78,379.14      21,620.86
                                                           11           3,070.16    81,449.31      18,550.69
                                                           12           2,634.20    84,083.50      15,916.50
                                                           13           2,260.14    86,343.65      13,656.35
                                                           14           1,939.20    88,282.85      11,717.15
                                                           15           1,663.84    89,946.68      10,053.32

				
DOCUMENT INFO
Shared By:
Stats:
views:95
posted:12/4/2011
language:English
pages:1