Why is the RISKCORRMAT function necessary?How does @RISK generate random inputs by default,that is, when RISKCORRMAT is not used?
Q: What does the worst-case scenario simulation model tell you that Monte Carlo simulation does not?…
A: Worst case scenario – It deals with the worst-case scenario. When making a net present value…
Q: Why does this formula not function?
A: THE ANSWER IS AS BELOW:
Q: The finance function is primarily interested in the relationship between the risks of investments…
A: It is a true statement.
Q: Which of the following statements about scenario analysis is NOT correct? Scenario analysis can help…
A: The answer is option D . Scenario analysis is an analysis of the the environment in which a business…
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: Health care is continually in the news. Can (or should)simulation be used to help solve, or at least…
A: Let’s first understand what are the problems of health care these days and how can we solve them…
Q: If a company employs n salespersons, its gross sales in thousands of dollars may be regarded as a…
A:
Q: Suppose you are a financial analyst and your company runs many simulation models to estimate the…
A: Simulation modeling: A simulation model is a computerized model that would depict or imitate a…
Q: We all hate to bring small change to the store. Usingrandom numbers, we can eliminate the need for…
A: a) The product bought by the customer at a price is $0.20 The customer will be paying the amount of…
Q: We must invest all our money in two stocks: x and y.The variance of the annual return on one share…
A:
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: 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: A salesperson in a large bicycle shop is paid a bonus ifhe sells more than 4 bicycles a day. The…
A: Our task is to simulate n number of days and find the bonus earned by the salesman each day using…
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: Which of the following statements is true ? 1.Average values generated from a simulation are…
A: Correct answer is
Q: Suppose you want to have $700,000 for retirement in 30 years. Your account earns 8% interest. How…
A: Given Amount at time of retirement = $ 700,000 Number of years = 30years Rate =8% Principal amount=?…
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: True or False: If our explanatory variables do not vary, our model will produce no estimates
A: In regression analysis, there are explanatory variables and response variables. Explanatory…
Q: 2. A daily demand for loaves of bread at a grocery store is given by the fllowing probability…
A: Given data is
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: The members of a private golf club have handicaps that are normally distributedwith mean 15 and…
A: Hence, the standard deviation of sample mean is 1.75.
Q: For an integer linear programming model to be appropriate representation of a real-world problem,…
A: Proportionality assumption: It is one of the key assumptions for the log rant test usage and Cox…
Q: Assuming homogenous and independent exposures, the effects of risk pooling arrangements can be…
A: Risk pooling is an arrangement where all risk is shared amongest a group of insurance companies…
Q: 53. Why is the RISKCORRMAT function necessary?How does @RISK generate random inputs by default,that…
A: RISKCORMMAT is considered as an function that helps in correlating two or more variables in the…
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: output variable of interest from a simulation model will be a............ Variable Independent…
A: Random Variable
Q: Suppose that there are two types of persons: high-ability and low-ability. A diploma costs a…
A: Given, Diploma costs to a high-ability person = $20,000 Diploma costs a low-ability person = $50,000…
Q: Suppose that Pizza King and Noble Greek stopadvertising but must determine the price they will…
A: Let us first find all the possible actions available to Pizza King in this case: 1) Pizza King sell…
Q: You are thinking of starting Peaco, which will produce Peakbabies, a product that competes with Ty’s…
A:
Q: In economics, the multiplier effect refers to the fact that when there is an injection of money to…
A: given, $8 billion tax spend = 83%
Q: The manager of a bakery knows that the number of chocolate cakes he can sell on any given day is a…
A:
Q: Which of the following is NOT a determinant of the demand for good X?
A: The price of the good or service. The income of buyers. The prices of related goods or…
Q: MacBurger has just opened a fast-food restaurant inBloomington. Currently, i0 customers frequent…
A: Currency Frequency of Mac Burger is i_{0} customers and (N-i_{0}) customers frequent another…
Q: A valid reason for using simulation model is: a. analyze relationship between the variables which…
A: Simulation modeling is nothing but the technique of developing and examining automated or digital…
Q: We all hate to keep track of small change. By us-ing random numbers, it is possible to eliminate the…
A: Suppose a random number between 0 and 1 is built into the cash register system and it is rounded off…
Q: A Mortgage Backed Bond differs from a Pass-Through Security in that I. the MBB does not result in…
A: A CMO may be a form of security (MBS) with separate pools of security mortgages that have variable…
Q: Home mortgage lenders often charge points on a loan in order to avoid exceeding a legal limit on…
A: Given data, The lender would loan $98 for each $100 borrowed The borrower receives $ 98 Loan…
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: 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…
Why is the RISKCORRMAT function necessary?
How does @RISK generate random inputs by default,
that is, when RISKCORRMAT is not used?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- You are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)Big Hit Video must determine how many copies of a new video to purchase. Assume that the companys goal is to purchase a number of copies that maximizes its expected profit from the video during the next year. Describe how you would use simulation to shed light on this problem. Assume that each time a video is rented, it is rented for one day.If you want to replicate the results of a simulation model with Excel functions only, not @RISK, you can build a data table and let the column input cell be any blank cell. Explain why this works.
- The IRR is the discount rate r that makes a project have an NPV of 0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where guess" is your best guess for the IRR. It is best to try a range of guesses (say, 90% to 100%). Find the IRR of the project described in Problem 34. 34. Consider a project with the following cash flows: year 1, 400; year 2, 200; year 3, 600; year 4, 900; year 5, 1000; year 6, 250; year 7, 230. Assume a discount rate of 15% per year. a. Find the projects NPV if cash flows occur at the ends of the respective years. b. Find the projects NPV if cash flows occur at the beginnings of the respective years. c. Find the projects NPV if cash flows occur at the middles of the respective years.Based on Kelly (1956). You currently have 100. Each week you can invest any amount of money you currently have in a risky investment. With probability 0.4, the amount you invest is tripled (e.g., if you invest 100, you increase your asset position by 300), and, with probability 0.6, the amount you invest is lost. Consider the following investment strategies: Each week, invest 10% of your money. Each week, invest 30% of your money. Each week, invest 50% of your money. Use @RISK to simulate 100 weeks of each strategy 1000 times. Which strategy appears to be best in terms of the maximum growth rate? (In general, if you can multiply your investment by M with probability p and lose your investment with probability q = 1 p, you should invest a fraction [p(M 1) q]/(M 1) of your money each week. This strategy maximizes the expected growth rate of your fortune and is known as the Kelly criterion.) (Hint: If an initial wealth of I dollars grows to F dollars in 100 weeks, the weekly growth rate, labeled r, satisfies F = (I + r)100, so that r = (F/I)1/100 1.)Suppose you have invested 25% of your portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the file P11_46.xlsx. The correlations between the annual returns on the four stocks are also shown in this file. a. What is the probability that your portfolios annual return will exceed 30%? b. What is the probability that your portfolio will lose money during the year?
- Rerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate decreases from the value used in the example, 10%.Assume that all of a companys job applicants must take a test, and that the scores on this test are normally distributed. The selection ratio is the cutoff point used by the company in its hiring process. For example, a selection ratio of 25% means that the company will accept applicants for jobs who rank in the top 25% of all applicants. If the company chooses a selection ratio of 25%, the average test score of those selected will be 1.27 standard deviations above average. Use simulation to verify this fact, proceeding as follows. a. Show that if the company wants to accept only the top 25% of all applicants, it should accept applicants whose test scores are at least 0.674 standard deviation above average. (No simulation is required here. Just use the appropriate Excel normal function.) b. Now generate 1000 test scores from a normal distribution with mean 0 and standard deviation 1. The average test score of those selected is the average of the scores that are at least 0.674. To determine this, use Excels DAVERAGE function. To do so, put the heading Score in cell A3, generate the 1000 test scores in the range A4:A1003, and name the range A3:A1003 Data. In cells C3 and C4, enter the labels Score and 0.674. (The range C3:C4 is called the criterion range.) Then calculate the average of all applicants who will be hired by entering the formula =DAVERAGE(Data, "Score", C3:C4) in any cell. This average should be close to the theoretical average, 1.27. This formula works as follows. Excel finds all observations in the Data range that satisfy the criterion described in the range C3:C4 (Score0.674). Then it averages the values in the Score column (the second argument of DAVERAGE) corresponding to these entries. See online help for more about Excels database D functions. c. What information would the company need to determine an optimal selection ratio? How could it determine the optimal selection ratio?Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of 150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of 250 per room. a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100. b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?
- Although the normal distribution is a reasonable input distribution in many situations, it does have two potential drawbacks: (1) it allows negative values, even though they may be extremely improbable, and (2) it is a symmetric distribution. Many situations are modelled better with a distribution that allows only positive values and is skewed to the right. Two of these that have been used in many real applications are the gamma and lognormal distributions. @RISK enables you to generate observations from each of these distributions. The @RISK function for the gamma distribution is RISKGAMMA, and it takes two arguments, as in =RISKGAMMA(3,10). The first argument, which must be positive, determines the shape. The smaller it is, the more skewed the distribution is to the right; the larger it is, the more symmetric the distribution is. The second argument determines the scale, in the sense that the product of it and the first argument equals the mean of the distribution. (The mean in this example is 30.) Also, the product of the second argument and the square root of the first argument is the standard deviation of the distribution. (In this example, it is 3(10=17.32.) The @RISK function for the lognormal distribution is RISKLOGNORM. It has two arguments, as in =RISKLOGNORM(40,10). These arguments are the mean and standard deviation of the distribution. Rework Example 10.2 for the following demand distributions. Do the simulated outputs have any different qualitative properties with these skewed distributions than with the triangular distribution used in the example? a. Gamma distribution with parameters 2 and 85 b. Gamma distribution with parameters 5 and 35 c. Lognormal distribution with mean 170 and standard deviation 60Rework the previous problem for a case in which the one-year warranty requires you to pay for the new device even if failure occurs during the warranty period. Specifically, if the device fails at time t, measured relative to the time it went into use, you must pay 300t for a new device. For example, if the device goes into use at the beginning of April and fails nine months later, at the beginning of January, you must pay 225. The reasoning is that you got 9/12 of the warranty period for use, so you should pay that fraction of the total cost for the next device. As before, how-ever, if the device fails outside the warranty period, you must pay the full 300 cost for a new device.A common decision is whether a company should buy equipment and produce a product in house or outsource production to another company. If sales volume is high enough, then by producing in house, the savings on unit costs will cover the fixed cost of the equipment. Suppose a company must make such a decision for a four-year time horizon, given the following data. Use simulation to estimate the probability that producing in house is better than outsourcing. If the company outsources production, it will have to purchase the product from the manufacturer for 25 per unit. This unit cost will remain constant for the next four years. The company will sell the product for 42 per unit. This price will remain constant for the next four years. If the company produces the product in house, it must buy a 500,000 machine that is depreciated on a straight-line basis over four years, and its cost of production will be 9 per unit. This unit cost will remain constant for the next four years. The demand in year 1 has a worst case of 10,000 units, a most likely case of 14,000 units, and a best case of 16,000 units. The average annual growth in demand for years 2-4 has a worst case of 7%, a most likely case of 15%, and a best case of 20%. Whatever this annual growth is, it will be the same in each of the years. The tax rate is 35%. Cash flows are discounted at 8% per year.