which project should be broke arrows first priority and it's NPV-

the NPV for the second most favorable-

the NPV for the third most favorable?

You are the head of the project selection team at Broken Arrow Records. Your team is considering three different recording projects. Based on past history, Broken Arrow expects at least a rate of return of 20%. Given the following information for each project, which one should be Broken Arrow's first priority? Should Broken Arrow fund any of the other projects? (Use the NPV function in Excel to solve this problem). Project: Time Fades Away Year Investment Revenue Stream 300,000 300,000 2 85,000 3 19,000 4 14,000 5 11,000 Project: On the Beach Year Investment 0 500,000 Revenue Stream 2 3 4 500,000 85,000 21,000 25,000 11,000 Project: Tonight's the Night Year Investment 500,000 1 2 3 4 5 Revenue Stream 0 500,000 119,000 77,000 18,000 12,000 Which project should be Broken Arrow's first priority? Tonight's the Night It's NPV IS Which is the second most favorable project? The NPV for the second most favorable is Time Fades Away