Must be solved with excel spreadsheet solving as an npv graph.

A. Document the IRR for each option B. Evaluate the result at a MARR of 10% C. Produce the solution as a Choice table

Given a value of MARR at 10%, use incremental analysis to determine which of the following alternatives should be selected (if any). Each has an expected life of ten years. This question must be solved by hand/paper analysis. Plan 1 2 3 4 Null First Cost $220,000 $100,000 $265,000 $180,000 $0 Annual Benefit 39,000 15,000 51,000 26,000 0 Must be solved with excel spreadsheet solving as an npv graph. A. Document the IRR for each option B. Evaluate the result at a MARR of 10% C. Produce the solution as a Choice table