Engineering economics problem. please show the answer in steps

3. A metal plating company is considering four different methods for recovering byproduct heavy metals from a manufacturing sites liquid waste. The investment costs and incomes associated with each method have been estimated as shown below. All methods have an 8-year life. The MARR is 11% per year. use Excel to solve any iterative formula, but explain your solution method on paper (please attached the excel sheet solution). (a) If the methods are independent, because they can be implemented at different plants, which ones are acceptable?

(b) If the methods are mutually exclusive, determine which one method should be selected, using a ROR evaluation.

Annual First Salvage Method Cost, Value, income, year 30,000 +1,000 +4,000 36,000 2,000 5,000 500 41,000 8.000 53,000 +10,500 2,000