Please show work, including Formulas used in Excel. Thank you.

CAPITAL BUDGETING: OPTIMISTIC, PESSIMISTIC, MOST LIKELY VALUES IF REQUIRED RETURN = 10%, IS THE FOLLOWING INVESTMENT ATTRACTIVE? GIVEN THE FOLLOWING TABLE: HINT: USE EXCEL RATE FUNCTION FOR DISC. RATES (RATE OF INVESTMENT RETURN FOR EACH PROJECT) ASSUME MOST LIKELY IS 4x as likely as OPTIMISTIC or PESSIMISTIC; OPTIMISTIC AND PESSIMISTIC ARE EQUALLY LIKELY SCENARIOS OPTIMISTIC MOST LIKELY PESSIMISTIC EXPECTED VALUES COST 950 1000 1150 ? NET ANNUAL BENEFIT 210 200 170 ? SALVAGE VALUE 100 0 0 ? USEFUL LIFE 12 10 8 ? DISC. RATE= ? ? ? ? NPV(WI DISC. RATE)=