On January 1, 2023, Hobart Manufacturing Company purchased a drill press at a cost of $145,000. The drill press is expected to last 15 years and has a residual value of $25,000. During its 10-year life, the equipment is expected to produce 600,000 units of product. In 2024 and 2025, 35,000 and 94,000 units, respectively, were produced.

Required:

1) Using Excel, prepare a depreciation schedule for the 15 years that the drill press is expected to be used. (Must include - Depreciation Expense, Year-end Accumulated Depreciation, and Year-end Book Value)

A) If depreciated using the straight-line method.

B) If depreciated using the double declining balance method.

C) If depreciated using the Sum-of-the-years-digits method.