Study the uncertainty surrounding payoff of investment

Assignment Help Operation Management

Reference no: EM132090297

Problem: Investment Payoff’s Case

A decision maker is working on a problem that requires her to study the uncertainty surrounding the payoff of an investment. There are three possible levels of payoff, i.e., $1,000, $5,000, and $10,000. As a rough approximation, the decision maker believes that each possible payoff is equally likely. But she is not fully comfortable with the assessment that each probability is exactly 1/3, and so would like to conduct a sensitivity analysis. In fact, she believes that each probability could range from 0 to 0.5 following the uniform distribution. The sum of the probabilities must be equal to 1.

1. Develop an Excel worksheet to capture the above scenario.

2. Perform the Monte Carlo simulation (using the uniform distribution and 500 iterations) that could facilitate a sensitivity analysis of the probabilities of the payoffs.

3. Attach the simulation graph result for the expected payoff as an output.

4. Based upon the graph result, what is the probability that the payoff will be less than $6,000?

Reference no: EM132090297

Questions Cloud

Create t-accounts based on the accounts titles : Recording Adjusting Entries and Preparing an Adjusted Trial Balance Ninja Sockeye Star, owned by Johnny Chen, had the following unadjusted accounts.

Clearly showing the minimum financial analysis : 200426 Corporate Finance Assignment - Western Sydney University, Australia. Readable spreadsheets clearly showing at least the minimum financial analysis

Risk-utility balancing refers to the fact : Risk-utility balancing refers to the fact that. Explain the supply chain macro-processes in a firm.

Post the effects of the adjusting journal entries : Recording Adjusting Entries and Preparing an Adjusted Trial Balance Mint Cleaning, owned by Kat , had the following unadjusted accounts at the end.

Study the uncertainty surrounding payoff of investment : A decision maker is working on a problem that requires her to study the uncertainty surrounding the payoff of an investment.

Complete the worksheet using given data : Completing a Worksheet Starting with an Unadjusted Trial Balance (Chapter Supplement) Fairbanks Company is completing its annual accounting information.

Prepare a classified income statement for given year : Using the adjusted balances in prepare a classified income statement, statement of owner's equity, and classified balance sheet for 2010.

Coal is carried from a mine in west virginia to a power plan : Coal is carried from a mine in West Virginia to a power plant in New York in hopper cars on a long train. The automatic hopper car loader is set to put82 tons

Structure of a qualitative introduction-literature review : Describe the differences that you see in the content and structure of a qualitative introduction and literature review as compared

User Account

All Pages