Solve the question with Ms. Excel Format or Convertible to Ms. Word with Clear Numerical Explanations.

Q: A Multinational Corporation purchased a new plant machinery for its production on Jan 1, 2010. The cost of this machinery was $1,000,000. The company estimated that the machinery would have a salvage value of $50,000 at the end of its service life. Its life is estimated at 5 years and its working hours are estimated at 1000 hours. Year-end is December 31.

Compute the depreciation expense under the following methods.

1. Activity method. (Hours Used are 200,150,250,300 & 100).
2. Sum-of-the-years-digits.

Please Solve Both Requirements