1 answer

I must need excel formula Spreadsheet Exercise: Chapter 8 Jane is considering investing in three different...

Question:

i must need excel formula

Spreadsheet Exercise: Chapter 8 Jane is considering investing in three different stocks or creating three distinct twostock p

9% 2017 2018 14% 12% 15% 15% 10% In any of the possible two-stock portfolios, the weight of each stock in the portfolio will

e. Would you recommend that Jane invest in the single stock A or the portfolio consisting of s your answer from a risk-return

c. Calculate the average returns for portfolios AB, AC, and BC. Port. AB Port. AC Port. BC Year 2012 2013 2014 2015 2016 2017

& 2015 2016 2017 2018 & Expected return & $ 8 d. Calculate the standard deviations for portfolios AB, AC, and BC Port AB Port

1 T U W pun LUNSSUING UT SOCKS A and BYE your answer from a risk return viewpoint. with a standard deviation of 0.00% , so th


Spreadsheet Exercise: Chapter 8 Jane is considering investing in three different stocks or creating three distinct twostock portfolios. Jane views herself as a rather conservative investor. She is able to obtain historical returns for the three securities for the years 2012 through 2018. The data are given in the following table. Stock C 129 13 Year 2012 2013 2014 2015 2016 2017 2018 Stock A 10% 13% 15% 14% 16% 1496 12 Stock B 10% 11% 8% 12% 10% 15% 15% 10% 1196 9 106 In any of the possible two-stock portfolios, the weight of each stock in the portfolio will be 50%. The three possible portfolio combinations are AR, AC and BC To Do Chapter w P21481217104 t o e SAMSUNG
9% 2017 2018 14% 12% 15% 15% 10% In any of the possible two-stock portfolios, the weight of each stock in the portfolio will be 50%. The three possible portfolio combinations are AB, AC, and BC. 24 To Do Create a spreadsheet similar to Tables 86 and 8.7 to answer the following a. Calculate the average return for each individual stock b. Calculate the standard deviation for each individual stock e. Calculate the average returns for portfolios AB, AC, and BC d. Calculate the standard deviations for portfolios AB, AC, and BC e. Would you recommend that Jane invest in the single stock A or the portfolio consisting of stocks A and B? Explain your answer from a risk return viewpoint. 1. Would you recommend that Jane invest in the single stock B or the portfolio consisting of stocks B and C? Explain You we r k return viewpoint Solution Chapter SAMSUNG
e. Would you recommend that Jane invest in the single stock A or the portfolio consisting of s your answer from a risk-return viewpoint. 1. Would you recommend that Jane invest in the single stock B or the portfolio consisting of sto your answer from a risk return viewpoint. Solution a. Calculate the average return for each individual stock. Stock A Stock B Stock C Expected return b. Calculate the standard deviation for each individual stock. Stock A Stock B Stock c Standard deviation Coefficient of variation to the Chapter 3 formali ADADA 248214017101140 . L o e
c. Calculate the average returns for portfolios AB, AC, and BC. Port. AB Port. AC Port. BC Year 2012 2013 2014 2015 2016 2017 2018 Expected return Chapter 8 2 검색하려면 여기에 입력하십시오. SAMSUNG اه اه اهالالالالالا
& 2015 2016 2017 2018 & Expected return & $ 8 d. Calculate the standard deviations for portfolios AB, AC, and BC Port AB Port. AC Port BC Standard deviation Coefficient of variation e. Would you recommend that Jane invest in the single stock A or the portfolio consisting of stocks A and B your answer from a risk return viewpoint. lixplain with a standard deviation of 0.0096 there is both 0.00% Steck A has an expected return of 0.00% Investing in the portfolio has a standard deviation of amount of risk and return in the portfolio We can see that the CV of the portfolio is should be recommended than that of stock alone, so the portfolio of AB 이 여기에 임하십시오 SAMSUNG ااااالالالالالالالالالا
1 T U W pun LUNSSUING UT SOCKS A and BYE your answer from a risk return viewpoint. with a standard deviation of 0.00% , so there is both a 0.00% Stock A has an expected return of 0.00% Investing in the portfolio has a standard deviation of amount of risk and return in the portfolio. We can see that the CV of the portfolio is should be recommended than that of stock A alone, so the portfolio of AB 1. Would you recommend that Jane invest in the single stock B or the portfolio consisting of stocks B and CP Explain your answer from a risk return viewpoint. Stock B has an expected return of 0.00% with a standard deviation of 0.00% Investing in the portfolio comprised of stocks B and delivers a return of 0.00% and is associated with a standard deviation of 0.00% . So both the return and risk of the portfolio are Considering the CV, however, Jane, can determine that is preferable to because the CV is lower. Chapter 8 10 검색하려면 여기에 입력하십시오. SAMSUNG الاااالالالالالالالت

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: &...