Answers
Excel Formulas are present in the below table
Stock A | Stock B | Stock C | ||||
2012 | 10.00% | 10.00% | 12.00% | |||
2013 | 13.00% | 11.00% | 14.00% | |||
2014 | 15.00% | 8.00% | 10.00% | |||
2015 | 14.00% | 12.00% | 11.00% | |||
2016 | 16.00% | 10.00% | 9.00% | |||
2017 | 14.00% | 15.00% | 9.00% | |||
2018 | 12.00% | 15.00% | 10.00% | |||
Expected Return | 13.43% | 11.57% | 10.71% | |||
Standard Deviation | 0.019880596 | 0.026367 | 0.017995 | |||
Coefficient of Variation | 0.148046991 | 0.227866 | 0.167951 | |||
Weighted Average | 0.5 | |||||
Stock AB | Stock BC | Stock CA | ||||
2012 | 10.00% | 11.00% | 11.00% | |||
2013 | 12.00% | 12.50% | 13.50% | |||
2014 | 11.50% | 9.00% | 12.50% | |||
2015 | 13.00% | 11.50% | 12.50% | |||
2016 | 13.00% | 9.50% | 12.50% | |||
2017 | 14.50% | 12.00% | 11.50% | |||
2018 | 13.50% | 12.50% | 11.00% | |||
Overall Expected Return | 12.50% | 11.14% | 12.07% | |||
Standard Deviation | 0.014719601 | 0.014058 | 0.009322 | |||
Coefficient of Variation | 0.117756812 | 0.126159 | 0.077226 | |||
Stock A has an expected return of | 13.43% | with a standard deviation of | 0.019881 | |||
Investing in port. AB has return of | 12.50% | with a standard deviation of | 0.01472 | |||
so there is both a | Low | amount of risk and return in the portfolio | ||||
We can see that the CV of portfolio is | smaller | than that of stock A alone, so the portfolio AB should be recommended | ||||
Stock B has an expected return of | 11.57% | with a standard deviation of | 0.026367 | |||
Investing in port. BC has return of | 11.14% | with a standard deviation of | 0.014058 | |||
so there is both a | low | amount of risk and return in the portfolio | ||||
We can see that the CV of portfolio is | smaller | than that of stock B alone, so the portfolio BC should be recommended |
Stock A | Stock B | Stock C | ||||
2012 | 0.1 | 0.1 | 0.12 | |||
2013 | 0.13 | 0.11 | 0.14 | |||
2014 | 0.15 | 0.08 | 0.1 | |||
2015 | 0.14 | 0.12 | 0.11 | |||
2016 | 0.16 | 0.1 | 0.09 | |||
2017 | 0.14 | 0.15 | 0.09 | |||
2018 | 0.12 | 0.15 | 0.1 | |||
Expected Return | =AVERAGE(B2:B8) | =AVERAGE(C2:C8) | =AVERAGE(D2:D8) | |||
Standard Deviation | =STDEV(B2:B8) | =STDEV(C2:C8) | =STDEV(D2:D8) | |||
Coefficient of Variation | =B11/B9 | =C11/C9 | =D11/D9 | |||
Weighted Average | 0.5 | |||||
Stock AB | Stock BC | Stock CA | ||||
2012 | =$B$14*B2+$B$14*C2 | =$B$14*C2+$B$14*D2 | =$B$14*D2+$B$14*B2 | |||
2013 | =$B$14*B3+$B$14*C3 | =$B$14*C3+$B$14*D3 | =$B$14*D3+$B$14*B3 | |||
2014 | =$B$14*B4+$B$14*C4 | =$B$14*C4+$B$14*D4 | =$B$14*D4+$B$14*B4 | |||
2015 | =$B$14*B5+$B$14*C5 | =$B$14*C5+$B$14*D5 | =$B$14*D5+$B$14*B5 | |||
2016 | =$B$14*B6+$B$14*C6 | =$B$14*C6+$B$14*D6 | =$B$14*D6+$B$14*B6 | |||
2017 | =$B$14*B7+$B$14*C7 | =$B$14*C7+$B$14*D7 | =$B$14*D7+$B$14*B7 | |||
2018 | =$B$14*B8+$B$14*C8 | =$B$14*C8+$B$14*D8 | =$B$14*D8+$B$14*B8 | |||
Overall Expected Return | =$B$14*B9+$B$14*C9 | =$B$14*C9+$B$14*D9 | =$B$14*D9+$B$14*B9 | |||
Standard Deviation | =STDEV(B17:B23) | =STDEV(C17:C23) | =STDEV(D17:D23) | |||
Coefficient of Variation | =B26/B24 | =C26/C24 | =D26/D24 | |||
Stock A has an expected return of | =B9 | with a standard deviation of | =B11 | |||
Investing in port. AB has return of | =B24 | with a standard deviation of | =B26 | |||
so there is both a | Low | amount of risk and return in the portfolio | ||||
We can see that the CV of portfolio is | smaller | than that of stock A alone, so the portfolio AB should be recommended | ||||
Stock B has an expected return of | =C9 | with a standard deviation of | =C11 | |||
Investing in port. BC has return of | =C24 | with a standard deviation of | =C26 | |||
so there is both a | low | amount of risk and return in the portfolio | ||||
We can see that the CV of portfolio is | smaller | than that of stock B alone, so the portfolio BC should be recommended |
Similar Solved Questions
1 answer
Question 3 O ou 15 ml of 0.01 M HCl was used to titrate 30 ml...
Question 3 O ou 15 ml of 0.01 M HCl was used to titrate 30 ml of Ca(OH)2. Calculate the Ksp of Ca(OH)2....
1 answer
Fill in the blanks in the following separate income statements a through e. a b с...
Fill in the blanks in the following separate income statements a through e. a b с d e Sales $ 71,000 $ 44,000 $ 37,000 $ 26,900 8,600 16,970 5,100 4,320 58,000 7,100 25,000 5,900 5,800 2,600 8,700 Cost of goods sold Merchandise inventory beginning Total cost of merchandise purchases Merchandis...
1 answer
Wendell's Donut Shoppe is investigating the purchase of a new $33,000 donut-making machine. The new machine...
Wendell's Donut Shoppe is investigating the purchase of a new $33,000 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $5,700 per year. In addition, the new machine would allow the company to produce one new style ...
1 answer
Put the following equation into its graphing form by completing the square. a des applet like...
Put the following equation into its graphing form by completing the square. a des applet like we did in class. What are the x-intercepts and the vertex of this equation? y=x2 - 4x +9...
1 answer
28. Marvin Bridges is a 25 percent partner in the Munson partnership. On November 23, 2017,...
28. Marvin Bridges is a 25 percent partner in the Munson partnership. On November 23, 2017, Marvin contributes property with an adjusted basis of $75,000 and a fair market value of $250,000 to the Munson partnership. On March 15, 2018, Marvin receives a $187,500 cash distribution from the partnershi...
1 answer
A school teacher has a list of leftover school supplies from previous semesters. The teacher woul...
A school teacher has a list of leftover school supplies from previous semesters. The teacher would like to maintain an ordered list of the supplies. Write a program in C that reads in the data (a list of supplies in random order) from a file, orders the items by name, and writes the ordered list to ...
1 answer
QP Corp. sold 5,410 units of its product at $45.90 per unit during the year and...
QP Corp. sold 5,410 units of its product at $45.90 per unit during the year and incurred operating expenses of $6.90 per unit in selling the units. It began the year with 690 units in inventory and made successive purchases of its product as follows. Jan. 1 Beginning inventory Feb. 20 Purchase May 1...
1 answer
Question 1 1 pts The common stock of Ecolab pays an annual dividend of $1.84 a...
Question 1 1 pts The common stock of Ecolab pays an annual dividend of $1.84 a share. The company has promised to maintain a constant dividend regardless of economic conditions. How much would investors be willing to pay for one share of Ecolab's stock assuming an equity cost of capital of 13.6%...
1 answer
1. Consider the following two period consumption savings problem. A consumer cares about consumption (c and...
1. Consider the following two period consumption savings problem. A consumer cares about consumption (c and future consumption c according to Assume that U(c) is given by for some constant y. In the present the consumer chooses how much to consume and how much to save out of her income y>0 This d...
1 answer
Question 14 2 pts What is the name of the structures where the spores are produced...
Question 14 2 pts What is the name of the structures where the spores are produced in this plant? Next → Question 23 2 pts In the diagram of the life cycle of a plant shown below, what is the name of the generation represented by letter 'A'? mitosis А. B fertilization Diploid Hapl...
1 answer
Let (x1, x2) be some interior bundle on the budget constraint, and suppose p1 = 4...
Let (x1, x2) be some interior bundle on the budget constraint, and suppose p1 = 4 and p2 = 2. If the marginal rate of substitution at (x1, x2) is -3, then is (x1, x2) optimal? Explain why or why not, and justify your answer with economic intuition. (Partial credit for a purely graphical argument.)...
1 answer
Physics 2010 Spring 2019 Rotational motion 2. When talking about rotational motion, instead of linear distance...
Physics 2010 Spring 2019 Rotational motion 2. When talking about rotational motion, instead of linear distance we talk about angular distance (also oros eros called angular displacement) Angular displacement is marked by either 0 or ф and is measured in radians. (a) How many radians is one tri...
1 answer
Pharoah Company incurred the following costs during the current year in connection with its research and...
Pharoah Company incurred the following costs during the current year in connection with its research and development activities. Cost of equipment acquired that will have alternative uses in future R&D projects over the next 5 years (uses straight-line depreciation) Materials consumed in R&D...
1 answer
A) With a fixed probability of p for scoring three pointers, a basketball player takes 5...
a) With a fixed probability of p for scoring three pointers, a basketball player takes 5 independent shots. What is the probability that he scores 1 shot in the first 3, and 1 again in the last 2 shots? b) In a series of indepedent and identically distributed Bernoulli trials, why is the index of th...
1 answer
A. Consider a plane traveling with a velocity of 100 km/hr, South that encounters a side...
A. Consider a plane traveling with a velocity of 100 km/hr, South that encounters a side wind of 25 km/hr, West. Now what would the resulting velocity of the plane be? B. Suppose that a river is moving with a velocity of 3 m/s, North and a motorboat is moving with a velocity of 4 m/s, East. What wou...
1 answer
MATLAB Coding Please state the right answer and give a little explanation why it's the right...
MATLAB Coding Please state the right answer and give a little explanation why it's the right answer. Incorrect Question 9 0/1 pts A numerical algorithm is used to solve the following system of equations: x1 - x2 = 2 -2x1 + 5x2 = -1 The numerical results are x1 = 2.98 and x2 = 1.03. The Euclidean...
1 answer
1. Make the following TVM calculations. Present Value a. A trust fund is being set up...
1. Make the following TVM calculations. Present Value a. A trust fund is being set up by a single payment P so that in 10 years, there will be $25,000. If the fund earns interest at the rate of 8% compounded annually, how much money should be paid into the fund initially? Pricing a Bond b. Dr. No fr...
1 answer
Part 3 (Lab2a) In this exercise you will: a. Write a method called secondTime that takes...
Part 3 (Lab2a) In this exercise you will: a. Write a method called secondTime that takes as argument an integer corresponding to a number of seconds, computes the exact time in hours, minutes and seconds, then prints the following message to the screen: <inputseconds> seconds corresponds to: &...