Problem 3 tab shows a decision tree with 7 nodes. Each node has a cell with yellow background color above it.

1. Enter appropriate formulas in all cells with the yellow background to evaluate the decision tree. Show the winning project (A or B) in the space provided by entering a formula inside cell B5.
2. How should the payoff on node 4 (currently $40) be changed to make the Project A the winner?
3. How should the probability on node 4 branch (currently 0.6) be changed to make Project A the winner?

B C D E F G H J K L M PROBLEM 3 (25 Points) -- $80 $40 ANSWERS for Problem 2 Evaluation for Node 7: 5 Winning Project: $30 Evaluation for Node 6: Evaluation for Node 5: $70 Evaluation for Node 4: Evaluation for Node 3: $90 Evaluation for Node 2: Evaluation for Node 1: ($10) Formula typed in cell B5: New payoff (replace $40) for Node 4= ($20) New prob. (replace 0.6) on Node 4= $80 B C D E F G H J K L M PROBLEM 3 (25 Points) -- $80 $40 ANSWERS for Problem 2 Evaluation for Node 7: 5 Winning Project: $30 Evaluation for Node 6: Evaluation for Node 5: $70 Evaluation for Node 4: Evaluation for Node 3: $90 Evaluation for Node 2: Evaluation for Node 1: ($10) Formula typed in cell B5: New payoff (replace $40) for Node 4= ($20) New prob. (replace 0.6) on Node 4= $80