Question: 2. This assignment has two options: Either create a decision tree or a Monte Carlo simulation of a career decision. A. If you choose to

2. This assignment has two options: Either create a decision tree or a Monte Carlo simulation of a career decision. A. If you choose to create a decision tree, make sure your decision has at least two choices, uncertain events (with estimated probabilities) and at least four total outcomes (with values that you can guess). Calculate the expected value of each choice. Which is the best choice to make? Sketch the tree, and perform the calculations, by hand and upload a picture of your work. You can use the sketch below as a guide. Submit a scan of a handwritten sketch with your calculations. Optional: create your tree in Excel. B. If you choose to do a Monte Carlo simulation, project your salary over your career (40 or more years) for at least two career alternatives. Have your salary increase at an uncertain rate, using RANDBETWEEN. Optional: calculate the average, max, min and standard deviation of the NPV at 7% of each option. Based on this analysis and considering the risks of each option, which career alternative do you prefer? Submit an Excel spreadsheet. Use the GIF below, right, as a guide
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
