following the note part howvever i can see excel function as well.

Note: 1. Show your calculations clearly. 2. Draw the cash flow diagrams wherever necessary. 3. Use Excel to solve problems as and when needed. 4. Comment on the results when it is appropriate. 2. Four different methods are being considered by a metal plating company for recovering by-product heavy metals from a manufacturing site's liquid waste. The investment costs and incomes associated with each method have been estimated. All methods have a life of 10 years. The MARR is 12% per year. Method A B D First Cost, $ -15,000 -18,000 -25,000 -35,000 Salvage Value, s +1,000 +2,000 -500 -700 Annual Income, $ +4,000 +5,000 +6,000 +8,000 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 on the basis of incremental rate of return analysis. Note: Use Excel to solve the