Docstoc

Depreciation Worksheet - Excel

Document Sample
Depreciation Worksheet - Excel Powered By Docstoc
					Depreciation Worksheet

                                     Straight Line Time Method
Original Cost of Equipment                                                   $1,500
Residual Value of Equipment                                                    $500
Useful life of Equipment                                                          5

Annual Depreciation Expense                                                    $200


                                    Units of Production Method
Original Cost of Equipment:                                               $2,300.00
Estimated Salvage Value:                                                    $100.00
Useful Life:                                                         4
Total Productive Capacity:                                          800
                                                                                           Year1           Year 2    Year 3    Year 4
Unit production in each of the production years                                                     200        300       200       100
Costs Per Unit                                                                $2.75


     Year     Beginning Value        Depreciation Expense   Accumulated Depreciation   Ending Book Value
    1          $2,300.00                $550.00                   $550.00                      $1,750.00
    2          $1,750.00                $825.00                  $1,375.00                       $925.00
    3           $925.00                 $550.00                  $1,925.00                       $375.00
    4           $375.00                 $275.00                  $2,200.00                       $100.00




Declining Balance
                                                      Sum-of-the Years' Digits Method
                      Asset Costs                                                  $0.00 For an Asset With a 5-Year Life
                      Salvage Value                                                $0.00
             Year     Acquisition Cost Less Salvage Value    Remaining Life in Years     Remaining Life/Total Life Depreciation Charge per Year
                    1                                  $0.00                           5                      0.33                         $0.00
                    2                                  $0.00                           4                      0.27          
				
DOCUMENT INFO
Description: This document sets forth a template worksheet to calculate depreciation. This basic worksheet provides calculations for the straight line time method depreciation, units of production method of depreciation, sum-of-the-years' method of depreciation, and double declining method of depreciation. Users can download this worksheet and easily fill in the necessary values. Depreciation calculations will effect a business' financial statements and depreciation can be an important tax consideration as well.