Part 1. Calculate and record depreciation using the methods of: 1. Straight-line, 2. units-of-production 3. double-declining-balance Sigma Corporation, purchased a machine for $50,000 on January 1, 2001, with an estimated useful life of 5 years and a salvage value of $5,000. The machine produced 20,000 units in 2001, 15,000 units in 2002, 10,000 units in 2003, 5,000 units in 2004, and 2,500 units in 2005.

Use only Excel to present your answers.

Part 2 Choose the correct option

1. Based on the Straight-line Method. What is the depreciation expense calculated on Year 3 *

1.$7,200

2. $9,000

3.$5,000

4. $18,000

2. Based on the Double-Declining-Balance Method. What is the calculated Book Value at the beginning of the Year 3*

1.$18,000

2.$9,000

3. $5,000

4.$7,200

3. Based on the Double-Declining-Balance Method. What is the calculated depreciation expense at the beginning of Year 3 *

1. $5,000

2.$7,200

3.$9,000

4.$18,000

4. Based on Units-of-Production Method. The expense per unit and depreciation expense for Fiscal Year 5 would be. Select the correct amounts respectively. *

1. $3.33; $49,950

2. $4.50; $45,000

3. $18.00; $0.00

4.$18.00; $45,000

5. Based on Units-of-Production Method. The expense per unit and depreciation expense for Fiscal Year 3 would be. Select the correct amounts respectively. *

1. $18.00; $45,000

2. $3.33; $49,950

3. $4.50; $45,000

4. $18.00; $0.00