*P11-12 (L01,6) EXCEL (Depreciation—SL, DDB, SYD, Act., and MACRS) On January 1, 2016, Locke Company, a small machine-tool manufacturer, acquired for $1,260,000 a piece of new industrial equipment. The new equipment had a useful life of 5 years, and the salvage value was estimated to be $60,000. Locke estimates that the new equipment can produce 12,000 machine tools in its first year. It estimates that production will decline by 1,000 units per year over the remaining useful life of the equipment.
The following depreciation methods may be used: (1) straight-line, (2) double-declining-balance, (3) sum-of-the-years’-digits, and (4) units-of-output. For tax purposes, the class life is 7 years. Use the MACRS tables for computing depreciation.
Instructions
(a) Which depreciation method would maximize net income for financial statement reporting for the 3-year period ending December 31, 2018? Prepare a schedule showing the amount of accumulated depreciation at December 31, 2018, under the method selected. Ignore present value, income tax, and deferred income tax considerations.
(b) Whichdepreciationmethod(MACRSoroptionalstraight-line)wouldminimizenetincomeforincometaxreportingfor the 3-year period ending December 31, 2018? Determine the amount of accumulated depreciation at December 31, 2018. Ignore present value considerations.
a. Depreciation under staright line would maximise net income for financial statement for the 3-year period ending december 31 2018, depreciation is minimum under the method, Detailed calculation is as under
Straight line method of depreciation | Toal of 3 years depreciation | |||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
1260000-60000/5 | 240000 | 240000 | 240000 | 240000 | 240000 | 720000 |
Double Declining balances | ||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
(100%/5)*2 | 504000 | 302400 | 181440 | 90720 | 72576 | 987840 |
Balance | 756000 | 453600 | 272160 | 181440 | 108864 | |
Sum of digit | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Depriciation | 420000 | 224000 | 123200 | 65707 | 28473 | 767200 |
Depriciation rate | (5/15) | (4/15) | (3/15) | (2/15) | (1/15) | |
Balance | 840000 | 616000 | 492800 | 427093 | 398620 | |
Unit of output | ||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
Output | 12000 | 11000 | 10000 | 9000 | 8000 | |
Depriciation | 288000 | 264000 | 240000 | 216000 | 192000 | 792000 |
Rate of depreciation 25/p.u |
b. Straight line method would also minimise the income tax for 3 year period, detailed calculation is as under
Straight line method of depreciation | ||||
Year 1 | Year 2 | Year 3 | Total of 3 year depreciation | |
1260000-60000/5 | 171429 | 171429 | 171429 | 514286 |
Double Declining balances | ||||
Year 1 | Year 2 | Year 3 | ||
(100%/7)*2 | 360000 | 257143 | 183673 | 800816 |
Balance | 900000 | 642857 | 459184 | |
Sum of digit | Year 1 | Year 2 | Year 3 | |
Depriciation | 315000 | 202500 | 132589 | 650089 |
Depriciation rate | (7/28) | (6/28) | (5/28) | |
Balance | 945000 | 742500 | 609911 | |
Unit of output | ||||
Year 1 | Year 2 | Year 3 | ||
Output | 12000 | 11000 | 10000 | |
Depriciation | 228571 | 209524 | 190476 | 628571 |
Rate of depreciation 25/p.u |
*P11-12 (L01,6) EXCEL (Depreciation—SL, DDB, SYD, Act., and MACRS) On January 1, 2016, Locke Company, a small machine-tool manufacturer, acquired for $1,260,000 a piece of new industrial equipment. Th...
P11-11. (Depreciation for Partial Periods—SL, Act., SYD, and DDB) (LO 1, 2) On January 1, 2015, a machine was purchased for $90,000. The machine has an estimated salvage value of $6,000 and an estimated useful life of 5 years. The machine can operate for 100,000 hours before it needs to be replaced. The company closed its books on December 31 and operates the machine as follows: 2015, 20,000 hours; 2016, 25,000 hours; 2017, 15,000 hours; 2018, 30,000 hours; and 2019,...
Q1 On January 1, 2019, Locke Company, a small machine-tool manufacturer, acquired for equipment. The new equipment had a useful life of was estimated to be Use the following depreciation methods to calculate the depreciation expense for 2019, 2020, and 2021 $666,000 a piece of new industrial years, and the salvage value $66,000 . Locke estimates that the new equipment can produce (a) Straight-line, (b) Double-declining balance, (c) Sum-of-years'-digits.
On January 1,2020, Velio Company, a tool manufacturer, acquired new industrial equipment for $4 million. The Problel new equipment had a useful life of four mates that the new equipment can produce by 1,000 units per year over the remaining useful life of the equipment. and the residual value was estimated to be $400,000. Velio esti- Analyzing the Effect o Depreciation Method years, on Financial Statemer 14,000 tools in its first year. Production is then estimated to decline Results LO9...
for $4 million. The Problell2 On January 1, 2020, Velio Company, a tool manufacturer, acquired new industrial equipment new equipment had a useful life of four mates that the new equipment can produce by 1,000 units per year over the remaining useful life of the equipment. years, and the residual value was estimated to be $400,000. Velio esti Analyzing the Effect o Depreciation Method on Financial Statemer 14,000 tools in its first year. Production is then estimated to decline Results...
On January 1, 2015, Swift Corporation, a small manufacturer of machine tools, acquired new industrial equipment for $1,320,000. The new equipment had a useful life of five years and the residual value was estimated to be $60,000. Swift estimates that the new equipment can produce 14,500 machine tools in its first year. It estimates that production will decline by 1,000 units per year over the equipment’s remaining useful life. The following depreciation methods may be used: (1) straight-line, (2) double-declining-balance,...
P11-1 (Depreciation for Partial Period—SL, SYD, and DDB) Alladin Company purchased Machine #201 on May 1, 2014. The following information relating to Machine #201 was gathered at the end of May. Price $85,000 Credit terms 2/10, n/30 Freight-in $ 800 Preparation and installation costs $ 3,800 Labor costs during regular production operations $10,500 It is expected that the machine could be used for 10 years, after which the salvage value would be zero. Alladin intends to use the machine for...
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....
Q3/ On January 1, 2016, Cullumber Corporation acquired equipment costing $77,440. It was estimated at that time that the equipment would have a useful life of eight years and no residual value. The company uses the straight-line method of depreciation for its equipment, and its year end is December 31. A/ Calculate the equipment’s accumulated depreciation and carrying amount at the beginning of 2018. Equipment’s accumulated depreciation $ Carrying amount $ B/ What is the amount of the gain or...
phs and Excel Assighr 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...
On January 1, 2017, Oriole Company purchased a new machine for $4220000. The new machine has an estimated useful life of nine years and the salvage value was estimated to be $152000. Depreciation was computed using the sum-of-the-years-digits method. What amount should be shown in Oriole's balance sheet at December 31, 2018, net of accumulated depreciation, for this machine?