Please solve using Excel

Question 1: You are the CFO of FloorCovering America Inc. As part of the planning and budgeting process, each division head from the company's five divisions has submitted their capital requests. The following are the facts and figures from each division (in $'000): Division . II III IV V Capital Requested -10,000 -30,000 -30,000 -20,000 -10,000 NPV 5,160 2,010 490 4,870 2,290 IRR 29% 12% 11% 23% 15% Profitability Index 1.5 1.1 1.0 1.2 1.2 The projects above are "All or Nothing meaning for example that division I requires an investment of $10M immediately, and cannot accept partial funding of its project. The projects are NOT mutually exclusive. The cost of capital for each of the projects is 10%. a) Suppose the company has unlimited capital and can invest in all of the projects if deemed optimal, which of the projects should be funded? Why? (2 points) b) Because of challenging capital market conditions, the company can only raise $50M for investment in next years' projects. Which of the projects should be funded? Why? (4 points)