1 | Initial cost of new equipment | |
Particulars | Amount ($) | |
Purchase cost | 350000 | |
State sales tax | 29200 | |
Freight costs | 5600 | |
Insurance while in transit | 800 | |
Insurance after equipment is placed in service | 0 | |
Installation costs | 4000 | |
Insurance in first year of operation | 0 | |
Testing | 1400 | |
391000 |
Costs incurred once the asset is ready for its intended use cannot be capitalized (unless it results in revision of initially estimated future benefits). Hence, insurance expense after the asset is placed in service and first year of operations cannot be capitalized.
Depreciation schedule: | |||||||
Straight - line
method: Depreciation = (Original cost - Residual value) / Useful life = (391000 - 30000) / 10 = 36100 |
|||||||
Year | Opening Balance | Depreciation for the year | Closing Balance | Remarks | |||
2018 | 391000 | 12033 | 378967 | (For four months - 36100*(4/12)) | |||
2019 | 378967 | 36100 | 342867 | ||||
2020 | 342867 | 36100 | 306767 | ||||
2021 | 306767 | 36100 | 270667 | ||||
2022 | 270667 | 36100 | 234567 | ||||
2023 | 234567 | 36100 | 198467 | ||||
2024 | 198467 | 36100 | 162367 | ||||
2025 | 162367 | 36100 | 126267 | ||||
2026 | 126267 | 36100 | 90167 | ||||
2027 | 90167 | 36100 | 54067 | ||||
2028 | 54067 | 24067 | 30000 | (For four months - 36100*(8/12)) | |||
Sum of years of digits method: | |||||||
Year | Opening Balance | Depreciation for the year | Closing Balance | Depreciation Base | Remaining life of the asset | Depreciation fraction | Depreciation expense |
2018 | 391000 | 71090.91 | 319909 | 391000 | 10 | 10/55 | 71090.91 |
2019 | 319909 | 63981.82 | 255927 | 391000 | 9 | 9/55 | 63981.82 |
2020 | 255927 | 56872.73 | 199055 | 391000 | 8 | 8/55 | 56872.73 |
2021 | 199055 | 49763.64 | 149291 | 391000 | 7 | 7/55 | 49763.64 |
2022 | 149291 | 42654.55 | 106636 | 391000 | 6 | 6/55 | 42654.55 |
2023 | 106636 | 35545.45 | 71091 | 391000 | 5 | 5/55 | 35545.45 |
2024 | 71091 | 28436.36 | 42655 | 391000 | 4 | 4/55 | 28436.36 |
2025 | 42655 | 21327.27 | 21327 | 391000 | 3 | 3/55 | 21327.27 |
2026 | 21327 | 14218.18 | 7109 | 391000 | 2 | 2/55 | 14218.18 |
2027 | 7109 | 7109.09 | 0 | 391000 | 1 | 1/55 | 7109.09 |
2028 | 0 | 0 | 0 | 391000 | 0 | 0 | 0.00 |
55 | |||||||
Double -
declining method: Depreciation under straight line = 10% (Useful life is 10 years) Depreciation under double declining method = 20% on opening balance |
|||||||
Year | Opening Balance | Depreciation percentage | Depreciation for the year | Closing Balance | Remarks | ||
2018 | 391000 | 20% | 26066.67 | 364933 | For four months = 391000*20%*4/12 | ||
2019 | 364933 | 20% | 72986.67 | 291947 | |||
2020 | 291947 | 20% | 58389.33 | 233557 | |||
2021 | 233557 | 20% | 46711.47 | 186846 | |||
2022 | 186846 | 20% | 37369.17 | 149477 | |||
2023 | 149477 | 20% | 29895.34 | 119581 | |||
2024 | 119581 | 20% | 23916.27 | 95665 | |||
2025 | 95665 | 20% | 19133.02 | 76532 | |||
2026 | 76532 | 20% | 15306.41 | 61226 | |||
2027 | 61226 | 20% | 12245.13 | 48981 | |||
2028 | 48981 | 20% | 6530.80 | 42450 | For 8 months = 48981*20%*8/12 | ||
Unit production method | |||||||
Year | Opening Balance | Depreciation base | Number of units produced | Depreciation fraction | Depreciation for the year | Closing Balance | |
2018 | 391000 | 391000 | 5000 | 5000/737000 | 2653 | 388347 | |
2019 | 388347 | 391000 | 60000 | 60000/737000 | 31832 | 356516 | |
2020 | 356516 | 391000 | 70000 | 70000/737000 | 37137 | 319379 | |
2021 | 319379 | 391000 | 80000 | 80000/737000 | 42442 | 276936 | |
2022 | 276936 | 391000 | 80000 | 80000/737000 | 42442 | 234494 | |
2023 | 234494 | 391000 | 85000 | 85000/737000 | 45095 | 189399 | |
2024 | 189399 | 391000 | 82000 | 82000/737000 | 43503 | 145896 | |
2025 | 145896 | 391000 | 81000 | 81000/737000 | 42973 | 102923 | |
2026 | 102923 | 391000 | 79000 | 79000/737000 | 41912 | 61011 | |
2027 | 61011 | 391000 | 75000 | 75000/737000 | 39790 | 21221 | |
2028 | 21221 | 391000 | 40000 | 40000/737000 | 21221 | 0 | |
737000 |
CSU Enterprises purchased new equipment for $350,000, terms f.о.b. shipping point. Other costs co...
On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has an estimated useful life of 4 years or 100,000 hours and residual value of $30,000. The machine will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000 hours in year 3 and 10,000 hours in year 4. Requirements: IN EXCEL FORMAT- Prepare a depreciation schedule using each of the three methods: Straight line, Units of Production and...
On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has an estimated useful life of 4 years or 100,000 hours and residual value of $30,000. The machine will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000 hours in year 3 and 10,000 hours in year 4. Requirements: Prepare a depreciation schedule using each of the three methods: Straight line, Units of Production and Double Declining Balance.
4. Watmore Ltd. purchased, for cash, factory equipment with an invoice price of $80,000. Other costs incurred were freight costs, $1,600; installation, wiring and foundation, $13,500; material and labour costs in testing equipment, $500; oil lubricants and supplies to be used while operating the equipment, $750; fire insurance policy covering equipment, $1,400. The equipment is estimated to have a $10,000 residual value at the end of its 8-year useful service life. (8 marks) Instructions (a) Calculate the cost of the...
1) Kansas Enterprises purchased equipment for $79,000 on January 1, 2021. The equipment is expected to have a five-year service life, with a residual value of $6,900 at the end of five years. Using the straight-line method, depreciation expense for 2021 would be: 2) Kansas Enterprises purchased equipment for $80,500 on January 1, 2021. The equipment is expected to have a ten-year service life, with a residual value of $6,450 at the end of ten years. Using the straight-line method,...
Crane Company purchased equipment on March 27, 2018, at a cost of $228,000. Management is contemplating the merits of using the diminishing-balance or units-of-production method of depreciation instead of the straight-line method, which it currently uses for other equipment. The new equipment has an estimated residual value of $4,000 and an estimated useful life of either four years or 80,000 units. Demand for the products produced by the equipment is sporadic so the equipment will be used more in some...
Question 13 Cullumber Company purchased equipment on March 27, 2018, at a cost of $328,000. Management is contemplating the merits of using the diminishing-balance or units-of-production method of depreciation instead of the straight-line method, which it currently uses for other equipment. The new equipment has an estimated residual value of $8,000 and an estimated useful life of either four years or 80,000 units. Demand for the products produced by the equipment is sporadic so the equipment will be used more...
*Problem 9-4A a-b (Part Level Submission) Blossom Company purchased equipment on March 27, 2018, at a cost of $272,000. Management is contemplating the merits of using the diminishing-balance or units-of-production method of depreciation instead of the straight- line method, which it currently uses for other equipment. The new equipment has an estimated residual value of $8,000 and an estimated useful life of either four years or 80,000 units. Demand for the products produced by the equipment is sporadic so the...
The FraserRiver Company has purchased a new piece of factory equipment on January 1, 2018, and wishes to compare three depreciation methods: straight-line, double-declining-balance, and units-of-production The equipment costs $400,000 and has an estimated useful life of four years, or 8,000 hours. At the end of four years, the equipment is estimated to have a residual value of $20,000. Requirements 1. Use Excel to prepare depreciation schedules for straight-line, double-declining-balance, and units-of-production methods. Use cell references from the Data table....
On April 2, 2017, Victor, Inc. acquired a new piece of filtering equipment. The cost of the equipment was $400,000 with a residual value of $30,000 at the end of its estimated useful lifetime of 5 years. Assume that in its financial statements, Victor uses straight-line depreciation and the half-year convention. Depreciation recognized on this equipment in 2017 and 2018 will be: Multiple Choice $80,000 in 2017 and $64,000 in 2018. $30,000 in 2017 and $74,000 in 2018. $37,000 in...
Carla Vista Co. purchased equipment on March 27,2018, at a cost of $248,000. Management is contemplating the merits of using the diminishing- balance or units-of-production method of depreciation instead of the straight-line method, which it currently uses for other equipment. The new equipment has an estimated residual value of $8,0o0 and an estimated useful life of either four years or 80,000 units. Demand for the products produced by the equipment is sporadic so the equipment will be used more in...