Answer-
Depreciation Schedule-Double Declining Balance Method | |
YEAR | Depreciation |
$ | |
2021 | 12000 |
2022 | 7200 |
2023 | 4320 |
2024 | 2592 |
2025 | 888 |
Totals | $27000 |
Explanation-Double Declining balance depreciation is calculated using the following formula=
Depreciation = Depreciation Rate * Book Value of Asset |
Depreciation rate is given by the following formula:
Depreciation Rate = Accelerator *Straight Line Rate |
Straight-line Depreciation Rate = 1/5 = 0.20 = 20%
Declining Balance Rate =
2*20% = 40%
Depreciation for Year 2021 = $30000*40% =$12000
Book value at the end of year 2021 = $30000-$12000 =$18000
Depreciation for Year 2022 = $18000*40% = $7200
Book value at the end of year 2022 = $18000-$7200 =$10800
Depreciation for Year 2023 = $10800*40% = $4320
Book value at the end of year 2023 = $10800-$4320 =$6480
Depreciation for Year 2024 = $6480*40% = $2592
Book value at the end of year 2024 = $6480-$2592 = $3888
Depreciation for Year 2024 = $3888 - $3000 = $888
Check my work Required information (The following information applies to the questions displayed below.) Part 2...
Please do part 2+3
Check Required information The following information applies to the questions displayed below) On January 1, 2021, the Excel Delivery Company purchased a delivery van for $99,000. At the end of its five-year service life, it is estimated that the van will be worth $10.200. During the five-year period, the company expects to drive the van 296.000 miles Required: Calculate annual depreciation for the five-year life of the van using each of the following methods 2. Double-declining...
Required information [The following information applies to the questions displayed below.] On January 1, 2021, the Excel Delivery Company purchased a delivery van for $129,000. At the end of its five-year service life, it is estimated that the van will be worth $13,200. During the five-year period, the company expects to drive the van 386,000 miles. Required: Calculate annual depreciation for the five-year life of the van using each of the following methods. 2. Double-declining balance. (Round your answers to...
Required information The following information applies to the questions displayed below.] On January 1, 2021, 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 Straight-line per year On...
Required information [The following information applies to the questions displayed below.] On January 1, 2021, the Excel Delivery Company purchased a delivery van for $75,000. At the end of its five-year service life, it is estimated that the van will be worth $7,800. During the five-year period, the company expects to drive the van 224,000 miles. Required: Calculate annual depreciation for the five-year life of the van using each of the following methods. 1. Straight line. Straight-line per year 2....
Required information [The following information applies to the questions displayed below.) On January 1, 2021, 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. 2. Double-declining balance. (Round your answers to...
Required information The following information applies to the questions displayed below.) On January 1, 2021, the Excel Delivery Company purchased a delivery van for $147,000. At the end of its five-year service life, it is estimated that the van will be worth $15,000. During the five-year period, the company expects to drive the van 440,000 miles. Required: Calculate annual depreciation for the five-year life of the van using each of the following methods. 1. Straight line. Straight-line per year 2....
Required information [The following information applies to the questions displayed below On January 1, 2021, the Excel Delivery Company purchased a delivery van for $153,000. At the end of its five-year service life, it is estimated that the van will be worth $15,600. During the five-year period, the company expects to drive the van 458,000 miles Required: Calculate annual depreciation for the five-year life of the van using each of the following methods 2. Double-declining balance. (Round your answers to...
Required information The following information applies to the questions displayed below.) On January 1, 2021, the Excel Delivery Company purchased a delivery van for $105,000. At the end of its five. year service life, it is estimated that the van will be worth $10,800. During the five-year period, the company expects to drive the van 314,000 miles. Required: Calculate annual depreciation for the five-year life of the van using each of the following methods. 1. Straight line. Straight-line $ 18,840...
Required information (The following information applies to the questions displayed below) On January 1, 2021, the Excel Delivery Company purchased a delivery van for $153,000. At the end of its five-year service life, it is estimated that the van will be worth $15,600. During the five-year period, the company expects to drive the van 458,000 miles. Required: Calculate annual depreciation for the five-year life of the van using each of the following methods. 2. Double-declining balance. (Round your answers to...
Required information (The following information applies to the questions displayed below.) On January 1, 2021, 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: Calculate annual depreciation for the five-year life of the van using each of the following methods. 3. Units of production using miles driven...