Need to be completed in Excel.

QUESTION 6 Consider a situation where a firm carefully performs capital budgeting analysis and selects a project with a high, positive NPV. Three years later, the project is terminated early and the company has lost significant money on the project. Does this mean that their capital budgeting process is flawed? Explain. PROBLEM 1 Calculate the PP, NPV, and IRR of the following projects (assuming a 14% required return and critical acceptance level of 3 years) Cash Flow Project A Project B Project C Project D CFO -$1,000,000 $1,000,000 $500,000 -$500,000 CF1 400,000 150,000 200,000 75,000 CF2 400,000 100,000 250,000 50,000 CF3 225,000 550,000 15 225,000 CF4 200,000 775,000 100,000 387,500 Which project(s) should we accept if they are independent? Mutually Exclusive