B c D 1 Straight-line depreciation 2 3 DATA 4 Cost $83,000 5 Estimated residual value $6,800 6 Estimated useful life (in years) 5 Using formulas and cell references, perform the required analysis, and input your answer into the Amount column. Transfer the numeric result 8 for the green entry cell (B11) into the appropriate field in CNOWV2 for Arndinn 7 9 10 Amount Formula 11 Annual depreciation (Straight-line) 12 Straight-line depreciation A refrigerator used by a wholesale warehouse has a cost of $83,000, an estimated residual value of $6,800, 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. Open spreadsheet What is the amount of the annual depreciation computed by the straight-line method? Round your answer to the nearest dollar $ $