10.3

eBook Show Me How Ortoe 365 Panthem Partial-year depreciation Equipment acquired at a cost of $107,000 has an estimated residual value of $6,000 and an estimated useful life of years. It was placed in service on May 1 of the current fiscal year, which ends on December 31. 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, x 1 Open spreadsheet a. Determine the depreciation for the current fiscal year and for the following fiscal year by the straight-line method. Round your answers to the nearest dollar Depreciation Year 1 $ 9,469 X Year 2 $ 12,625 b. Determine the depreciation for the current fiscal year and for the following fiscal year by the double-declining balance method. Do not round the double declining balance rate. Round your answers to the nearest dollar Depreciation Year 1 $ 20,063 X Year 2 $ 21,734 X