Question 5. (includes parts a and b below). You are planning to purchase new test equipment for your lab and narrowed the alternatives down to three with the cash flows stated below. The equipment's useful life is the same as the porject life, which is 10 years, and these are cost-based projects. a. (5 points) Use the NFV method to compare the alternatives. SOLVE THE PROBLEM BY, FIRST, FILLING OUT THE YELLOW TABLE BELOW, AND THEN CALCULATE EACH NPV IN THE BLUE CELLS (each NPV cell must show an appropriate Excel formula when clicked on. Similarly, if you need to make calculations in any other cell in the yellow table, that cell must include the formula you used - NOT just values). MAKE SURE TO SHOW YOUR WORK AND ONLY USE EXCEL FORMULAS! MAKE SURE YOUR WORK IS WELL ORGANIZED AND CLEARLY INDICATE THE RESULTS. b. (1 point) Which alternative would you choose and why, based on the FV method? Please choose one below by selecting that option and changing the text color to red. b1. Alternative A b2. Alternative B b3. Alternative C b4. Do nothing MARR= Project life = 15% 10 years Purchase price Salvage* Annual Costs $2,600 $200 $1,000 $3,500 $250 $1,070 $3,850 $300 $940 | *Salvage is the cash you get from selling the equipment at the end of its useful life. time LAB 5 TT 10 NPV =