a. From the information provided in the schedule below, calculate the annual and monthly depreciation expense for all of the equipment, assuming an expected useful life of 5 years, using the straight-line, sum-of-the-years' digits, double-declining balance, and MACRS (3 and 5 year) methods of depreciation. You do not need to calculate monthly expense for the MACRS methods. (as of 6/30/X1) Salvage Unit Cost Value Market Value $ $ Truck Wagon Auto 18,000 14,400 12,600 1,800 1,440 1,260 16,000 14,000 12,900 Totals $ 45,000 $ 4,500 $ 42,900 Using Excel, set up and complete the following 5 depreciation schedules