2. Sheila earned a $88,000 bonus which she would like to invest in the stock market....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. Sheila earned a $88,000 bonus which she would like to invest in the stock market. She is planning to buy shares of AMI and BCM. The expected annual return is $2.75 per share for AMI and $5.75 per share for BCM. AMI costs $27 per share and BCM costs $52 per share. Sheila would like to limit the risk in her stock portfolio. The risk is 0.45 per share of AMI and 0.35 per share of BCM. She wants the total risk of her stock portfolio to be at most 800. In addition, to make sure the portfolio is diversified she wants to invest in no more than 1200 shares of BCM. a) Formulate a linear optimization model that Sheila could use to decide how many shares of each stock to buy in order to maximize the total expected annual return of the portfolio subject to the constraints. b) Use Excel to solve the linear optimization problem. Submit your Excel file (not a screen capture). c) How many shares of each stock should Sheila purchase? d) What is the expected annual return of the portfolio? e) Which constraints are binding? 2. Sheila earned a $88,000 bonus which she would like to invest in the stock market. She is planning to buy shares of AMI and BCM. The expected annual return is $2.75 per share for AMI and $5.75 per share for BCM. AMI costs $27 per share and BCM costs $52 per share. Sheila would like to limit the risk in her stock portfolio. The risk is 0.45 per share of AMI and 0.35 per share of BCM. She wants the total risk of her stock portfolio to be at most 800. In addition, to make sure the portfolio is diversified she wants to invest in no more than 1200 shares of BCM. a) Formulate a linear optimization model that Sheila could use to decide how many shares of each stock to buy in order to maximize the total expected annual return of the portfolio subject to the constraints. b) Use Excel to solve the linear optimization problem. Submit your Excel file (not a screen capture). c) How many shares of each stock should Sheila purchase? d) What is the expected annual return of the portfolio? e) Which constraints are binding?
Expert Answer:
Related Book For
Statistics For Business And Economics
ISBN: 9780321826237
12th Edition
Authors: James T. McClave, P. George Benson, Terry T Sincich
Posted Date:
Students also viewed these finance questions
-
Since Ryanair DAC's2 emergence as an upstart challenger to the Aer Lingus Ltd.-British Airways plc duopoly in the late 1980s, it had been both a consumer champion and antagonist; a technological...
-
It is July 1, 2023, Jim and Pam Halpert have just left your office after their first interview with you. In preparation for the interview, you had sent them a list of the various documents that they...
-
Trade promotions refer to offers made to Group of answer choices channel members non-profit organizations businesses consumers Question 2 Consumer promotions refer to offers made to Group of answer...
-
On January 6, Jacob Co. sells merchandise on account to Harley Inc. for $9,200, terms 1/10, n/30. On January 16, Harley pays the amount due. Instructions Prepare the entries on Jacob Co.'s books to...
-
A control break field __________. a. Always is output prior to any group of records on a control break report b. Always is output after any group of records on a control break report c. Never is...
-
For Problem 6.8, (a) Fit the corresponding negative binomial model with the same linear predictor. (b) Compare the analysis between part (a) and that from Problem 6.8. 6.8 For the Sexual Health pilot...
-
Determining sales and variable cost volume variances Todhunter Publications established the following standard price and costs for a hardcover picture book that the company produces. Todhunter...
-
(5 pts) In early 2020, The Week reported that the median wage for Costco's employees is almost $39,000. This is higher than the median wage for all Americans and much higher than Walmart's median...
-
Assuming the data are normal, what is the probability the blade weights from this process will exceed 5.20? What is the probability that weights will be less than 4.80? What is the actual percent of...
-
1. Determine the ultimate load capacity of the 600 mm diameter concrete bored pile shown in the figure below. Use a - method for clay. 0.6 Clay Cu = 60 kN/m Y = 18 kN/m3 %3D 4m G.W.T Sand 6m 0 = 30 Y...
-
Explain the concept of replacing inventory by information within an organization. Why should a customer be concerned about transit inventory cost, if they pay for the inventory only when the...
-
Write an Argument essay about Single Parent Struggle Find at least three (3) sources to support your argument. Add in-text citations from these sources to your paper in order to support your thesis....
-
Ponder about a clock pulse with 50 MHz frequency. A flip-flop is used to divide the frequency by 2 (you do NOT need to know what a flip-flop is, or how it works at this stage). Ourgoal is to get a...
-
A 70 C charge is located at a point where the electric potential is 300 V. What is the electric potential energy of this charged particle? A. How much time is needed to transfer a 4 C charge acted on...
-
Explain with the help of an example how external and internal forces can result in organizational change.
-
In the following code, three processes are synchronized using two semaphores L and R and produce output using the routine putc. (a) How many D's are printed when these processes run? (b) Is...
-
In the operation of an automated production line with storage buffers, what does it mean if a buffer is nearly always empty or nearly always full?
-
Production processes may be classified as make-to-stock processes or make-to-order processes. Make-to-stock processes are designed to produce a standardized product that can be sold to customers from...
-
Government data indicate that the mean hourly wage for manufacturing workers in the United States is $18.50 (Statistical Abstract of the United States: 2012). Suppose the distribution of...
-
Refer to Exercise 2.18. Calculate the number of the 500 measurements falling into each of the measurement classes. Then graph a frequency histogram for these data. Exercise 2.18 Graph the relative...
-
Stadler Corporations federal income tax rate is 34 percent. It reports $100,000 depreciation expense on its financial statements and deducts $140,000 depreciation expense on its tax return. How...
-
Which of the following items is not deductible? a. Dues for club used solely for business meetings b. Directly related business entertainment c. Business gift of less than $25 in value d. Dues for...
-
John is a teacher at a local high school. During 2017, he travels three days per week to a school in the next county to work with gifted children in an after-school program that does not end until...
Study smarter with the SolutionInn App