depreciation calculation by xny14254

VIEWS: 54 PAGES: 4

									Simple depreciation calculation:               monthly depreciation    =        acquisition cost
                                                                            equipment life in months

Example:

1)   Asset cost                    7,563.00            listed on equipment inventory obtained from Equipment Inventory Management
2)   Acquisition date              9/1/2000            listed on equipment inventory obtained from Equipment Inventory Management
3)   Asset life (years)                   8            ask, or derive from inventory data
3)   Asset life (months)                 96


Monthly depreciation expense
                                    $78.78



Calendar year                       2000       2001      2002     2003      2004     2005      2006     2007     2008    2009        Total
Equip. age (fiscal year)              1          2         3        4         5        6         7        8        9      10
Yearly depreciation expense        787.81     945.38   945.38    945.38    945.38   945.38   945.38    945.38   157.56   0.00       7,563.00
Number of months                     10         12        12          12     12       12        12       12       2        0          96
Sample data from standard Equipment Inventory worksheet. Items headed in blue are standard data entries. The green boxes
lifetime.
ITEMNO     DESCRIPTION           SERIAL MANUFACT MODELNO BLDG                      ROOM       ACQDATE
                                 NO

M-xxxxxxx MICROFUGE REFRIG xxxxx            EPPENDORF 5417R            xxx           xxx         04/01/2006


                                                                       Assuming 25 months for age of equipment:

                                                                                                     (5,968.00) * 25
                                                                                                        1,554.17

                                                          Asset life (in months) =         (acquisition cost) * (# months sinc
                                                                                                 accumulated depreciation a
 entries. The green boxes show how to calculate instrument total

             COST         ACCUM        YTD
                          DEPR         DEPR

               5,968.00     1,554.17      621.67


age of equipment:                      Asset
                                       Life
    (5,968.00) * 25                    (months)
                                           96
       1,554.17

sition cost) * (# months since acquisition)
accumulated depreciation amount
COSTCT DEPT      PONUM
R1

3.04E+09   104229 5.01E+09

								
To top