Need help
On January 1 2018, the Excel Delivery Company purchased a delivery van for $87000. At the end of its five-year service life, it is estimated that the van will be worth $9.000. During the five-year period, the company expects to drive the van 260.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-cligits 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: 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 2 > On January 1, 2018, the Excel Delivery Company purchased a delivery van for $87000. At the end of its five-year service life. It is estimated that the van will be worth $9.000. During the five-year period, the company expects to drive the van 260,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 > Required 3 Required 4 Calculate annual depreciation for the five-year life of the ven using sum-of-the-years' digits. (Do not round your intermediate calculations.) Year Depreciation 2018 2019 2020 2021 2022 Total On January 1, 2018, the Excel Delivery Company purchased a delivery van for $87000. At the end of its five-year service life, it is estimated that the van will be worth $9.000 During the five-year period, the company expects to drive the van 260,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 Required 4 Calculate annual depreciation for the five-year life of the van using double-declining balance. (Do not round your intermediate calculations and round your final answers to nearest whole dollar) Year Depreciation 2018 2010 2020 2021 2022 Total On January 1, 2018, the Excel Delivery Company purchased a delivery van for $87,000. At the end of its five-year service life, it is estimated that the van will be worth $9,000. During the five-year period, the company expects to drive the van 260,000 miles Required: Colculote annual depreciation for the five-year life of the von 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: Required Required 3 Required 4 Calculate annual depreciation for the five-year life of the van using units of production using miles driven as a measure of output, and the following actual mileage. (Do not round your intermediate calculations.) Year 2018 2019 2020 2021 2022 Total Miles Depreciation 57 200 62,400 39,000 52,000 54600