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 (Table 5-6). Test your spreadsheet by entering the data from Example 5-4 and Problem 9.
Depreciation Rates for 200% Declining Balance Using the Half-Year Convention
Compare your spreadsheet's solution to the answer to these problems.