Depreciation Calculators
W
Description
A Quick Depreciation Spreadsheet
Document Sample


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