Docstoc

Depreciation Calculators

Document Sample
Depreciation Calculators Powered By Docstoc
					Quick Depreciation Calculator
Initial Value:                                     75,000
Estimated Salvage Value:                           10,000
Useful Life:                                         5
Estimated productive capacity (time units):        40,000

Straight-Line Method
   Year             Depreciable Amount        Depreciation Rate   Depreciation Expense
    1                   65,000.00                 20.00%                 13,000
    2                   65,000.00                 20.00%                 13,000
    3                   65,000.00                 20.00%                 13,000
    4                   65,000.00                 20.00%                 13,000
    5                   65,000.00                 20.00%                 13,000




Double -Declining Balance Method
   Year             Depreciable Amount        Depreciation Rate   Depreciation Expense
    1                   75,000.00                 40.00%                 30,000
    2                   45,000.00                 40.00%                 18,000
    3                   27,000.00                 40.00%                 10,800
    4                   16,200.00                 38.27%                 6,200
Accumulated Depreciation   Year-End Book Value
        13,000                   62,000
        26,000                   49,000
        39,000                   36,000
        52,000                   23,000
        65,000                   10,000




Accumulated Depreciation   Year-End Book Value
        30,000                   45,000
        48,000                   27,000
        58,800                   16,200
        65,000                   10,000
     2x Rate       0.4
     1 minus       0.6
 1     FALSE   TRUE       45000   10,000
 2     FALSE              27000   10,000
 3     FALSE              16200   10,000
 4     TRUE                9720   10,000
 5     FALSE             150000   10,000
 6     FALSE             150000   10,000
 7     FALSE             150000   10,000
 8     FALSE             150000   10,000
 9     FALSE             150000   10,000
10     FALSE             150000   10,000

				
DOCUMENT INFO
Description: A Quick Depreciation Spreadsheet