Can you help me solve this problem using excel? Machinery acquired new on January 1 at a cost of $80,000 was estimated to have a useful life of 10 years and a residual salvage value of $20,000. Straight-line depreciation was used. On January 1, following six full years of use of the machinery, management decided that the estimate of useful life had been too long and that the machinery would have to be retired after three years, that is, at the end of the ninth year of service. Under this revised estimate, the depreciation expense for the seventh year of use would be: