Capital rationing Mintsement or Frisco films is coosiderife the foutowine canital nimiene A5same thatall projects have no salvage value and that the firm uses a discount rate of 10 percent, Management hys decided that anly 522.500 .000 can be spent in the current year far copichi propects. a. Use Excel to determine the net present value, profitabilty index, and internal rate of return for each of the seven project. Note: Round NPV (final dnswen) to the nearest whole dobar: Note: Round pi to two docimal places (ie, round 1,466 to 1/47 ). Note: Round 149 percentage to one decimal place (.e. round 85554 to 8.6% ). b. Rank the seven projects according to each method used in (a). riease answer all parts of the question. Capital rationing Mintsement or Frisco films is coosiderife the foutowine canital nimiene A5same thatall projects have no salvage value and that the firm uses a discount rate of 10 percent, Management hys decided that anly 522.500 .000 can be spent in the current year far copichi propects. a. Use Excel to determine the net present value, profitabilty index, and internal rate of return for each of the seven project. Note: Round NPV (final dnswen) to the nearest whole dobar: Note: Round pi to two docimal places (ie, round 1,466 to 1/47 ). Note: Round 149 percentage to one decimal place (.e. round 85554 to 8.6% ). b. Rank the seven projects according to each method used in (a). riease answer all parts of the