Double Declining Balance Depreciation Excel Example.xls - Asset Cost Useful Life Salvage Value DDB Year 1 Year 2 Year 3 Year 4 Year 5 $100,000 5 years

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

This preview shows page 1 - 4 out of 4 pages.

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
Image of page 1
Remaining Book Value $60,000 $36,000 $21,600 $12,960 $10,000
Image of page 2
Asset Cost $100,000 Useful Life 5 years Salvage Value $5,000 DDB Depreciable Base Rate
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture