Tableau DA 243 (Static): Mini-Case, Net present value and profitability index LO P3 Mac Company is considering investing in two different projects, Stout and Boise. The company requests our help analyzing accounting data to ensure it makes the right investment decision. The Tableau Dashboard is provided for our analysis. The company requires a 12% return on its investments. (PV of $1,FV of $1, PVA of $1, and FVA of $1 ) (Use appropriate factor(s) from the tables provided.) Tableau DA 24-3 (Static): Mini-Case, Net present value and profitability index LO P3 Mac Company is considering investing in two different projects, Stout and Boise. The company requests our help analyzing accounting data to ensure it makes the right investment decision. The Tableau Dashboard is provided for our analysis. The company requires a 12% return on its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1 ) (Use appropriate factor(s) from the tables provided.) Net Cash Flows per Project +++++++abeau 1. Compute the net present value of each project. 2. Based on net present values, which project(s) should the company invest in? 3. Compute the profitability index for each project. If the company can select only one project, which should it choose on the basis of profitability index? Complete this question by entering your answers in the tabs below. Compute the net present value of each project. Complete this question by entering your answers in the tabs below. Compute the net present value of each project. \begin{tabular}{|l|l|l|l|} \hline Year 2 & & & \\ \hline Year 3 & & & \\ \hline Year 4 & & & \\ \hline Year 5 & & & \\ \hline Totals & & & \\ \hline Initial investment & & & \\ \hline Net present value & & & \\ \hline Boise & & & \\ \hline Year 1 & & & \\ \hline Year 2 & & & \\ \hline Year 3 & & & \\ \hline Year 4 & $ & & \\ \hline Year 5 & & & \\ \hline Totals & & & \\ \hline Initial investment & & & \\ \hline Net present value & & & \\ \hline \end{tabular} Required 1 Required 2 protitability index? Complete this question by entering your answers in the tabs below. Compute the profitability index for each project. If the company can select only one project, which should it choose on the basis of profitability index