Please answer in excel format.

CHAPTER 11 Capital Budgeting Cash Flows 499 1-8 Book value and taxes on sale of assets Troy Industries purchased a new machine 3 years ago for $80,000. It is being depreciated under MACRS with a 5-year recovery period. Assume a 21% tax rate. a. Use Table 4.2 to calculate the book value of the machine. b. Calculate the firm's tax liability if it sold the machine for each of the following amounts: $100,000; $56,000; $23,200; and $15,000