please workout in excel and show all of your work.

9s5 A company purchased a drill press priced at $170,000 in year 0. The company ad- ditionally incurred $30,000 for site preparation and labor to install the machine. The drill press was classified as a seven-year MACRS class property. The company is considering selling the drill press for $70,000 at the end of year 4. Compute the book value at the end of year 4 that should be used in calculating the taxable gains. (a) $62,480 (b) $53.108 (c) $63,725 (d) $74.970