-Just want to know how to solve using excel.

(a) A vs DN: 0 = -30,000(A/P,i*,8) + 4000 + 1000(A/F,i*,8)

Solve for i* by spreadsheet

-How is this done on excel? what formula and how to input the values? please show entire thing.

31 A metal plating company is considering four different methods for recovering by-product heavy metals from a manufacturing site's liquid waste. The investment costs and annual net incomes associated with each method have been estimated. All methods have an 8-year life; the MARR is 11% per year; and an AW-based ROR analysis is required. (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 should be selected