In 2006, your company purchased a front-end loader for $150,000, a dump truck for $85,000, and a dumping trailer (pup) for the dump truck for $38,000. In 2007, your company purchased two side-dump...

In 2006, your company purchased a front-end loader for $150,000, a dump truck for $85,000, and a dumping trailer (pup) for the dump truck for $38,000. In 2007, your company purchased two side-dump trailers for $65,000 each and two tractors to pull the side-dump trailers for $68,000 each. In December of 2008, your company purchased a dump truck for $87,000. Determine the depreciation allowed for tax purposes for the 2008 tax year. The tax year runs from January to December. Ignore all Section 179 deductions. Hint: The tractors have a different recovery period than the rest of the equipment.

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