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.

Project: Time Fades Away

New Artist: 10

Risk: -10

Genre: 7

Diversity: 3

Year	Investment	Revenue
0	-$600,000.00	$0.00
1	$0.00	$500,000.00
2	$0.00	$75,000.00
3	$0.00	$20,000.00
4	$0.00	$15,000.00
5	$0.00	$10,000.00

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

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	$ -	$7,500.00
5	$ -	$1,500.00

SHOW EXCEL FORMULAS