I need parts A and B for first photo, second photo is the exercise being referenced. Please provide work and answers in spreadsheet format. Please and 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