Question

phs and Excel Assighr On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has
Done := DepreciationSchedules (1 of 3) SL UOP DDB Sheet3 Depreciation for the Year Useful Life Depreciation Accumulated Expen
Done = DepreciationSchedules (1 of 3) DDB SL UOP Sheet3 Depreciation for the Year Number of Units Depreciation Accumulated Ex
DepreciationSchedules (1 of 3) Done SL UOP DDB Sheet3 Depreciation for the Year DDB Rate Depreciation Accumulated Expense Boo
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. SLM

Original Cost 350000
Salvage Value 30000
Life 4

Depreication (SLM) = (350000-30000)/4 = 80000.

Date Opening Book value Depreciation Closing Book value
1/1/2018 350000 350000
31/12/18 350000 80000 270000
31/12/19 270000 80000 190000
31/12/20 190000 80000 110000
31/12/21 110000 80000 30000

2. Units of production:

Original Cost 350000
Salvage Value 30000
Value to be depreciated 320000

..

Date Units Produced Opening Book Value Depreciation Closing Book value
1/1/2018 350000 350000
31/12/18 30000 350000 320000*30000/100000 96000 254000
31/12/19 40000 254000 320000*40000/100000 128000 126000
31/12/20 20000 126000 320000*20000/100000 64000 62000
31/12/21 10000 62000 320000*10000/100000 32000 30000
TOTAL 100000

3. Depreciation as per SLM => 80000. SO depreciation rate as per slm => 80000/350000*100 = 22.857%.

So Double Declining Method, Deprecation Rate = 22.857*2 = 45.714%

Date Opening Book Value Depreciation Closing Book value
1/1/2018                     350,000.00                           350,000.00
31/12/18                     350,000.00 350000*45.714% = 160,000.00                           190,000.00
31/12/19                     190,000.00 190000*45.714% = 86,857.14                           103,142.86
31/12/20                     103,142.86 103142.86*45.714% =47,151.02                             55,991.84
31/12/21                       55,991.84 (55991.84-30000) = 25,991.84                             30,000.00
Add a comment
Know the answer?
Add Answer to:
phs and Excel Assighr On January 1, 2018 Friendly Farm Company purchased a new machine at...
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
  • K Excel Assignment #1 - Instructions and Te... On January 1, 2018 Friendly Farm Company purchased...

    K Excel Assignment #1 - Instructions and Te... 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...

  • On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000....

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

  • On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000....

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

    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.

  • Easy Espresso purchased a coffee drink machine on January 1, 2018, for $13,500. Expected useful life...

    Easy Espresso purchased a coffee drink machine on January 1, 2018, for $13,500. Expected useful life is 5 years or 50,000 drinks. In 2018, 5,000 drinks were sold, and in 2019, 13,000 drinks were sold. Residual value is $1,000. Read the requirements. Requirement 1. Determine the depreciation expense for 2018 and 2019 using the following methods: (a) Straight-line (SL). (b) Units of production (UOP), and (c) Double-declining-balance (DDB) For each method (starting with (a) the straight-line method), select the appropriate...

  • On January 1 of the current year, Thayer Manufacturing Company purchased a metal cutting and polishing...

    On January 1 of the current year, Thayer Manufacturing Company purchased a metal cutting and polishing machine at a cost of $4,700,000. The installation and delivery costs amounted to $300,000. The firm expects the machine to be productive for a total of 5 years and a residual value of $450,000 at the end of the asset's useful life. Read the requirements. Requirement 1. Prepare the depreciation schedules for the machine assuming that Thayer Manufacturing uses the straight-line method. A Requirements...

  • On January 2, 2020, Rachel, Inc. purchased a new machine for its factory. The new machine...

    On January 2, 2020, Rachel, Inc. purchased a new machine for its factory. The new machine cost $55,000, has an expected useful life of 7 years and an estimated residual value of $5,000. Prepare a depreciation schedule for the new machine using the following depreciation methods: 1) Straight Line (SL) 2) Sum-of-the-Years-Digits (SYD) 3) Declining Balance using twice the straight line rate (DDB) 4) Modified Accelerated Cost Recovery System (MACRS) (5 year asset class)

  • On January 2, 2018, Tucker Enterprises, Inc., paid $204,500 for equipment used in manufacturing automotive supplies....

    On January 2, 2018, Tucker Enterprises, Inc., paid $204,500 for equipment used in manufacturing automotive supplies. In addition to the basic purchase price, the company paid $900 for transportation charges, $800 for insurance for the equipment while in transit, $11,600 sales tax, and $2,200 for a special platform on which to place the equipment in the plant. Management of Tucker Enterprises, Inc., estimates that the equipment will remain in service for five years and have a residual value of $20,000....

  • On January 2, 2018, Tucker Enterprises, Inc., paid $204,500 for equipment used in manufacturing automotive supplies....

    On January 2, 2018, Tucker Enterprises, Inc., paid $204,500 for equipment used in manufacturing automotive supplies. In addition to the basic purchase price, the company paid $900 for transportation charges, $800 for insurance for the equipment while in transit, $11,600 sales tax, and $2,200 for a special platform on which to place the equipment in the plant. Management of Tucker Enterprises, Inc., estimates that the equipment will remain in service for five years and have a residual value of $20,000....

  • 1. (12 points) Robert Parish Corporation purchased a new machine for its assembly process on January...

    1. (12 points) Robert Parish Corporation purchased a new machine for its assembly process on January 1, 2014. The cost of this machine was $117,900. The company estimated that the machine would have a salvage value of $17,900 at the end of its service life. Its life is estimated at 4 years, and its working hours are estimated at 10,000 hours. Year-end is December 31. Instructions Compute the depreciation expense under the following methods and complete the depreciation schedules below....

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