Paper: ? RISK: FREQUENCY DISTRIBUTION, PROBABILITIES, AND EXPECTED VALUE Risk: Probabilities and Expected Value Scenario: Yo
RISK: FREQUENCY DISTRIBUTION, PROBABILITIES, AND EXPECTED VALUE
Risk: Probabilities and Expected Value
Scenario: You work for a private investment company that currently has numerous business investments in real estate development, restaurant franchises, and retail chains. Following an exhaustive search for new investment opportunities, you have found three possible alternatives, each of which will pay off in exactly 10 years from the date of initial investment. Because you only have enough money to invest in one of the three options, you recognize that you will need to complete a quantitative comparison of the three alternatives:
Option A: Real estate development.
Option B: Investment in the retail franchise “Just Hats,” a boutique that sells hats for men and women.
Option C: Investment in “Cupcakes and so forth,” a franchise that sells a wide variety of cupcakes and a variety other desserts.
Download the raw data for the three investments in this Excel document: Raw data for BUS520 SLP 2 (see attached Below)
Assignment
Develop an analysis of these three investments in Excel. Use expected value to determine which of the three alternatives you should choose.
Write a report to your private investment company, explaining your Excel analysis, giving your recommendation, and justifying your decision.
SLP Assignment Expectations
Excel Analysis
- Using Excel, make an accurate and complete analysis of the three investment alternatives.
Written Report
- Length requirements: 2–3 pages minimum (not including Cover and Reference pages). NOTE: You must submit 2–3 pages of written discussion and analysis. This means that you should avoid use of tables and charts as “space fillers.”
- Provide a brief introduction to/background of the problem.
- Discuss the steps you used in completion of your Excel analysis.
- Based on your Excel analysis, give your recommendation as to which of the three investment alternatives should be pursued.
Upload both your written report and Excel file to the SLP 2 Dropbox.
Sheet1
Real Estate | Just Hats | |||||||||
NPV | Probability | NPV | Probability | |||||||
High | $ 5,000,000 | 0.50 | High | $ 4,000,000 | 0.65 | |||||
Medium | $ 2,250,000 | 0.35 | Medium | $ 2,700,000 | 0.30 | |||||
Low | $ 250,000 | 0.15 | Low | $ 400,000 | 0.05 | |||||
Cupcakes and so forth | ||||||||||
NPV | Probability | |||||||||
High | $ 4,500,000 | 0.45 | ||||||||
Medium | $ 2,300,000 | 0.35 | ||||||||
Low | $ 310,000 | 0.20 | ||||||||
,
Module 2 – Background
RISK: FREQUENCY DISTRIBUTION, PROBABILITIES, AND EXPECTED VALUE
Case Background: Frequency Diagrams (Histograms)
Histograms (frequency distribution diagram). Consider a repetitive process, for example, driving home from work. You (and your spouse) have noticed that it takes longer to get home sometimes than others. So you want to do an experiment and find out just how long it does take. You record your time to drive home for 6 weeks and get 30 data points. (5 days, 6 weeks). Then you decide to analyze this statistically and see just how frequent the short trips and long trips and medium trips take. The best way to do this is with a frequency diagram. Here is an example of what one looks like:
Note that you can analyze this data in more detail. And you can use it determine the Expected Value if you convert the raw frequencies into relative frequencies (probabilities.) The SLP will discuss the concept of Expected Value. In this example, the expected value is 44.3 minutes. Review this problem in the Excel file that you can download.
Watch this video that shows you how to do it:
View an example of a histogram. Download this Excel file with two examples and a Sample Problem: Case 2-Examples-Sample Problem.xlsx ( SEE ATTACHED BELOW)
PRACTICE: Now try the sample problem with the data in the downloaded Excel file.
· Follow the instructions in the file to create a histogram.
· Check your results by reviewing the last Tab in the file.
You should be ready to do the Case 2 Assignment.
SLP Background: Decision Making Under Risk
Recall from Module 1 Background that in decision situations there are three different levels of uncertainty: assumed certainty, risk, and uncertainty. In SLP 1, we covered assumed certainty. In this Module we will discuss RISK. Recall what it means for a decision under risk:
Risk. In this situation, the decision maker distinguishes several possible future states, and is able to determine the probabilities of these distinct futures, or estimate the probabilities with a degree of confidence. There may be few or many options to choose from and the outcomes of these options may be different in the possible future states. For example, consider the weather which is always risky. And we usually have some estimates of the future states based on what the weatherman says. Two possible states are Rain and No Rain. The choices to consider here might be: Walk w/no umbrella, Walk w/umbrella, or Drive. The decision maker can determine the probabilities of Rain/No Rain from the forecast, for example, 60% chance of Rain (and 40% No Rain.) There are costs and payoffs involved with each option. And different people may have different decisions to make. The office employee may need to decide to walk or ride to work. The farmer may need to decide to work in the fields or protect the crops.
In all of these decisions there are basic elements that must be determined before the decision can be made. First, determine the possible future states (F) and the probabilities (p) for each. Note that the law of probability requires that the DM identify all a set of mutually exclusive and collectively exhaustive set of future states. And the probabilities must sum to 1.0 (100%). Then the DM must identify the alternatives (A). Note this is a key step as specified in Module 1. The next step is to identify the outcomes (O), payoffs, or consequences of each alternative for each future state. Quite often in business, this will be a monetary value. Then the DM can use the concept of Expected Value to determine the probability payoff for each alternative which allows for choosing the best alternative.
Review the following PowerPoint introducing decision making under risk:
Introduction to Decisions Under Risk (PPT) ( SEE ATTACHED BELOW)
Download this Excel file that shows the example used in the video: SLP 2 Examples-Sample Problem.xlsx ) ( SEE ATTACHED BELOW)
Try the Sample problem in this Excel file. Check your solution.
You should be ready for SLP 2.
Additional Required Reading
(For Discussions, Modules 2, 3, and 4)
Download and read this paper on subjective probabilities in risk decisions. This paper will be useful for the discussion questions in Module 2, 3, and 4: Subjective Assessments of Risk and Uncertainty ) ( SEE ATTACHED BELOW)
Get this journal article from the library. It is lengthy, but you only need to read Section 1.1, pp. 3-5. This section provides a very good review of three major biases that have been studied by the famous team of Kahneman and Tversky.
Laibson, D., & Zeckhauser, R. (1998). Amos Tversky and the ascent of behavioral economics. Journal of Risk & Uncertainty. Feb1998, Vol. 16 Issue 1, p7-47. 41p. Retrieved from Business Source Complete (EBSCO)
Optional Reading
This is nice paper by Daniel Kahneman. It is the basis for his recent book, Thinking Fast and Slow.
Kahneman, D. (2003). Maps of Bounded Rationality: Psychology for Behavioral Economics, American Economic Review, December, 2003. Retrieved from Ebsco.
Reading for Module 3 to Read Now
This reading is important background for Cases 3 and 4. You should read it now to prepare for these coming Cases.
Chapter 2 (pp. 54–76), and Ch. 3 (pp. 77–91), from: Chase, C. W., (2013). Demand-Driven Forecasting: A Structured Approach to Forecasting, John Wiley & Sons: Somerset, NJ. Retrieved from the Ebrary.
,
Top of Form
Rubric Name: MBA/MSHRM/MSL SLP Grading Rubric for Quantitative Business Courses -Timeliness v1
|
Bottom of Form
Close
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.