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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You're at a career crossroads with three options: working for Company A in the software industry, Company B in the finance industry, or pursuing freelancing. You have two uncertain economic scenarios...

PUAD 630 - A NALYTICAL T ECHNIQUES U NIVERSITY OF B ALTIMORE , C OLLEGE OF P UBLIC A FFAIRS S EZGIN AYABAKAN , P H D Assignment 5 Individual or in Pairs Due Date: Dec 07, 2015 at 10:00AM There are...

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...

This assignment has two options: A AND / OR B: Create a decision tree to evaluate your career options. Sketch the tree. Use squares, circles, and triangles for decisions, uncertainties, and outcomes...

Please create a decision tree in excel - its question 3 in the attached document. Decision trees are another important if challenging world-class operations management method which operations...

Create a decision tree to evaluate your career options. Make sure your decision has at least two choices and two uncertain events with estimated probabilities. (I encourage you to consider options...

Attached, kindly find SNHU Course material for QSO-320 Management Science Spreadsheet Management - Milestone Four. Thank you! QSO 320 Final Project Guidelines and Rubric Overview The final project...

Assignment 3: Case Study - BMAC Research & Development Decision (Part 2) Note: Please do make sure that you appropriately cite any reference material, using Harvard Referencing style and ensure that...

1. From the scenario, cite your forecasting conclusions that support TFC?s decision to expand to the West Coast market. Speculate as to whether or not the agency conflict discussed in the scenario...

Which of the following types of animal virus requires RNA-dependent RNA transcriptase to be replicated? A) +SSRNA viruses B) SSDNA viruses C)-SSRNA viruses D) retroviruses E) dsDNA viruses

There is judgment involved in preparing financial statements. For example, management must often estimate warranty expense and bad debts expense. Management may also need to select an accounting...

if a company's TVOM is 10% then the company would be indifferent between 12500 today and how much in 1 year

In the Schedule of Cost of Goods Manufactured and Cost of Goods Sold, the Total raw materials available is computed by adding together the Beginning raw materials inventory and:

1. Discuss the strengths and weaknesses of presentational, hands-on, and group building training methods.

3. Develop a case study.

3. Do you believe that some generations (e.g., baby boomers, Generation Y, Generation X) of employees will react more positively to video games used for training than other generations? Why? Explain...