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 theseproblems.

YEAR 3 YEARS (%) 33.33 44.45 14.81 7.41 NA 5 YEARS (%) 20.00 32.00 19.20 11.52 11.52 5.76 10 YEARS (%) 7 YEARS (%) 14.29 24.49 17.49 12.49 8.93 8.92 8.93 4.46 NA NA NA 10.00 18.00 14.40 11.52 9.22 7.37 6.55 6.55 6.56 6.55 3.28 2 4 NA 10 NA NA NA