INITIAL INVESTMENT PER PROJECT:

STOUT: $24,000

BOISE: $30,000

Mac Co. is considering investing in two different projects, Stout and Boise. The company requests our help analy to ensure it makes the right investment decision. The Tableau Dashboard is provided for our analysis. The compa return on its investments. (PV of $1. FV of $1. PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables Initial Investment per Project Stout Boise Stout Initial Investment: $24,000 Net Cash Flows per Project Stout Boise $8,000 Year 1 $4,000 $8,000 Year 2 $9,000 $8,000 Year 3 $13,000 $8,000 Year 4 $20,000 Stout Boise $8,000 Year 1 $4,000 1 $8,000 Year 2 $9,000 $8,000 Year 3 $13,000 $8,000 Year 4 $20,000 $8,000 Year 5 $18,000 $20,000 $15,000 $10,000 $5,000 SO so $5,000 $10,000 $15,000 $20,000 Net Cash Flows (Stout) Net Cash Flows (Boise) * tableau OT 1. Compute the net present value of each project. 2. Based on net present values, which project(s) should the company invest in? 3. Assuming the company must choose one project only, compute the profitability index to determine the best project to invest in Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Assuming the company must choose one project only, compute the profitability index to determine the best project to invest In. Profitability Index Choose Numerator: 1 Choose Denominator: = Profitability Index Profitability index 1 Stout 0 Boise 0 If the company can choose only one project, which should it choose?