Depreciation Calculator

Document Sample
Depreciation Calculator Powered By Docstoc
					Basic Depreciation Calculator
This calculator can be used to perform depreciation calculations for different depreciation
methods without the use of half-year, mid-quarter, or mid-month conventions. Do not use
this calculator for tax reporting.


     Asset Depreciation Information
           Asset Description
                    Category
         Purchase Price (P)                    9,000
         Salvage Value (Sn)                      200
      Depreciation Period (n)                      5
        Depreciation Method                       DB         DB Factor             200%

     Depreciation Schedule                                           [42]

         Year      Depreciation          Cumulative        Book Value
          1            3,600.00            3,600.00          5,400.00
          2            2,160.00            5,760.00          3,240.00
          3            1,296.00            7,056.00          1,944.00
          4              777.60            7,833.60          1,166.40
          5              466.56            8,300.16            699.84
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
          -                   -                   -                 -
-   -   -   -
-   -   -   -
-   -   -   -
-   -   -   -
-   -   -   -
-   -   -   -
-   -   -   -
-   -   -   -
-   -   -   -
-   -   -   -
-   -   -   -
MACRS Depreciation Rate Calculator
This calculator should not be used for tax reporting. The depreciation rate is calculated,
but the calculated rate can be off by as much as 0.01% due to rounding. You should verify the
rates with the official MACRS tables. Consult the official IRS publication to determine the
Convention, Recovery Period, Asset Class, Depreciation Basis, and allowable Method.


      Asset Depreciation Information
                Asset Description
                      Asset Class
               Depreciation Basis                1,000
              Recovery Period (n)                    5
              Depreciation Method              DB-SL           DB Factor             200%
                       Convention            Half-Year
                Placed in Service                    4
         Last Year of Depreciation                     6


      Depreciation Schedule                                                             [42]

          Year           Depreciation       Cumulative       Book Value           Rate (dj)
           1                    200.00          200.00           800.00           20.000%
           2                    320.00          520.00           480.00           32.000%
           3                    192.00          712.00           288.00           19.200%
           4                    115.20          827.20           172.80           11.520%
           5                    115.20          942.40            57.60           11.520%
           6                     57.60        1,000.00             0.00            5.760%
MACRS Depreciation Calculator
This calculator uses the depreciation basis reduction approach to calculate depreciation using MACRS
conventions. This approach allows adjustments to be made to the basis within the depreciation schedule for
purposes such as losses and improvements. Adjustments entered in year j affect the depreciation basis
for year j. This calculator should not be used for official tax reporting.

   Asset Depreciation Information
                  Asset Description
                        Asset Class
                 Depreciation Basis              7,500
                Recovery Period (n)                  7
                Depreciation Method                 SL      DB Factor            200%
                         Convention          Half-Year
                  Placed in Service                  1
           Last Year of Depreciation                  8
                 First Year Fraction             0.5000


   Depreciation Schedule                                                                                          [42]

    Year    Adjustments           Basis         Dj (SL)        Dj (DB)    Depreciation    Cumulative     Book Value
      1                         7,500.00          535.71           0.00          535.71         535.71       6,964.29
      2               500       7,464.29        1,148.35           0.00        1,148.35       1,684.06       5,815.94
      3                         5,815.94        1,057.44           0.00        1,057.44       2,741.50       4,758.50
      4                         4,758.50        1,057.44           0.00        1,057.44       3,798.94       3,701.06
      5                         3,701.06        1,057.45           0.00        1,057.45       4,856.39       2,643.61
      6                         2,643.61        1,057.44           0.00        1,057.44       5,913.83       1,586.17
      7                         1,586.17        1,057.45           0.00        1,057.45       6,971.28         528.72
      8                           528.72          528.72           0.00          528.72       7,500.00           0.00

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:11/23/2011
language:English
pages:4