Question

In: Accounting

Question 2 On January 3, 2010, DL LLC purchased a truck for long-distance deliveries in Europe...

Question 2

On January 3, 2010, DL LLC purchased a truck for long-distance deliveries in Europe

The acquisition cost of the truck amounts to $ 100,000.

The truck is expected to have a salvage value of $20,000 at the end of 8-year useful life.

Task: Prepare a depreciation schedule for the truck using the diminishing balance method.

Solutions

Expert Solution

  • Diminishing balance method depreciation for each year is calculated using MS excel formula “=DB()”
  • Syntax to be used: =DB(100000,20000,8,Year)
  • Depreciation Schedule

Year

Beginning Book Value

Depreciation Expenses

Ending Book Value

Accumulated Depreciation

2010

$                                    100,000

$                  18,200

$                 81,800

$                 18,200

2011

$                                      81,800

$                  14,888

$                 66,912

$                 33,088

2012

$                                      66,912

$                  12,178

$                 54,734

$                 45,266

2013

$                                      54,734

$                    9,962

$                 44,773

$                 55,227

2014

$                                      44,773

$                    8,149

$                 36,624

$                 63,376

2015

$                                      36,624

$                    6,666

$                 29,958

$                 70,042

2016

$                                      29,958

$                    5,452

$                 24,506

$                 75,494

2017

$                                      24,506

$                    4,460

$                 20,046

$                 79,954


Related Solutions

Mahoney Moving Corporation purchased a new moving truck on January 2, 2014, for $95,000. The truck...
Mahoney Moving Corporation purchased a new moving truck on January 2, 2014, for $95,000. The truck was expected to have a useful life of 4 years and a residual value of $15,000. The company estimated that the moving truck would be driven for a total of 20,000 miles. It was driven for 5,000 miles in 2014, 6,000 miles in 2015, 4,000 miles in 2016, and 5,000 miles in 2017. The company’s fiscal year ends on December 31. Required: 1. Complete...
On January 2, 2015, Mullins Company purchased a delivery truck for $45,000 cash. The truck had...
On January 2, 2015, Mullins Company purchased a delivery truck for $45,000 cash. The truck had an estimated useful life of seven years and an estimated residual value of $3,000. Straight-line depreciation was used.   On September 1, 2019, the truck and $40,000 cash were exchanged for a new delivery truck that had a fair value of $70,000.    Assuming the transactions have commercial substance, circle the answer that is correct when recording the journal entry of the above asset exchange transaction....
QUESTION NO. 2: On Saturday, August 20th, John and Jeff purchased a food truck delivery truck...
QUESTION NO. 2: On Saturday, August 20th, John and Jeff purchased a food truck delivery truck for their recently started business from an auto auction in Pennsylvania. The name of their business was AB’s Food Delivery, Inc., which operates in Baltimore, Maryland. The truck was an older model white truck with no markings on the side; and because they just purchased the vehicle, they only had temporary tags. While driving from Pennsylvania to Maryland, it started to rain heavily and...
6. on January 3, 2018, fast delivery service purchased a truck at a cost of $95,000....
6. on January 3, 2018, fast delivery service purchased a truck at a cost of $95,000. Before placing the truck in service, fast spent $2,200 painting it, $500 replacing tires, and $11,300 overhauling the engine. The truck should remain in service for five years and have a residual value of $10,000. The truck annual mileage is expected to be 26,000 miles in each of the first four years in 19,750 miles in the fifth year- 123,750 Miles in total. And...
On January 3​, 2018​, Quick Delivery Service purchased a truck at a cost of $67,000. Before...
On January 3​, 2018​, Quick Delivery Service purchased a truck at a cost of $67,000. Before placing the truck in​ service, Quick spent $4,000 painting​ it, $1,500 replacing​ tires, and $2,200 overhauling the engine. The truck should remain in service for five years and have a residual value of $5,100. The​ truck's annual mileage is expected to be 20,000 miles in each of the first four years and 12,800 miles in the fifth year—92,800 miles in total. In deciding which...
Explanation of the long peace in Europe. 2 paragraphs
Explanation of the long peace in Europe. 2 paragraphs
Cambridge Company purchased a truck on January 1, 2018. Cambridge paid $15,000 for the truck. The...
Cambridge Company purchased a truck on January 1, 2018. Cambridge paid $15,000 for the truck. The truck is expected to have a $2,000 residual value and a 6-year life. Cambridge has a December 31 fiscal year end. Using the straight-line method, how much is the 2019 depreciation expense? (Enter only whole dollar values.)
Bridgeport Company purchased a delivery truck for 27,000 on January 1,2020. The truck has an expected...
Bridgeport Company purchased a delivery truck for 27,000 on January 1,2020. The truck has an expected salvage value 1,500, and is expected to be driven 102,000 miles over its estimated useful life of 10 years. Actual miles driven were 12,800 in 2020 and 14,300 in 2021 Compute depreciation expense for 2020 and 2021 using the straight-line method, the units-of-activity method, and the double-declining-balance method
On January 1, 2019, Rowley Company purchased a truck that cost $55,000. The truck had an...
On January 1, 2019, Rowley Company purchased a truck that cost $55,000. The truck had an expected useful life of 5 years and a $5,000 salvage value. The amount of depreciation expense on the 2019 Income Statement assuming that Rowley uses the straight line method is: Group of answer choices $10,000 $11,000 $5,000 None of these 2. On January 1, 2018, Rowley Company purchased a truck that cost $50,000. The truck had an expected useful life of 5 years and...
Skysong, Inc. purchased a delivery truck for $32,400 on January 1, 2019. The truck has an...
Skysong, Inc. purchased a delivery truck for $32,400 on January 1, 2019. The truck has an expected salvage value of $2,400, and is expected to be driven 100,000 miles over its estimated useful life of 8 years. Actual miles driven were 15,700 in 2019 and 12,900 in 2020. Compute depreciation expense for 2019 and 2020 using (1) the straight-line method, (2) the units-of-activity method, and (3) the double-declining-balance method. (Round depreciable cost per unit to 2 decimal places, e.g. 0.50...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT