The following data is available for equipment acquired at the beginning of the fiscal year: REQUIRED: a. Determine the amount of annual depreciation by the straight-line method. b. Determine the amount of depreciation for the first and second years computed by the double-declining-balance method. REQUIRED: a. Determine the amount of annual depreciation by the straight-line method. b. Determine the amount of depreciation for the first and second years computed 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. Equipenent accuired at the beginning of the fiscal year at 3 cost of $119,000 has an estimated rasidual value of $3,300 and an estimated useful life of 20 years. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analytis. and input your answers in the questions below a. Determine the amount of annual depees ation by the ftraight-line method. b. Dete mine the amount of depreciation for the first and second years computed by the double-decining-balance mithod