Question

*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-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

  1. (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.

  2. (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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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
Add a comment
Know the answer?
Add Answer to:
*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...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • P11-11. (Depreciation for Partial Periods—SL, Act., SYD, and DDB) (LO 1, 2) On January 1, 2015,...

    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...

    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...

    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...

    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 indust...

    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,...

    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...

    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...

    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...

    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...

    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?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT