You are the head of project selection for Broken Arrow Records (BAR). Your team is considering three new projects, each with a unique sound and style. Based on past history, management requires a 20% rate of return. Additionally, they have allocated $1 million toward the production of these albums. Finally, management wants you to find new talent without taking risks. So, give the following weights to projects New Artist = 10, Risk = 6, Genre = 3, Diversity = 2 Given the following information about each project, prioritize each project. That is, put them in order of which BAR should do first second, and third, money permitting, of course. Note: You will use the Project Selection Matrix, the Payback Period, and the NPV to make your decision 1. Project: Time Fades Away New Artist: 10 Risk: -10 Genre: 7 Diversity: 3 Year 0 1 2 Investment Revenue $600,000.00 $0.00 $0.00 $500,000.00 $0.00 $75,000.00 $0.00 $20,000.00 $0.00 $15,000.00 $0.00 $10,000.00 3 4 5 2. Project: Tears in the Rain New Artist: 5 Risk: -5 Genre: 9 Diversity: 2 Year 0 1 2 Investment Revenue $400,000.00 $0.00 $0.00 $400,000.00 $0.00 $100,000.00 $0.00 $25,000.00 $0.00 $20,000.00 $0.00 $10,000.00 3 4 5 2. Project: Tears in the Rain New Artist: 5 Risk: -5 Genre: 9 Diversity: 2 Year Investment Revenue 0 -$400,000.00 $0.00 1 $0.00 $400,000.00 2 $0.00 $100,000.00 3 $0.00 $25,000.00 4 $0.00 $20,000.00 5 $0.00 $10,000.00 3. Project: On the Beach New Artist: 2 Risk: -2 Genre: 3 Diversity: 2 Project: On the Beach Year Investment Revenue 0 -$200,000.00 $ 1 $275,000.00 2 $ $75,000.00 3 $ $10,000.00 4 s $2,500.00 5 $ $1,500.00