Question: I NEED HELP CREATING AMORTIZATION SCHEDULED FOR EXERCISE 11-5 USING EXCEL. E11-5 (L01,2) (Depreciation Computations-Four Methods) Robert Parish Corporation purchased a new assembly process on

 I NEED HELP CREATING AMORTIZATION SCHEDULED FOR EXERCISE 11-5 USING EXCEL.
I NEED HELP CREATING AMORTIZATION SCHEDULED FOR EXERCISE 11-5 USING EXCEL.

E11-5 (L01,2) (Depreciation Computations-Four Methods) Robert Parish Corporation purchased a new assembly process on August 1, 2017. The cost of this machine was $117,900. The company have a salvage value of $12,900 at the end of its service life. Its life is estimated 21,000 hours. Year-end is December 31. estimated that the machine would at 5 years, and its working hours are estimated at Instructions Compute the depreciation expense under the following methods. Each of the following should be considered unrelated. (a) Straight-line depreciation for 201:7. (b) Activity method for 2017, assuming that machine usage was 800 hours. (c) Sum-of-the-years-digits for 2018. (d) Double-declining-balance for 2018

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!