Using the finished version of the file for , use a data table to perform a sensitivity analysis on the risk tolerance. Specifically, let the risk tolerance in cell B12 vary from $10,000 to $100,000 and keep track of two outputs in the data table, the TRUE/ FALSE value in cell B14 and the certainty equivalent in cell C15. Interpret the results.
Q: Given the data here, a. Compute the average return for each of the assets from 1929 to 1940 (the…
A: Use excel as follows to calculate average return , variance and standard deviation
Q: CA Corporate has an available funds of $200,000 is considering for new investment opportunities. The…
A: Investment portfolio of stocks is given as follows:
Q: Consider the sports ratings model . If you were going to give more recent games more weight, how…
A: The sports ratings model calculates the ratings of a sports team based on actual and predicted point…
Q: The finance function is primarily interested in the relationship between the risks of investments…
A: It is a true statement.
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: ANSWER : Given the value less then 0.5 is designated as " Heads " 0.180 Heads 0.571 Tails…
Q: If there are 6 ways to perform task A and 9 ways to perform task B, then how many ways are there to…
A: If there are 6 ways to perform Task A and 9 ways to perform Task B, then how many ways are there to…
Q: WHAT WLL HAPPEN IF THERE IS A CHANGE IS ONE OF THE OBJECTIVE FUNCTION COEFFICIENT? A. SLOPE OF THE…
A: Every change in the worth of a target work coefficient will lead to a changed optimal solution. When…
Q: For this equation. Daniel and his family recently moved to California. Daniel wants to know which…
A: given,
Q: The methods used to capture the effect of several sources of uncertainty will in practice often…
A: We will evaluate the statement and options The statement is that "the methods to capture the effect…
Q: A hardware company sells a lot of low-cost, highvolumeproducts. For one such product, it is…
A: given, low sales = 60,000 high sales = 100,000 variable cost per unit 25% chance of = $6…
Q: My current income is $40,000. I believe that I owe$8,000 in taxes. For $500, I can hire a CPA to…
A:
Q: an ongoing problem in managing service operations is that the selection of order qualifiers and…
A: an ongoing problem in managing service operations is that the selection of order qualifiers and…
Q: A hardware company sells a lot of low-cost, high volume products. For one such product, it is…
A:
Q: The methods used to capture the effect of several sources of uncertainty will in practice often…
A: Simulation helps in modelling random events that helps in evaluating the performance of various…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: In this question, we have to calculate the number of trials required for head and tail. Random…
Q: Explain the steps to be followed in Monte Carlo simulation
A: Monte Carlo simulation makes use of the concept of producing random numbers to generate values for…
Q: As the Quality Sweaters problem is now modeled, if all inputs remain fixed except for the number…
A: Here we consider the model of profit sensitivity to number of mailing, where profit increase…
Q: You own a coffee shop in a metro Toronto shopping mall. It is Friday evening and you are trying to…
A: We have to find the value of payoff for quality baked(Q)+demand(D) by using below formula
Q: A building contains 1000 lightbulbs. Each bulb lastsat most five months. The company maintaining…
A: In the above question, the company wants to decide whether the group replacement policy is…
Q: You are also given the following table of average returns over the last 50 years: Stocks T-Bonds…
A: (a) Utilizing the historical methodology, the estimate to calculate risk premium for Steel Products…
Q: Assets A and B are such that their returns are uncorrelated (zero correlation). The Sharpe ratios of…
A: Assets A and B are such that their returns are uncorrelated (zero correlation). The Sharpe ratios of…
Q: Which of the following statements are correct? [Select multiple answers] Income gap ratio (IGR)…
A: The below given statement is correct:-
Q: Select the least accurate statement regarding simulation. In a simulation, correlation between two…
A: In insights, connection or reliance is any factual relationship, if causal, between two arbitrary…
Q: If a simulation begins with the first random number, the first simulated value would be: Random…
A: Calculation of cumulative frequencies; Demand Frequency Cumulative frequency 0 0.15 0.15 1…
Q: A metropolitan school system consists of three districts—north, south, and central. The north…
A: A metropolitan school has different district where students studies, They have given details of…
Q: You are planning to save for retirement over the next 30 years. To do this, you will invest $800 a…
A: Although the stock and bond accounts have different interest rates, we can draw one timeline, but we…
Q: policy or mechanism could solve any informational imbalances
A: An EVPI (expected value of perfect information) is the difference between actual highest return and…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: Given simulations random numbers : 0.021, 0.323, 0.200, 0.157, 0.278, 0.886, 0.699, 0.038, 0.315,…
Q: Appliances Unlimited (AU) sells refrigerators. Anyrefrigerator that fails before it is three years…
A: Warranty refers to a facility that is provided to consumers in case of any malfunctioning product…
Q: Write “True” if the statement is true and write “False” if the statement is false. 1. With the…
A: 1. This statement is True. As after the emergence of the information era, most of the companies are…
Q: A restaurant borrows $15,200 from a local bank for 10 months. The local bank charges simple…
A: Given that: Principal(P) = $15200 For months (t) = 10 Interest rate annually = 4.55%
Q: Why is the RISKCORRMAT function necessary?How does @RISK generate random inputs by default,that is,…
A: RISKCORMMAT is considered as an function that helps in correlating two or more variables in the…
Q: Based on your understanding of portfolio risk, identify whether each statement is true or false.…
A: Correct answer is true Explanation: As with the diversification, we could be able to lower or reduce…
Q: A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand…
A:
Q: Select the least accurate statement regarding RISKSIMTABLE. RISKSIMTABLE is a feature that is…
A: The RiskSimtable function is used to enter a list of values which is used to enter a list of values,…
Q: Gap analysis predicts that a decrease in interest rates will result in a rise in bank profits when…
A: the quantity of rate sensitive assets is greater than the quantity of rate sensitive liabilities.
Q: You have recently won the super jackpot in the Washington State Lottery. On reading the fine print,…
A: Here, we need to compare two options. In order to do so, we must get the value of the two cash flow…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: Below is the solution:-
Q: You are thinking of starting Peaco, which will produce Peakbabies, a product that competes with Ty's…
A:
Q: All MBA students have to take entry test for admission to AUAF. Scores are normally distributed with…
A: Quality refers to the degree of excellence of something. Quality has some standard on the basis of…
Q: A software firewall development company is selling a solution against distributed denial of service…
A: DDoS Attack: A distributed denial-of-service (DDoS) attack is a malicious effort to disturb the…
Q: describe the probability that a consumer purchasing brand A in one time period
A: Introduction: The term Market refers to an exchange of goods and services between the buyer and the…
Q: 1.) True or false? Briefly explain. _____ Your firm has the opportunity to invest $20 million in a…
A: 1.TrueThe cost of capital of a company depends upon the borrowings of a company. In thequestion, the…
Q: Hashing and Load balancing are two related applications that govern the work of distributed load…
A: Probability theory is a part of science worried about the investigation of irregular phenomena.…
Q: Which of the following interpretations is correct about risk versus uncertainty? Risk is about…
A: Risk is described as the state of gaining or losing something good. Uncertainty is a situation where…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: In a random experiment, the probability is an indicator of how likely an occurrence is to take…
Using the finished version of the file for , use a data table to perform a sensitivity analysis on the risk tolerance. Specifically, let the risk tolerance in cell B12 vary from $10,000 to $100,000 and keep track of two outputs in the data table, the TRUE/ FALSE value in cell B14 and the certainty equivalent in cell C15. Interpret the results.
Step by step
Solved in 3 steps with 4 images
- Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)Software development is an inherently risky and uncertain process. For example, there are many examples of software that couldnt be finished by the scheduled release datebugs still remained and features werent ready. (Many people believe this was the case with Office 2007.) How might you simulate the development of a software product? What random inputs would be required? Which outputs would be of interest? Which measures of the probability distributions of these outputs would be most important?Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.
- Markov process models can be used to describe the probability that a consumer purchasing brand A in one time period 1.will sell brand A in the next period 2. all of the answers are correct. 3.will sell brand A after three time periods 4. will not purchase brand A in the next periodDiscuss how likely it is that 70% of students will pass a college course with a B or an A. Then, consider the following questions: Would you look at data showing the success rate of previous courses? Would you check whether the current GPA of students in your class is high or low? What other data would you like to have before you determine the probability of 70% of students passing this course with a B or an A?List down the most important types of probability distributions used in quality management?
- The Decision Variables in a What If analysis provide the limitations for each variable. True FalseJohnson Electronics Corporation makes electric tubes. It is known that the standard deviation of the lives of these tubes is 145 hours. The company's research department takes a sample of 90 such tubes and finds that the mean life of these tubes is 2300 hours. What is the probability that this sample mean is within 22 hours of the mean life of all tubes produced by this company? Round your answer to four decimal places. P =A television network earns an average of $25 million each season from a hit program and loses an average of $8 million each season on a program that turns out to be a flop. Of all programs picked up by this network in recent years, 25% turn out to be hits and 75% turn out to be flops. At a cost of C dollars, a market research firm will analyze a pilot episode of a prospec- tive program and issue a report predicting whether the given programwill end up being a hit. If the program is actually going to be a hit, there is a 75% chance that the market researchers will predict the program to be a hit. If the program is actually going to be a flop, there is only a 30% chance that the market researchers will predict the program to be a hit.a. What is the maximum value of C that the network should be willing to pay the market research firm?b. Calculate and interpret EVPI for this decision problem.
- No Pain Corp Omar Amman, the CEO of No Pain Corp (NPC), is under stress. They produce transcutaneus electrical nerve simulation units (TENS) for pain control. Amman faces a new opportunity and is not sure how to go about it. Recently, the the Department of Health of Canada has approved low current TENS devices to be sold directly to consumers without a doctor’s note. This will come into effect in three months. In the past, one needed a doctor’s note and could rent the device from some companies. These TENS machines, as they are called in Canada, are popular, since the older population has found them to be effective in pain control with almost no side effects. Amman can sell the device via drug-stores and pharmacies as well as on Amazon. But, Amman is not sure. Amman used to work as a supply chain manager for a power-tool company. Back then, it was a huge logistical “pain,” no pun intended, to work with large retailers and to attend to their fulfilment needs. Those retailers used to…What price do farmers get for their watermelon crops? In the third week of July, a random sample of 42 farming regions gave a sample mean of = $6.88 per 100 pounds of watermelon. Assume that σ is known to be $1.92 per 100 pounds. (a) Find a 90% confidence interval for the population mean price (per 100 pounds) that farmers in this region get for their watermelon crop (in dollars). What is the margin of error (in dollars)? (For each answer, enter a number. Round your answers to two decimal places.)lower limit $ upper limit $ margin of error $ (b) Find the sample size necessary for a 90% confidence level with maximal error of estimate E = 0.27 for the mean price per 100 pounds of watermelon. (Enter a number. Round up to the nearest whole number.) farming regions (c) A farm brings 15 tons of watermelon to market. Find a 90% confidence interval for the population mean cash value of this crop (in dollars). What is the margin of error (in dollars)? Hint: 1 ton is 2000…4. A credit rating company recommends granting of credit cards based on several criteria. One is annual income. If the annual income of applicants is normally dis- tributed with mean $22,000 and standard deviation $4,800 and the company recommends no applicant unless his or her income exceeds $15,000, what fraction of the applicants are denied on this basis?