Course Hero Logo
Upload to Study
Expert Help

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

Doc Preview
Pages 4
Total views 100+
Asset Cost$100,000 Useful Life5 years Salvage Value$10,000 DDBDepreciable BaseRateYears LeftDDB Depreciation Year 1$100,00040%5.0$40,000 Year 2$60,00040%4.0$24,000 Year 3$36,00040%3.0$14,400 Year 4$21,60040%2.0$8,640 Year 5$12,96040%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 Life5 years Salvage Value$5,000 DDBDepreciable BaseRate
Course Hero Badge

End of preview

Want to read all 4 pages? Upload your study docs or become a member.
Unformatted text preview: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 $10,800 40% 1.0 $4,320 Straight Line Depreciation Actual Depreciation $20,000 $40,000 $15,000 $24,000 $12,000 $14,400 $10,800 $10,800 $10,800 $5,800 TOTAL $95,000