# 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 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 #### 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 ...
##### 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...
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. 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...
##### 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...
##### 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.)...
##### 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...
##### 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...
##### 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...