If calculated using Excel please include the excel-formulas used!!! (Excel is preferred) Thank you!!!

2020 2019 Equipment $140,000 $120,000 Accumulated Depreciation-Equip (40,000) (30,000) Building 220,0000 220,000 Accumulated Depreciation-Building (50,000) (40,000) 1. 4/1/2020 Purchased Equipment 2. Equipment costing $8,000 sold for $5,000, resulting a loss of $2,000. 3. Equipment costing $4,000 sold for $3,000, resulting in a gain of $1,000 A. B. Calculate TOTAL Depreciation Expense for 2020. Determine the cost of Equipment Purchased on 4/1/2020