4.6 Help please show work with calculations and formulas in excel

\begin{tabular}{l|l|l|l|l|l} 4.184 .2 & 4.3 & 4.4 & 4.5 & 4.6 & 4.7 \end{tabular} CHAPTER 14: CAPITAL BUDGETING Homework Problem 4.6 Healthy Valley Medical Center is evaluating two investment projects, each of which requires an up-front expenditure of $1.5 million. The projects are expected to produce the following net cash inflows: \begin{tabular}{|c|} \hline Year \\ \hline 1 \\ \hline 2 \\ \hline 3 \\ \hline \end{tabular} \begin{tabular}{|r|r|} \hline Project A & \multicolumn{1}{|c|}{ Project B } \\ \cline { 2 - 2 } 500,000 & 2,000,000 \\ \hline 1,000,000 & 1,000,000 \\ \hline 2,000,000 & 600,000 \\ \hline \end{tabular} a. What is each project's IRR? Project B b. What is each project's NPV if the cost of capital is 10% ? Project A Project B