; Depreciation Calculator Excel Template
Documents
User Generated
Resources
Learning Center
Your Federal Quarterly Tax Payments are due April 15th

# Depreciation Calculator Excel Template

VIEWS: 95 PAGES: 1

• pg 1
```									            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

```
To top