Question

In: Accounting

On January 1, 2021, the Excel Delivery Company purchased a delivery van for $46,000. At the...

On January 1, 2021, the Excel Delivery Company purchased a delivery van for $46,000. At the end of its five-year service life, it is estimated that the van will be worth $4,000. During the five-year period, the company expects to drive the van 165,000 miles.

Required:
Calculate annual depreciation for the five-year life of the van using each of the following methods.

rev: 05_15_2019_QC_CS-168776, 11_22_2019_QC_CS-191707

Exercise 11-1 (Algo) Part 1

1. Straight line.


2. Double-declining balance. (Round your answers to the nearest whole dollar amount.)

Years Depreciatiation

2021

2022

2023

2024

2025

3. Units of production using miles driven as a measure of output, and the following actual mileage: (Do not round intermediate calculations.)
miles Depreciation

2021 35,000

2022 37,000

2023 28,000

2024 33,000

2025 34,000

Solutions

Expert Solution

1. With the straight line depreciation method, the value of an asset is reduced uniformly over each period until it reaches its salvage value. Straight line depreciation is the most commonly used and straightforward depreciation method for allocating the cost of a capital asset. It is calculated by simply dividing the cost of an asset, less its salvage value, by the useful life of the asset.

Computation of Depreciation as per SLM Method:

Particulars Amount
$
Purchase Price A 46,000
Estimated Salvage value at the end of 5 Years B 4,000
Value to be depreciation in its useful life C=A-B 42000
Useful Life of Equipment (in Years) D 5
Depreciation value per year as per SLM E=C/D 8400

Therefore, depreciation for every year:

Year Depreciation
$
2021                8,400
2022                8,400
2023                8,400
2024                8,400
2025                8,400

2. The double declining balance depreciation method is an accelerated depreciation method that counts as an expense more rapidly when compared to straight-line depreciation that uses the same amount of depreciation each year over an asset's useful life.

Computation of Depreciation as per Double Declining Method:

Depreciation rate = 100/Useful life *2 = 100/5 *2= 40%

Year Book Value Depreciation Rate Depreciation Net Book Value
A B C=A*B D=A-C
2021 46,000 40% 18400 27,600
2022 27,600 40% 11040 16,560
2023 16,560 40% 6624 9,936
2024 9,936 40% 3974 5,962
2025 5,962 40% 1962* 4,000

* As the salvage value is $4,000, if depreciation would have been more than $1,962 Net Book Value would have been below $4,000. Therefore, depreciation is taken as $1,962.

Therefore, depreciation for every year:

Year Depreciation
$
2021                         18,400
2022                         11,040
2023                           6,624
2024                           3,974
2025                           1,962

3. The unit of production method is a method of depreciation of the value of an asset over time. It becomes useful when an asset's value is more closely related to the number of units it produces than the number of years it is in use. This method results in greater deductions being taken for depreciation in years when the asset is heavily used.

Computation of Depreciation as per Production using miles :

Depreciation rate per mile used = Depreciable value/Estimated Miles = ($46,000-$4,000)/165,000 = $0.2545

Year Actual Miles Depreciation Rate per mile Depreciation Net Book Value
A B C=A*B
2021 35,000 0.2545                8,909 37,091
2022 37,000 0.2545                9,418 27,673
2023 28,000 0.2545                7,127 20,545
2024 33,000 0.2545                8,400 12,145
2025 34,000 0.2545                8,145* 4,000

* As the salvage value is $4,000, if depreciation would have been more than $8,145 Net Book Value would have been below $4,000. Therefore, depreciation is taken as $8,145.

Therefore, depreciation for every year:

Year Depreciation
$
2021                           8,909
2022                           9,418
2023                           7,127
2024                           8,400
2025                           8,145

Related Solutions

On January 1, 2018, the Excel Delivery Company purchased a delivery van for $52,000. At the...
On January 1, 2018, the Excel Delivery Company purchased a delivery van for $52,000. At the end of its five-year service life, it is estimated that the van will be worth $4,000. During the five-year period, the company expects to drive the van 150,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...
On January 1, 2018, the Excel Delivery Company purchased a delivery van for $57,000. At the...
On January 1, 2018, the Excel Delivery Company purchased a delivery van for $57,000. At the end of its five-year service life, it is estimated that the van will be worth $5,400. During the five-year period, the company expects to drive the van 172,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...
On January 1, 2006 the Excel Delivery Company purchased a delivery van for $65,000. Useful life...
On January 1, 2006 the Excel Delivery Company purchased a delivery van for $65,000. Useful life is 5 years and it has a salvage value of $15,000 The company expects to drive the van 125,000 miles The following is the actual miles driven 2006 – 40,000 miles 2007 – 35,000 miles 2008 – 25,000 miles 2009 – 21,000 miles 2010 – 11,000 miles Required – Calculate annual depreciation for the five year life of the van using each of the...
1.) Carrie Heffernan Company purchased a delivery van on January 1, 2016, for $50,000. The van...
1.) Carrie Heffernan Company purchased a delivery van on January 1, 2016, for $50,000. The van was expected to remain in service 4 years (or 100,000 miles) and has a residual value of $5,000. The van traveled 30,000 miles the first year, 25,000 miles the second year, and 22,500 miles in the third and fourth years. Required: 1. Prepare a schedule of depreciation expense per year for the first four years of the asset's life using the (a) straight-line method,...
Speedy delivery company on Jan. 1 2021, purchased a van for $20,000. to complete the purchase,...
Speedy delivery company on Jan. 1 2021, purchased a van for $20,000. to complete the purchase, the company also incurred $800 shipping cost and $1,200 sales tax. Speedy estimates that at the end of its the four- year service life the van will be worth 4,000. during the four year period, the company expects to drive the van 100,000 miles. actual miles driven each year were 32,000 miles in year 1; 35,000 in year 2 and 27,000 in year 3...
A company purchased a new delivery van at a cost of $60,000 on July 1. The...
A company purchased a new delivery van at a cost of $60,000 on July 1. The delivery van is estimated to have a useful life of 6 years and a salvage value of $4800. The company uses the straight line method of depreciation. How much depreciation expense will be recorded for the van during the first year ended December 31? a. $5,000 b. $6,480 c. $4,600 d. $9,200 e. $5,600
Ivan Manufacturing purchased equipment and a delivery van on January 1, 2020. The equipment cost $95,000...
Ivan Manufacturing purchased equipment and a delivery van on January 1, 2020. The equipment cost $95,000 and has an estimated useful life of 8 years with a residual value of $10,000. The delivery van cost $125,000 and has an estimated life of 5 years or 200,000 kilometres and a residual value of $20,000. The delivery truck is expected to be driven 25,000 and 50,000 kilometres in 2019 and 2020, respectively. Required Ivan has decided to depreciate the equipment using either...
Ron's Don't Wait Inc (RDW) purchased a delivery van on July 1, 2019. The Van cost...
Ron's Don't Wait Inc (RDW) purchased a delivery van on July 1, 2019. The Van cost $65,000 and has an estimated life of 5 years or 200,000 kms and a residual value of $5,000. RDW uses exact months for it's depreciation. RDW estimates the Van will be driven 22,000 kms in 2019, 55,000 in 2020, 48,000 in 2021, 65,000 in 2022, and 25,000 in 2023. Required Prepare the following depreciation schedule for all 5 years for each of the following...
ABC Delivery Company purchased a new delivery truck on January 1 with an original cost of...
ABC Delivery Company purchased a new delivery truck on January 1 with an original cost of $50,000. The company estimates it will use the truck for 5 years and drive a total of 100,000 miles. It plans to sell the truck at the end of the five years for $5,000. During the first year, the truck was driven 15,000 miles. What is the depreciation for the first year using the DoubleDeclining Balance method? $10,000 $18,000 $7,500 $20,000 $6,750 $9,000
The Shop Right Shopping Complex purchased a delivery van for $33,850. The van has a useful...
The Shop Right Shopping Complex purchased a delivery van for $33,850. The van has a useful life of five years and an estimated salvage value at $1,250. Prepare a depreciation schedule for the van using the (a) double-declining balance method (b) sum-of-the-year's digit method.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT