You are the head of the project selection team at Broken Arrow records. Your team is considering two different recording projects. Based on past history, Broken Arrow expects at least a rate of return of 20 percent. Given the following information for each project, calculate the NPV for both projects using the NPV formula in Microsoft Excel. Time Fades Away Year Investment Revenue Stream $600000 0 1 450000 2 75000 3 20000 4 15000 5 10000 ANO Year On the Beach Investment Revenue Stream $400000 1 2 3 4 0 400000 100000 25000 10000 10000 O A. Neither project should be undertaken. Neither meets the rate of return goal. OB. Only "Time Fades Away" should be undertaken since it meets the desired rate of return. "On the Beach does not. c. Only "On the Beach should be undertaken since it meets the desired rate of return. "Time Fades Away" does not. OD. Both projects meet the desired rate of return but "On the Beach" is preferred. O E. Both projects meet the desired rate of return but "Time Fades Away" is preferred