Straight-line depreciation A refrigerator used by a wholesale warehouse has a cost of $86,000, an estimated residual value of $6,500, and an estimated useful life of 5 years. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answer in the question below. Depreciation by two methods A Kubota tractor acquired on January 8 at a cost of $81,000 has an estimated useful life of 5 years. Assuming that it will have no residual value. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the depreciation for each of the first two years by the straight-line method. Round your answers to the nearest dollar. b. Determine the depreciation for each of the first two years by the double-declining-balance method. Round your answers to the nearest dollar. REQUIRED: What is the amount of the annual depreciation computed by the straight-line method? Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv2 for grading. Depreciation by two methods REQUIRED: Assuming that it will have no residual value, determine the depreciation for each of the first 2 years by the straight-line method and by the double-declining-balance method. Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv2 for grading