What am I doing with this excel sheet using this data given below.

B D E G 1 Small Builders, Inc. 2 Equipment Depreciation Summary 3 4 For Part A below, use formulas that reference the Asset worksheets to fill in the information below. 5 6 Example: 2015 2016 2017 2018 2019 Date Deprec. 2015 . . 2016 Acc. 2017 Acc. 2018 . 2019 Acc. 7 Asset Acquired Cost Method Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. S Tools 1/1/2014 $10,000 $2,000 $2,000 $2.000 $4,000 $2,000 $6,000 $2,000 S8,000 $2,000 $10,000 9 10 11 Part A: 2015 2016 2017 2018 2019 Date Deprec 2015 Acc. 2016 . . 2017 . . 2018 Acc. 2019 . 2 Asset Acquired Method Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. Deprec. 3 DDB Cost 3 Total D E F G H I K L M Hint: IF=(condition, value if true, value if false) - Cell G12 IF=[condition, value if true, value if false(condition, value if true, value if false)] - Cells G13-G16 X should switch do not switch A B C 1 Small Builders, Inc. Depreciation Schedule 2 3 Asset # 1001 4 Asset Display Cases 5 Date acquired 1/1/2015 6 Cost $ 15,000.00 7 Depreciation method DDB 8 Salvage value $ 9 Estimated useful life 5 10 Depreciation Accumulated 11 Year Expense Depreciation 12 2015 $6,000.00 $6,000.00 3 2016 $3,600.00 $9,600.00 4 2017 $2,160.00 $11,760.00 5 2018 $1,296.00 $13,056.00 6 2019 $777.60 $13,833.60 Switch* Straight-Line Test $3,750.00 $2,250.00 $1,800.00 $1,620.00 $1,944.00 Depreciation Accumulated Expense Depreciation $6,000.00 $6,000.00 $3,600.00 $9,600.00 $2,160.00 $11,760.00 $1,620.00 $13,380.00 $1,620.00 $15,000.00 3 **If a switch is appropriate then the straight-line depreciation expense will be used, otherwise the depreciation expense for double-declining balance will be used. D E F G B 1 Small Builders, Inc. Depreciation Schedule 2 3 Asset # 1002 4 Asset Chairs 5 Date acquired 1/1/2015 6 Cost 5,000.00 4000 7 Depreciation method S/L 8 Salvage value 1,000.00 9 Estimated useful life 5 10 Depreciation Accumulated Year Expense Depreciation 12 2015 $800.00 $800.00 13 2016 $800.00 $1,600.00 14 2017 $800.00 $2,400.00 15 2018 $800.00 $3,200.00 16 2019 $800.00 $4,000.00 17 $4,000.00 18 19 et # et e acquired - reciation method age value mated useful life 1003 Small Equipment 1/1/2015 $ 5,000.00 $ SYD 500.00 5 4,500.00 Year 2015 2016 2017 2018 2019 Depreciation Expense $1,500.00 $1,200.00 $900.00 $600.00 $300.00 Accumulated Depreciation $1,500.00 $2,700.00 $3,600.00 $4,200.00 $4,500.00