eBook Show Me How Ofice 365 Calculator 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 8 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 X1 Open spreadsheet What is the amount of the annual depredation computed by the straight line method Round ent/take Assignment Main.do?invokera&takeAssignmentSessionLocatorinprogressfalse Show Me How Office 365 Calculator Depreciation by two methods A storage tank acquired at the beginning of the fiscal year at a cost of $104,400 has an estimated residual value of $15,000 and an estimated useful of 4 years. This information has been collected in the Microsoft Excel Online file Open the spreadsheet, perform the required analysis, and input you answers in the questions below. Open spreadsheet a. Determine the amount of annual relation by the straight the method. Round your answer to the nearest dollar, b. Determine the amount of depreciation for the first and second years computed by the double-declining balance method. Do not round the double dening balance at Round your answer to the rest Depreciation (previous