please do it in 10 minutes will upvote Excell

r Problem 3 The management of Brawn Engineering is considering three alternatives to satisfy an OSHA requirement for safety gates in the machine shop. The initial costs (year 0), operating costs, and salvage values over a 5-year planning horizon are shown below (Year 5 includes the salvage value shown in the positive portion) End of 0 1 2 3 4 5 Year Gate 1 -$4,600 Gate 2 -$21,722.4 -$5,800 -$5,800 -$5,800 -$5,800 -$19,600 -$5,900 -$5,900 -$5,900 -$4,800 -$4,800 -$4,800 -$300 -$5,900 -$25,222.4 -$4,800 -$1900 Gate 3 Using an External Rate of Return (ERR) analysis with a MARR of 11.9%/year, determine the preferred gate. (You need to show the steps you use in your work.)