please workout in excel and dhow all your work in excel.

9.15 In 2018, you purchased a spindle machine (seven-year MACRS property class) for $28,000, which you placed in service in January. Compute the book value at the end of year 5 for the machine. (a) $4,499 (b) $5,499 (c) $6,247 (d) $8,746