Modify the spreadsheet in Sidebar 5-2 to handle recovery periods up to 10 years. Test your spreadsheet by entering the data from Example 5-2 andProblems 3 and 4. Compare your spreadsheet’s solution to...

Modify the spreadsheet in Sidebar 5-2 to handle recovery periods up to 10 years. Test your spreadsheet by entering the data from Example 5-2 andProblems 3 and 4. Compare your spreadsheet’s solution to the answer to these problems. Hint: Use the IF function to discontinue the depreciation and book value at the end of the recovery period.