Fixed asset turnover ratio Financial statement data for years ending December 31 for Xiong Company follow: 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 fixed asset turnover ratio for Year 1 and Year 2 . Round your answers to one decimal place. b. Does the change in the fixed asset turnover ratio from Year 1 to Year 2 indicate a favorable or an unfavorable change? Depreciation by two methods A storage tank acquired at the beginning of the fiscal year at a cost of $144,000 has an estimated residual value of $13,000 and an estimated useful life of 4 years. 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. Openspreadsheet a. Determine the amount of annual depreciation by the straight-line method. Round your answer to the nearest dollar. 5 b. Determine the amount of depreciation for the first and second years computed by the double-declining-balance method. Do not round the double-declining balance rate, Round your answers to the nearest dollar