Question

In: Finance

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.

Solutions

Expert Solution

(a) double-declining balance method

In double-declining balance method, depreciation is charged at twice the rate of depreciation as per the straight line method.

double-declining balance method = 2*cost of the asset*depreciation rate

depreciation rate = (1/useful life)*100 = (1/5)*100 = 0.2*100 = 20%

So depreciation will charged on beginning balance of asset at 20%*2 = 40% rate every year till asset's ending balance is equal to asset's salvage value. 5th year depreciation of useful life will difference between beginning book value of year 5 - salvage value.

Year Beginning book value depreciation Ending book value
1 $33,850.00 $13,540.00 $20,310.00
2 $20,310.00 $8,124.00 $12,186.00
3 $12,186.00 $4,874.40 $7,311.60
4 $7,311.60 $2,924.64 $4,386.96
5 $4,386.96 $3,136.96 $1,250.00

Calculation

(b) sum-of-the-year's digit method

This is an accelerated method depreciation where most of the depreciation is charged in the initial years.

first we calculate value to be depreciated as cost of the asset - salvage value = $33,850 - $1,250 = $32,600

now we calculate sum of useful life and discount factors as below:

Sum of useful life = 5+4+3+2+1 = 15

at the beginning of 1st year useful life is 5 years. at the beginning of 2nd year useful life is 4 years and so on.

Discount factors:

Year 1 - 5/15

Year 2 - 4/15

Year 3 - 3/15

Year 4 - 2/15

at year 5, depreciation will be the remaining balance i.e. the beginning book value of year 5 so that year 5 ending book value is zero.

Year Beginning book value depreciation Ending book value
1 $32,600.00 $10,866.67 $21,733.33
2 $21,733.33 $8,693.33 $13,040.00
3 $13,040.00 $6,520.00 $6,520.00
4 $6,520.00 $4,346.67 $2,173.33
5 $2,173.33 $2,173.33 $0.00

Calculation


Related Solutions

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...
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, 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...
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...
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,...
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...
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
Danube recently acquired a delivery van for $22,300 paying cash. Danube projects a 4 year useful...
Danube recently acquired a delivery van for $22,300 paying cash. Danube projects a 4 year useful service life and a remaining residual value on the delivery van of $2,200. Danube expects to drive the van 108,000 miles during the useful service life. Please compute the annual depreciation for the 4 year life of the delivery van for the double-declining method End of Year Amounts Year Depreciation Expense Accumulated Depreciation Book Value 1 2 3 4
Danube recently acquired a delivery van for $24,200 paying cash. Danube projects a 4 year useful...
Danube recently acquired a delivery van for $24,200 paying cash. Danube projects a 4 year useful service life and a remaining residual value on the delivery van of $2,200. Danube expects to drive the van 106,000 miles during the useful service life. Please compute the annual depreciation for the 4 year life of the delivery van for each of these methods: 1. Straight-line Depreciation expense 2. Double-declining-balance. (Round your depreciation rate to 2 decimal places. Round your final answers to...
Week 10 Nevertire Ltd purchased a delivery van costing $52,000. It is expected to have a...
Week 10 Nevertire Ltd purchased a delivery van costing $52,000. It is expected to have a residual value of $12,000 at the end of its useful life of 4 years or 200,000 kilometres. Ignore GST. Required: a) Assume the van was purchased on 1 July 2019 and that the accounting period ends on 30 June. Calculate the depreciation expense for the year 2019–20 using each of the following depreciation methods  straight-line  diminishing balance (depreciation rate has been calculated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT