Asap i'll give like . please show the complete solution by using excel to get same answer. Screenshot the formula you used in excel in each row or column. Chapter 08, Problem 009 (Video Solution) A high-precision programmable router for shaping furniture components is purchased by Henredon for $170,000. It is expected to last 12 years and have a salvage value of $15,000. Calculate the depreciation deduction and book value for each year. Use double declining balance switching to straight line depreciation: EOY Depreciation Deduction Book Value 0 170000.00 1 28333.33 141666.67 N 23611.11 118055.56 3 19675.93 98379.63 4 16396.60 81983.02 5 13663.84 68319.19 6 11386.53 si 56932.66 7 9488.78 47443.88 8 6134.14 41309.74 9 6134.14 35175.60 10 6134.14 29041.46 11 6134.14 22907.31 12 6134.14 16773.17