Modify the spreadsheet in Sidebar 5-4 to handle 3-, 5-, 7-, and 10-year recovery periods using the depreciation rates for the 200% declining-balance method and the half-year convention (see Table...

Modify the spreadsheet in Sidebar 5-4 to handle 3-, 5-, 7-, and 10-year recovery periods using the depreciation rates for the 200% declining-balance method and the half-year convention (see Table 5-6). Test your spreadsheet by entering the data from Example 5-4 and Problem 9. Compare your spreadsheet’s solution to the answer to these problems. Hint: Use the IF function to select the depreciation rate and discontinue the book value at the end of the recovery period.