*Using Excel*

5. Quark Industries has four potential projects, all with an initial cost of $2,000,000. The capital budget for the year will allow Quark Industries to accept only one of the four projects. Given the discount rates and the future cash flows of each project, determine which project Quark should accept. Project N Cash Flow Year 1 Year 2 Year 3 Year 4 Year 5 Discount rate Project M $500,000 $600,000 $500,000 $600,000 $500,000 $600,000 $500,000 $600,000 $500,000 $600,000 Project O $1,000,000$ 300,000 $800,000$ 500,000 $600,000$ 700,000 $400,000$ 900,000 $200,000$1,100,000 Project P 6% 9% 15% 22%