Hello. Please refer to instructions in first picture, second picture is the referenced exercise. Please note the differenet amount (1,800,000) for part B. Please provide work and answers in spreadsheet format. Please/Thanks!

Refer to exercise 17 A. Determine the depreciation expense and end of the year book value for the first four years of the asset's life for the equipment under each of the following methods 1. Straight Line 2. Double Declining Balance 3. Units of Output If the equipment is sold for $1,800,000 at the end of the fourth year, what is the gain or loss that the company would recognize under each of the depreciation methods from part A? B