Boom Town Industries purchased a building on January 1, 2019, at a cost of $364,000. BoomTown estimated that the useful life would be 25 years and the residual value would be $14,000. On January 1, 2020, Boom Town made several expenditures related to the building. The entire building was painted and the floors were refinished at a cost of $21,000. A federal agency required BoomTown to install pollution control devices which cost $42,000. With the new pollution devices, BoomTown now estimates the useful live of the building to extend an additional six years. On April 1, 2021, Boom Town decided to sell the building for $392,000 cash. Required: Using excel... 1. In one tab, prepare a depreciation schedule using straight-line depreciation for the purchase on January 1, 2019 a. Input cells are required so that the schedule is entirely calculated off the inputs. At a minimu, there will be an input cells will include Acquisition Cost, Useful Life, Residual Value b. Be sure to include a calculation of acquisition cost. 2. In a second tab, prepare a depreciation schedule using straight-line depreciation for the changes indicated in #2. a. Hint: Make a copy of the first tab to save time. 3. In a third tab, calculate the sale of the equipment and record the journal entry