1. A piece of office equipment is purchased for $110,000 and has an estimated salvage value of $10,000 at the end of the recovery period. Using excel, prepare a depreciation schedule for the piece of equipment using ONLY the straight line method with a recovery period of _____ years. For tax purposes, the IRS has stated this specific piece of equipment has a standard recovery period of how many years? (Fill in the blank). 2. Using excel, prepare a depreciation schedule for the piece of equipment described in #1 using ONLY the 200% declining-balance depreciation method. 3. Compare/Contrast the the two depreciation schedules defined in #1 and #2. 4. Using excel, use the 200% declining-balance depreciation switching to straight-line depreciation when the annual straight-line depreciation rate exceeds the depreciation calculated by the 200% declining-balance method for the piece of equipment described in #1.