How does one construct a tornado diagram

Assignment Help Other Subject
Reference no: EM132146495

Homework - Sensitivity Analysis & Basic Probability

Homework Questions:

Part A -

1) Questions

a. What is a sensitivity study? Why does one perform them?

b. What are the three types of sensitivity studies that should be performed on which one should perform Sensitivity Studies?

c. In what order should they be conducted? Why?

2) Suppose one has $1000 to invest for 1 year. One can invest in a CD that will make between 4% and 6% (expected value of 5%). One can invest in Stock. If one invests in stock, one can expect the brokerage fee to be between $50 and $100 (expected value of $75). One can expect that the return on the stock will be between -15% and +40% (expected value of +12.5%).

a. Develop an "Input Variable Range Table".

b. What is the "Base" Net Investment Profit (NIP) for each investment?

c. Perform a 1-Sided Sensitivity study for the effect of each variable on the NIP. (Note there are two cases CD case and Stock Case).

d. Develop a Tornado Diagram from this study.

e. For which variables does it make sense to model as an uncertain event? Why?

3) Consider problem 2) above. Suppose you believe that the probability that the market will go up is somewhere between 20% and 30% (expected value is 25%). Assuming expected values for CD rate and brokerage fee,

a. Develop a decision tree model for this.

b. What is the expectation value for the buy stock decision? How does it compare to the CD decision option? Which decision option would you recommend? Why?

c. Perform a probability sensitivity analysis. How is your decision recommendation affected by this result? Why?

4) Clemen 1st and 2nd Edition: Read the "Facilities Investment and Expansion Case Study"

or

Clemen 3rd Edition: Read the Strenlar Case Study (Ch. 4, pp. 171-172) and Strenlar Part II (Ch. 5, pp. 229). a. Create Tornado diagrams for each decision options using the variables suggested to analyze the sensitivity.

b. Based on your analysis, discuss your results and the implications for Fred's decision model. If he were to refine his model, what refinements should he make?

In order to do a good job with the analysis, a number of assumptions must be made. Assume the following:

  • $8 million in profits is the present value of all profits to be realized over time.
  • $35 million in sales is also the present value of all future sales.
  • Fred Wallace's interest rate is 7.5% per year.
  • Fred's time frame is 10 years. We will use 10 years to evaluate the job offer and the lump sum.
  • If Fred goes to court, he continues to be liable for the $500,000 he owes. The $8 million in profits is net after repaying the $500,000. As indicated in the case, If Fred and PI reach an agreement, then PI repays the debt.
  • If Fred accepts the lump sum and options, and if the manufacturing process works, then the options pay 70,000 × $12 at a point 18 months in the future. Thus, the present value of the options is 12×70,000/1.03753= $752,168. That is, we figure three periods at 3.75% per period. The purpose of this is simply to put a value on the options.
  • The options are non-transferable. Thus, there is no need to figure out the "market value" of the options.

Facilities Investment and Expansion Case Study

a. Develop a Tornado Diagram for the top 10 variables.

Part B -

1) Questions:

a. Identify and briefly describe the three major types of Probability?

b. Identify and briefly describe the two major types of Random Variable?

c. Identify and briefly describe the two major types of probability distributions?

d. How does the type of distribution determine how one calculates the mean or variance of a distribution or data set? Provide equations.

Some Other Potential Test Questions:

1) What is a Type III Error?

2) What is a Type I Error? A Type II Error?

3) What is a one-way sensitivity study?

4) What is a two-way sensitivity study?

5) What is a tornado diagram? What does it permit you to do?

6) How does one construct a tornado diagram?

7) Given the American Eagle Example done in class, perform a High/Low r analysis.

a. Determine the Base, High and Low r value EV for the purchase decision

b. Does the range in r or the range cause a greater variance in the EV for the purchase decision? Explain.

8) What are the four Axioms of Probability Theory?

9) What are the four Fundamental Theorems?

10) What does it mean for two events to be independent?

11) What does it mean for two events to be mutually exclusive?

12) What is the difference between a Probability Mass Function (PMF) and a Probability Density Function (PDF)?

13) Is a PDF a probability? Explain why or why not.

14) What is a Cumulative Distribution Function? How is it related to the PMF and PDF?

15) What is an "expectation value" of a distribution or data set?

16) What is a "Random Variable" (RV)?

17) How is the Variance of a RV related to the mean of the RV and the expectation value of the square of the RV?

18) How does one calculate the standard deviation for a distribution or data set?

19) What does the mean tell you about a distribution/data set? What does the standard deviation tell you?

20) What is the covariance of two variables? What does it measure?

Reference no: EM132146495

Questions Cloud

Explain the role and function of the agency : Identify at least two significant regulations enforced by each agency relevant to Solar Co.'s business (totaling eight regulations).
What are the three biggest risks the firm faces : Redesign the product risk factor matrix so that the factors are appropriate for a services firm that delivers traditional tax accounting and audit services.
Demonstrate professional competency : INCS-870 - Demonstrate professional competency in one or more emphasis areas - communicate effectively and specifically demonstrate an ability to design
Describe the types and forms of businesses : Describe the types and forms of businesses, how businesses make money, and business stakeholders. Describe the three business activities of financing, investing
How does one construct a tornado diagram : ENEE/ENMG 672 Homework - Sensitivity Analysis & Basic Probability. How does one construct a tornado diagram. What is a two-way sensitivity study
How does hardys conceptualization of vocation : How does Hardy's conceptualization of vocation and the "divine economy" specifically connect with the codified work/job design theory outlined.
Define accounting and describe its role in business : Accounting, the language of business allows for the communication and distribution of information to owners, managers, and investors to evaluate a company's.
Describe transactions and source documents : This chapter focuses on the accounting process. We describe transactions and source documents, and we explain the analysis and recording of transactions.
What leadership theory does this scenario describes : In contrast to them, the other five team members did the routine jobs assigned to them. What leadership theory does this scenario describes?

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd