On January 1, 2018, the Excel Delivery Company purchased a delivery van for $123,000. At the end of its five-year service life, it is estimated that the van will be worth $12,600. During the five-year period, the company expects to drive the van 368,000 miles. Required: Calculate annual depreciation for the five-year life of the van using each of the following methods. 1. Straight line. 2. Sum-of-the-years'-digits. 3. Double-declining balance. 4. Units of production using miles driven as a measure of output, and the following actual mileage: Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Calculate annual depreciation for the five-year life of the van using straight line method Straight-line per year Required Required 2 1. Straight line. 2. Sum-of-the-years'-digits. 3. Double-declining balance. 4. Units of production using miles driven as a measure of output, and the following actual mileage: Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Calculate annual depreciation for the five-year life of the van using sum-of-the-years' digits. (Do not round your intermediate calculations.) Year Depreciation 2018 2019 2020 2021 2022 $ Total Required 1 Required 3 1. Straight line. 2. Sum-of-the-years-digits. 3. Double-declining balance. 4. Units of production using miles driven as a measure of output, and the following actual mileage: Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Calculate annual depreciation for the five-year life of the van using double-declining balance. (Do not r calculations and round your final answers to nearest whole dollar.) Depreciation Year 2018 2019 2020 2021 2022 0 Total Required 2 Required 4 1. Straight line. 2. Sum-of-the-years'-digits. 3. Double-declining balance. 4. Units of production using miles driven as a measure of output, and the following actual mileage: Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Calculate annual depreciation for the five-year life of the van using units of production using miles driven as a meas output, and the following actual mileage. (Do not round your intermediate calculations.) Depreciation Year Miles 2018 48,000 58,000 2019 2020 48,000 2021 38,000 2022 32,000 Total 0 Required 3 Required 4