can someone show us what to put in the cell rather the than answer. the homework is graded by using excel formulas for example ( =B3+C3). thxxxxx. 2 people have answer and its the same.

20,000 6,000 A machine that cost $400,000 has an estimated residual value of $40,000 and an estimated useful life of 20,000 machine hours. The company uses units-of-production depreciation and $400,000 $40,000 ran the machine 3,000 hours in year 1, 8,000 hours in year 2, and 6,000 hours in year 3. 3,000 8,000 4 5 Required: 6 (Do not round intermediate calculations.) 7 1. Calculate the accumulated depreciation for years 1, 2, and 3 using units of production depreciation 2. Use your answer in requirement 1 to calculate the book value at the end of year 3. 9 10 11 8 1 fx Accessibility tab summary: A statement for requirement is presented in rows 2. Rows 6 and 7 list the requirements B C D E F G H 1 J K A $400,000 $40,000 4 years A machine that cost $400,000 has an estimated residual value of $40,000 and an estimated 2 useful life of four years. The company uses double-declining balance depreciation. 3 4 Required: 5 (Do not round intermediate calculations.) 1. Use the DDB function in Excel to calculate accumulated depreciation for years 1, 2, and 3. 6 (See the Help function in Excel for proper DDB syntax.) 7 2. Use your answer in requirement 1 to calculate the book value at the end of year 3. 8 9