For the last question, the answer choices are delay, accept, reject, or discontinue all products

explanation with excel if possible is always appreciated

thanks in advance!

the project if the demand for the new product is low. In the following decision tree table, (1), (2) and (3) represent decision points, also known as decision nodes or stages. The dollar value the right of each decision node represents the net cash flow at that point, and the cash flows shown under t = 3, 4, and 5 represent the cash inflows if the project is pushed on to completion. If Free Spirit Industries Inc. decides to launch the new line for iCars at Stage (1), then it will spend $60,000 on the marketing study. If the marketing study yields positive results, then the firm will spend $200,000 on the prototype. If the prototype works well, then the firm will spend several millions more at Stage (3) to build a production plant. Suppose that as an analyst at Free Spirit Industries Inc. you have to analyze sequential decisions. By studying the following decision tree, you learn which of the following? Check all that apply. If the project is canceled after Stage (1), Free Spirit Industries Inc.'s costs will be $260,000. There is a 5% probability that investment in a production plant will yield bad results. If the project is canceled after Stage (1), Free Spirit Industries Inc.'s costs will be $10,269,000. If the project is canceled after Stage (1), the cost to Free Spirit Industries Inc. will be the $60,000. Complete the decision tree table by calculating the net present values (NPVS) and joint probabilities, as well as products of joint probabilities and NPVs for each decision branch. Assume that the weighted average cost of capital (WACC) is 9% for all decision branches. Hint: Use either a spreadsheet program's functions or a financial calculator for this task. Round the NPVs to the nearest dollar and remember to enter the minus sign if a value is negative. Note: All cash amounts in the following table are in thousands of dollars. Step 0 Step 1 ist Invest Prob 2nd Invest Step 2 3rd Invest Step 3 Inflow Step 4 Inflow Step 5 Inflow Prob NPV ($) Joint Prob (%) NPV x Joint Prob ($) (2) 55% (2) 35% 95% -$10,269 - $10,000 Stop - $200 (3) $4,761 (3) $1,900 (3) $0 $20,065 $7,800 $8,237 $2,345 $0 (1) - $60 (2) 5% $0 5% Stop $0 $0 $0 $0 Expected NPV = Based on your calculations, you recommend that Free Spirit Industries Inc