Please solve both (a) and (b) in an Excel Spreadsheet and provide formulas you used.

a) Use rate of return (ROR) analysis to determine which of the mutually exclusive projects listed below to select given a MARR of 12% per year.

b) Confirm your answer to part (a) using Present Worth analysis.

EOY B 0 1 A -$1,100 $900 $500 $500 $100 -$2,000 $900 $900 $900 $900 D E -$900 $1,200 $300 $400 $300 $400 $300 $400 $300 $400 $1,000 $600 $500 $500 $100 2 wn 3 4