Depreciation Calculator
Document Sample


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
Get documents about "