A mechanical engineer at Anode Metals is considering five equivalent projects, some of which have different life expectations. Salvage value is nil for all alternatives.

Assuming that the company's MARR is $13\%$ per year.

Required:

Note: Use cells A$2$ to D$12$ from the given information to complete this question.

a$.$ Determine which should be selected if they are independent.

C and D

b$.$ Determine which should be selected if they are mutually exclusive.

I NEED HELP WITH THIS TABLE. PLEASE!!!

A mechanical engineer at Anode Metals is considering five equivalent projects, some of which have different life expectations. Salvage value is nil for all alternatives.

Required:

Assuming that the company's MARR is $13\%$ per year,

a$.$ Determine which should be selected if they are independent

b$.$ Determine which should be selected if they are mutually exclusive.

$\backslash$table$[[$Net Annual Income,$],[$A$,$First cost, $$,\backslash$table$[[$$ per Year$]],],[$A$,-20,000,+5,500,4],[$B$,-10,000,+2,000,6],[$C$,-15,000,3,800,6],[$D$,-60,000,+11,000,12],[$E$,-80,000,+9,000,12]]$

Navigation:

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.