Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

assignment has two options: A B : Create a decision tree of your career options: make sure your decision has at least two choices, uncertain

image text in transcribed
image text in transcribed
assignment has two options: A B : Create a decision tree of your career options: make sure your decision has at least two choices, uncertain events (with estimated probabilities), and at least four total outcomes (estimated salaries). Sketch the tree, and calculate the expected value of each choice. Highlight the best choice and explain in 2-3 sentences why it's the best choice based on your analysis. See my sketch below-left as a guide. You may submit a scan of a handwritten sketch showing your calculations, or use Excel, PowerPoint, or other graphics program. Create a Monte Carlo simulation of career options: project your salary over your career (usually 30 or more years) for at least two career alternatives. Have your salary increase each year at an uncertain rate, using RANDBETWEEN. Calculate the NPV at 7% of each option. (Optional: create 100 scenarios using a Data Table as demonstrated and calculate the average, max, min, and standard deviation of the NPV of each option.) Highlight the best choice and explain in 2-3 sentences why it's the best choice based on your analysis. Submit an Excel spreadsheet. See the GIF below-right

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems A Practical Approach To Design Implementation And Management

Authors: THOMAS CONNOLLY

6th Edition

9353438918, 978-9353438913

More Books

Students also viewed these Databases questions

Question

3. Develop a case study.

Answered: 1 week ago