***Please show work in Excel (work and cell formulas***

You are considering two investment projects, each of which requires an up-front expenditure of \$25 million. The investments will produce the following after-tax cash flows (in million dollars). \begin{tabular}{|c|c|c|} \hline Year & Project A & Project B \\ \hline 0 & $25,000,000 & $25,000,000 \\ \hline 1 & $5,000,000 & $20,000,000 \\ \hline 2 & $10,000,000 & $10,000,000 \\ \hline 3 & $15,000,000 & $8,000,000 \\ \hline 4 & $20,000,000 & $6,000,000 \\ \hline \end{tabular} 1. What is the project's A payback period? 2. If the two projects are independent and the cost of capital is 10%, which project or projects should be taken? 3. If the two projects are mutually exclusive, which project should be taken? (Hint, construct the NPV profile). 4. What is the cross-over rate? 5. If the cost of capital is 10%, what is the MIRR (Modified Internal rate of return) of project A