PLEASE USE EXCEL TO SOLVE

Sheet 4: You have been asked to choose between two office equipment, which will be needed for 6 years of operation. Equipment A will last 3 years, whereas equipment B will last 6 years. Equipment A costs $2800, has a salvage value of $1200, and should be replaced with an identical equipment at the end of its life. Equipment B costs $4793 and has a salvage value of $2300. For an interest rate of 12%, calculate each equipment's equivalent uniform annual costs (EUAC). Then, both cells should be highlighted in yellow. (Note: Include the salvage in your calculations)