Question - Depreciation Expense
Valley Corporation purchased a new piece of equipment on June 1, 2015. The cost of this machine was $325,000. The company estimated that the machine would have a salvage value of $25,000 at the end of its service life. Its life is estimated at four years, and its working hours are estimated at 50,000 hours. The year end is December 31.
Compute the depreciation expense under the following methods in an Excel spreadsheet. Each of the following should be considered unrelated:
1. Straight-line depreciation for 2015
2. Units of production method for 2015, assuming that machine usage was 13,000 hours
3. Sum-of-the-years' digits for 2015
4. Double-declining balance for 2015
Show ALL work and calculations used to arrive at answers. It is important that I understand the steps and process. Thanks in advance.