Double Declining Balance Depreciation Excel Example.xls -...

Asset Cost $100,000
Useful Life 5 years
Salvage Value $10,000
DDB Depreciable Base Rate Years Left DDB Depreciation
Year 1 $100,000 40% 5.0 $40,000
Year 2 $60,000 40% 4.0 $24,000
Year 3 $36,000 40% 3.0 $14,400
Year 4 $21,600 40% 2.0 $8,640
Year 5 $12,960 40% 1.0 $2,960
TOTAL $90,000

Remaining Book Value
$60,000
$36,000
$21,600
$12,960
$10,000

Asset Cost $100,000
Useful Life 5 years
Salvage Value $5,000
DDB Depreciable Base Rate