Capital rationing

Management of Frisco Films is considering the following capital projects:

Assume that all projects have no salvage value and that the firm uses a discount rate of $10$ percent. Management has decided that only $$30,000,000$ can be spent in the current year for capital projects.

a$.$ Use Excel to determine the net present value, profitability index, and internal rate of return for each of the seven project.

Note: Round NPV $($final answer$)$ to the nearest whole dollar.

Note: Round PI to two decimal places $($i$.$e$.$ round $1\mathrm{.}466$ to $1\mathrm{.}47).$

Note: Round IRR percentage to one decimal place $($i$.$e$.$ round $8\mathrm{.}555\%$ to $8\mathrm{.}6\%.$

b$.$ Rank the seven projects according to each method used in $($a$).$