In: Accounting
Exercise 11-07
Your answer is partially correct. Try again. | |
Wildhorse Industries presents you with the following
information.
Complete the table for the year ended December 31, 2022. The
company depreciates all assets using the half-year convention.
(Round answers to 0 decimal places, e.g.
45,892.)
Description |
Date |
Cost |
Salvage |
Life |
Depreciation |
Accumulated |
Depreciation |
|||||||||||||
Machine A | 2/12/20 | $168,150 | $18,880 | 10 | (a) |
DDBSLSYD |
$39,353 | (b) | $ | |||||||||||
Machine B | 8/15/19 | (c) | 24,780 | 5 | SL | 34,220 | (d) | |||||||||||||
Machine C | 7/21/18 | 89,600 | 23,500 | 8 | DDB | (e) | (f) | |||||||||||||
Machine D | (g) |
10/12/1910/12/2010/12/21 |
258,420 | 81,420 | 5 | SYD | 82,600 | (h) |
Description | Date | Cost | Salvage | Life | Depreciation | Accumulated | Depreciation | |||||
Purchased | Value | in Years | Method | Depreciation to | for 2022 | |||||||
Machine A | 02-12-2020 | $168,150 | $18,880 | 10 | (a) | SYD | $39,353 | (b) | $23,069.00 | |||
Machine B | 8/15/19 | (c) | $ 93,220.00 | 24,780 | 5 | SL | 34,220 | (d) | $13,688.00 | |||
Machine C | 7/21/18 | 89,600 | 23,500 | 8 | DDB | (e) | $ 56,525.00 | (f) | $ 8,269.00 | |||
Machine D | (g) | 10-12-2020 | 2,58,420 | 81,420 | 5 | SYD | 82,600 | (h) | $41,300.00 |
Working:
a) | |
Machine A : | |
Straight Line Method : | |
Depreciation for Year 2020 | 7463.5 |
Depreciation fro year 2021 | 29854 |
Accumulated Depreciation | 37317.5 |
Sum of Year Digit Method | |
Total Sum of 10 Year = | 55 |
=10+9+8+7+6+5+4+3+2+1 | |
Cost | 149270 |
Year 2020 = | 13570 |
Year 2021 | 25783 |
Accumulated Depreciation | 39353 |
b) | |
Depreciation for year 2022 | 23069 |
c) | |
Machine B : | |
Total Accumulated Depreciation = | $ 34,220.00 |
Total Period for which depreciation is accumulated | |
(Half of 2019, 2020,2021) | 2.5 years |
Depreciation for 5 Year | $ 68,440.00 |
Add: Salvage Value | $ 24,780.00 |
Cost of machine | $ 93,220.00 |
d) | |
Deprciation for Year 2022 | |
Cost of Machine | $ 93,220.00 |
Salvage Value | $ 24,780.00 |
Depreciable Value | $ 68,440.00 |
Depreciation for year
2022 (68440/5) |
$ 13,688.00 |
e) | |
Machine C | |
Lfe of machine | 8 Years |
Depreciation Rate | 25% |
(100/8)*2 | |
Depreciation for 2018 (89600*25%/2) |
$ 11,200.00 |
Depreciation for 2019 (89600-11200)*25% |
$ 19,600.00 |
Depreciation for 2020 (89600-11200-19600)*25% |
$ 14,700.00 |
Depreciation for 2021 (89600-11200-19600-14700)*25% |
$ 11,025.00 |
Total Accumulated Depreciation upto 2021 | $ 56,525.00 |
f) | |
Depreciation for 2022 (89600-11200-19600-14700-11025)*25% |
$ 8,268.75 |
g) | |
Machine D | |
Sum of Years Digit method | |
Total sum of Year | 15 |
=5+4+3+2+1 | |
Cost | $ 2,58,420.00 |
Less: Salvage Value | $ 81,420.00 |
Depreciable Value | $ 1,77,000.00 |
Depreciation for Year 1 ((177000*5/15)*50%) |
$ 29,500.00 |
Depreciation for Year 2 ((177000*5/15*1/2)+(177000*4/15*1/2)) |
$ 53,100.00 |
Accumulated Depreciation | $ 82,600.00 |
Hence Machine is purchased 2 years from Year 2021 i.e machine is purchased in Year 2020 | |
h) | |
Depreciation for Year
2022 ((177000*4/15*1/2)+(177000*3/15*1/2)) |
$ 41,300.00 |