You are on the board of directors as the CFO of the company and have been given the following projects to evaluate. The board does not like to investment in projects that are longer than 3 years but are open to all suggestions made. There are 5 investments to assess which are shown below in the table.

Year	Inv A	Inv B	Inv C	Inv D	Inv E
0	-$500,000	-$600,000	-$750,000	-$450,000	-$400,000
1	$23,000	$150,000	$255,000	$145,000	$225,000
2	$148,000	$150,000	$205,000	$165,000	-$28,000
3	$178,000	$150,000	$175,000	$185,000	$210,000
4	$210,000	$150,000	$120,000	$200,000	-$22,000
5	$250,000	$150,000	$50,000	$225,000	$235,000

1. NPV (FOR EACH INVESTMENT show the NPV with required rate of returns of 5%, 10%, 15%,20%, and 30% - Use a chart to summarize your findings)

2. IRR (hint - graph the IRR for each of the investments to show the IRR%) 3. Profitability Index ((FOR EACH INVESTMENT show the Profitability Index with required rate of returns of 5%, 10%, 15%, 20%, and 30% - Use a chart to summarizeyour findings) 4. Payback Period b) Which project should you choose??

Show your work. Try to use excel. Please attach link to excel to answer. Must show formulas and etc.