solve using excel step by step

Prob. 2 An Industrial robot is purchased for $120,000 which will have a useful life of 10 years. The depreciation of this equipment follows the 7-year MACRS schedule. Calculate the Deprecitalon value in Year 3 and the Book Value in year 5. MACRS Year Year 7-year 1 2 3 4 5 6 7 8 9 10 14.29% 24.49% 17.49% 12.49% 8.93% 8.92% 8.93% 4.46% 2 3 4 5 16