We are considering investing in three stocks. The randomvariable Si represents the value one year from now of $1invested in stock i. We are given that E(S1) 1.15, E(S2) 1.21, E(S3) 1.09; var S1 0.09, var S2 0.04, var S3 0.01; cov(S1, S2) 0.006, cov(S1, S3) 0.004, and cov(S2,S3) 0.005. We have $100 to invest and want to have anexpected return of at least 15% during the next year.Formulate a QPP to find the portfolio of minimum variancethat attains an expected return of at least 15%.
Q: Suppose there is a Markov chain with the following transition matrix. 0.1 0.9 P = 0 0.3 0.7 0.5 0…
A: A transition matrix P is regular when some power of P has just positive entries. A Markov chain is a…
Q: SureStep is currently getting 160 regular-time hours from each worker per month. This is actually…
A: Productivity and complete output standards are met in an organization where the workers work with…
Q: Well-known financial writer Andrew Tobias argues that he can earn 177 percent per year buying wine…
A: The cost of a case of wine is 10 percent less than the cost of 12 individual bottles, so the cost of…
Q: There are three investments, B1, B2 and B3. All of them have the same expected value and each with…
A: Given data is
Q: W. L. Brown, a direct marketer of women’s clothing,must determine how many telephone operators…
A: The aforementioned question is answered as below:
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: 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: An inventor wants to maximize his profit form an investment in three stocks: A, B, & C, with a…
A: Linear programming (LP) is a mathematical modeling approach used by operations managers to come up…
Q: A market analyst working for a small appliance manufacturer finds that if the firm produces and…
A: Answer (a) When given a graph of a profit equation with the number of items produced on the x-axis…
Q: *(a) Maximize z = 4x1 + 6x2 + 2x3 subject to 4x, - 4x2 -X, + 6x2 -X1 + x2 + x35 5 X1, X2, Xz 2 (0…
A:
Q: Suppose savers either buy bonds or make deposits in savings accounts at banks. Initially, the…
A: A budget deficit is a situation when the country’s expenditure increased from its revenue.
Q: respectively, and let z be the total Maximize 2= 6x, + 12x, + 30x 8x, + 16x, + 20x s 45460 12x, +6x+…
A: Please follow the attachments:
Q: The person says that 2173 is a prime number because it ends in the number 3, and since 3 is a prime…
A: No, 2173 is not a prime number. It is a multiplication of 41 and 53 which are two prime numbers. I…
Q: 2. An analyst determines the intrinsic value of a stock to be equal to 255 lei. If the stock's…
A: The correct option is A) Overvalued Overview: To estimate a portfolio' intrinsic worth, portfolio…
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: A television set sells for $525 U.S. dollars. In the spot market, $1= 125 Japanese yen. If…
A: Note: We are authorized to answer only one question at a time. Since it is not mentioned which…
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: We have $1,000 to invest. All the money must be placedin one of three investments: gold, stock, or…
A:
Q: TRUE OR FALSE In a simplex maximization slack variable is added to convert the objective function…
A: Slack variables are added to convert the objective function to the equation.
Q: Blair & Rosen, Inc. (BSR) is a brokerage firm that specializes in investment portfolios designed to…
A: Note: - As we can answer only up to three subparts we will answer the first three subparts(a, b, and…
Q: A forest consists of two types of trees: those that are 0–5 ft and those that are taller than 5 ft.…
A: Step 1: As each year 40% of all 0-5ft trees die and other 10% are sold. That means the probability…
Q: Consider a firm in a competitive market with market price p. Which of the following statements are…
A: Different types of market structures can be classified on the basis of number of buyers and sellers…
Q: TRUE OR FALSE In the simplex minimization method, optimality is signaled by the presence of all…
A: In the optimal simplex table, cj-zj=0 value indicates an Alternative solution
Q: 7-37 Bbavika Investments, a group of financial advisors and retirement planners, is providing advice…
A: Decision Variable: Let, S be the dollars invested in the stock market M be the dollars invested in…
Q: I own a single share of Wivco stock. I must sell myshare at the beginning of one of the next 30…
A:
Q: Maximize the objective function 4x + 4y subject to the constraints. X + 2y < 28 3x + 2y 2 36 X20,…
A: Hi, we are supposed to answer one question at a time. Since you have not mentioned which question to…
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: 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: You have $50,000 to invest in three stocks. Let Ri be the random variable representing the annual…
A: The question can be solved using Excel solver. Objective: To find a minimum variance (minimum risk)…
Q: Let Xi be the price (in dollars) of stock i one year fromnow. X1 is N(15, 100) and X2 is N(20,…
A: Let Xi be the price of stock i year from now. For all i = 1,2 As per the given information, X1 and…
Q: In the figure below, no probabilities are known for the occurrence of the nature states. For the…
A: Note: - Since we can answer only three subparts, we will answer the first three subparts here. If an…
Q: The second-largest public utility in the nation is the sole provider of elasticity in 32 counties of…
A: Given data, Inverse demand function P =1200 -4Q Q1 kilowatts are produced at facility 1 Q2…
Q: In the time interval between t and t 1 seconds beforethe departure of Braneast Airlines Flight 313,…
A: The capacity of Flight is 100 passengers Duration is (t tp t-1) seconds the reservation probability…
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: The manager of a bakery knows that the number of chocolate cakes he can sell on any given day is a…
A:
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: h) Suppose that; Change the selling price of the 3 TL plain bun to (3 + 24) TL and the selling price…
A: For the solution to question h, we will first solve the LPP and then with the help of sensitivity…
Q: If An investor is considering investing in two securities A and B which promise a return of (10+X)%…
A: SOLUTION:
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: It has been suggested that at each iteration of the simplex algorithm, the entering variable should…
A: Since the entering variable will, in general, increase from 0 to a positive number, the value of the…
Q: Stock in Company A sells for $89 a share and has a 3-year average annual return of $24 a share. The…
A: Let; a be the number of shares in company A b be the number of shares in company B
Q: The values of the same 15 student in two subject A and B are given below the two numbers within the…
A: Rx Ry d=Rx-Ry d^2 1 10 -9 81 2 7 -5 25 3 2 1 1 4 6 -2 4 5 4 1 1 6 8 -2 4 7 3 4 16 8…
Q: A salesperson for Fuller Brush has three options: quit,put forth a low-effort level, or put forth a…
A:
Q: We are going to invest $1,000 for a period of 6 months.Two potential investments are available:…
A:
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…
We are considering investing in three stocks. The random
variable Si represents the value one year from now of $1
invested in stock i. We are given that E(S1) 1.15, E(S2)
1.21, E(S3) 1.09; var S1 0.09, var S2 0.04, var S3
0.01; cov(S1, S2) 0.006, cov(S1, S3) 0.004, and cov(S2,
S3) 0.005. We have $100 to invest and want to have an
expected return of at least 15% during the next year.
Formulate a QPP to find the portfolio of minimum variance
that attains an expected return of at least 15%.
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 6 images
- Based on Grossman and Hart (1983). A salesperson for Fuller Brush has three options: (1) quit, (2) put forth a low level of effort, or (3) put forth a high level of effort. Suppose for simplicity that each salesperson will sell 0, 5000, or 50,000 worth of brushes. The probability of each sales amount depends on the effort level as described in the file P07_71.xlsx. If a salesperson is paid w dollars, he or she regards this as a benefit of w1/2 units. In addition, low effort costs the salesperson 0 benefit units, whereas high effort costs 50 benefit units. If a salesperson were to quit Fuller and work elsewhere, he or she could earn a benefit of 20 units. Fuller wants all salespeople to put forth a high level of effort. The question is how to minimize the cost of encouraging them to do so. The company cannot observe the level of effort put forth by a salesperson, but it can observe the size of his or her sales. Thus, the wage paid to the salesperson is completely determined by the size of the sale. This means that Fuller must determine w0, the wage paid for sales of 0; w5000, the wage paid for sales of 5000; and w50,000, the wage paid for sales of 50,000. These wages must be set so that the salespeople value the expected benefit from high effort more than quitting and more than low effort. Determine how to minimize the expected cost of ensuring that all salespeople put forth high effort. (This problem is an example of agency theory.)Suppose you begin year 1 with 5000. At the beginning of each year, you put half of your money under a mattress and invest the other half in Whitewater stock. During each year, there is a 40% chance that the Whitewater stock will double, and there is a 60% chance that you will lose half of your investment. To illustrate, if the stock doubles during the first year, you will have 3750 under the mattress and 3750 invested in Whitewater during year 2. You want to estimate your annual return over a 30-year period. If you end with F dollars, your annual return is (F/5000)1/30 1. For example, if you end with 100,000, your annual return is 201/30 1 = 0.105, or 10.5%. Run 1000 replications of an appropriate simulation. Based on the results, you can be 95% certain that your annual return will be between which two values?In Problem 11 from the previous section, we stated that the damage amount is normally distributed. Suppose instead that the damage amount is triangularly distributed with parameters 500, 1500, and 7000. That is, the damage in an accident can be as low as 500 or as high as 7000, the most likely value is 1500, and there is definite skewness to the right. (It turns out, as you can verify in @RISK, that the mean of this distribution is 3000, the same as in Problem 11.) Use @RISK to simulate the amount you pay for damage. Run 5000 iterations. Then answer the following questions. In each case, explain how the indicated event would occur. a. What is the probability that you pay a positive amount but less than 750? b. What is the probability that you pay more than 600? c. What is the probability that you pay exactly 1000 (the deductible)?
- 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 60A European put option allows an investor to sell a share of stock at the exercise price on the exercise data. For example, if the exercise price is 48, and the stock price is 45 on the exercise date, the investor can sell the stock for 48 and then immediately buy it back (that is, cover his position) for 45, making 3 profit. But if the stock price on the exercise date is greater than the exercise price, the option is worthless at that date. So for a put, the investor is hoping that the price of the stock decreases. Using the same parameters as in Example 11.7, find a fair price for a European put option. (Note: As discussed in the text, an actual put option is usually for 100 shares.)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.)
- The annual demand for Prizdol, a prescription drug manufactured and marketed by the NuFeel Company, is normally distributed with mean 50,000 and standard deviation 12,000. Assume that demand during each of the next 10 years is an independent random number from this distribution. NuFeel needs to determine how large a Prizdol plant to build to maximize its expected profit over the next 10 years. If the company builds a plant that can produce x units of Prizdol per year, it will cost 16 for each of these x units. NuFeel will produce only the amount demanded each year, and each unit of Prizdol produced will sell for 3.70. Each unit of Prizdol produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. a. Among the capacity levels of 30,000, 35,000, 40,000, 45,000, 50,000, 55,000, and 60,000 units per year, which level maximizes expected profit? Use simulation to answer this question. b. Using the capacity from your answer to part a, NuFeel can be 95% certain that actual profit for the 10-year period will be between what two values?You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).The method for rating teams in Example 7.8 is based on actual and predicted point spreads. This method can be biased if some teams run up the score in a few games. An alternative possibility is to base the ratings only on wins and losses. For each game, you observe whether the home team wins. Then from the proposed ratings, you predict whether the home team will win. (You predict the home team will win if the home team advantage plus the home teams rating is greater than the visitor teams rating.) You want the ratings such that the number of predictions that match the actual outcomes is maximized. Try modeling this. Do you run into difficulties? (Remember that Solver doesnt like IF functions.) EXAMPLE 7.8 RATING NFL TEAMS9 We obtained the results of the 256 regular-season NFL games from the 2015 season (the 2016 season was still ongoing as we wrote this) and entered the data into a spreadsheet, shown at the bottom of Figure 7.38. See the file NFL Ratings Finished.xlsx. (Some of these results are hidden in Figure 7.38 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 19 New England versus team 25 Pittsburgh, played at New England. New England won the game by a score of 28 to 21, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.
- Referring to Example 11.1, if the average bid for each competitor stays the same, but their bids exhibit less variability, does Millers optimal bid increase or decrease? To study this question, assume that each competitors bid, expressed as a multiple of Millers cost to complete the project, follows each of the following distributions. a. Triangular with parameters 1.0, 1.3, and 2.4 b. Triangular with parameters 1.2, 1.3, and 2.2 c. Use @RISKs Define Distributions window to check that the distributions in parts a and b have the same mean as the original triangular distribution in the example, but smaller standard deviations. What is the common mean? Why is it not the same as the most likely value, 1.3?It is surprising (but true) that if 23 people are in the same room, there is about a 50% chance that at least two people will have the same birthday. Suppose you want to estimate the probability that if 30 people are in the same room, at least two of them will have the same birthday. You can proceed as follows. a. Generate random birthdays for 30 different people. Ignoring the possibility of a leap year, each person has a 1/365 chance of having a given birthday (label the days of the year 1 to 365). You can use the RANDBETWEEN function to generate birthdays. b. Once you have generated 30 peoples birthdays, how can you tell whether at least two people have the same birthday? One way is to use Excels RANK function. (You can learn how to use this function in Excels online help.) This function returns the rank of a number relative to a given group of numbers. In the case of a tie, two numbers are given the same rank. For example, if the set of numbers is 4, 3, 2, 5, the RANK function returns 2, 3, 4, 1. (By default, RANK gives 1 to the largest number.) If the set of numbers is 4, 3, 2, 4, the RANK function returns 1, 3, 4, 1. c. After using the RANK function, you should be able to determine whether at least two of the 30 people have the same birthday. What is the (estimated) probability that this occurs?An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.