Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above:

Year Investment A Investment B

0 -$5,000,000 - $ 5,000,000

1 $1500,000 $ 1250,000

2 $1500,000 $ 1250,000

3 $1500,000 $ 1250,000

4 $1500,000 $ 1250,000

5 $1500,000 $ 1250,000

6 $1500,000 $ 1250,000

7 $2000,000 $ 1250,000

8 0 $ 1600,000