Question

In: Finance

Using the data in the following​ table,    2010   2011   2012   2013   2014   2015 Stock A  ...

Using the data in the following​ table,   

2010   2011   2012   2013   2014   2015
Stock A   -10%   20%   5%   -5%   2%   9%
Stock B   21%   7%   30%   -3%   -8%   25%

consider a portfolio that maintains a 50% weight on stock A and a 50% weight on stock B.

a. What is the return each year of this​ portfolio?

b. Based on your results from part ​(a​), compute the average return and volatility of the portfolio.

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.


Related Solutions

- 2010 2011 2012 2013 2014 2015 2016 2017 2018 GREECE 129059 135314 153317 160986 168501...
- 2010 2011 2012 2013 2014 2015 2016 2017 2018 GREECE 129059 135314 153317 160986 168501 167036 175100 181261 190523 SPAIN 377095 403834 419865 397462 427672 447048 451255 485805 497812 FRANCE 316137 322254 303269 303031 298203 297880 292160 302840 308629 CROATIA 24329 21862 18972 19366 18603 18930 18551 20798 21573 ITALY 494091 499885 476823 457078 443141 458020 461990 475164 501958 Selected 5 ports. a) Calculate the mean, standard deviation, median, minimum, maximum values of gross weight of goods handled in...
Year Annual Average CPI 2010 218.1 2011 224.9 2012 229.6 2013 232.9 2014 236.7 2015 237.0...
Year Annual Average CPI 2010 218.1 2011 224.9 2012 229.6 2013 232.9 2014 236.7 2015 237.0 2016 240.0 2017 245.1 2018 251.1 2019 255.6 From the table above, calculate the inflation rate from 2015 to 2016 (5 points) Use the table above to answer:  If you were earning $40,000/year in 2012, how much would you need to be earning in 2019 to have the same purchasing power?. (5 points) Use the table above to answer:  If average college tuition was $10,000 per...
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082...
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082 9,808 10,593 11,440 12,355 13,344 14,411 Revenue Growth 52.4% 22.6% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% Production Costs Fixed Production Expense (excl depreciation) 575 575 587 598 610 622 635 648 660 674 Variable Production Costs 2,035 3,404 4,291 4,669 5,078 5,521 6,000 6,519 7,079 7,685 Depreciation 152 152 152 152 164 178 192 207 224 242 Total Production Costs 0 2,762 4,131...
Years 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Retail Sales 5.2% 0.3%...
Years 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Retail Sales 5.2% 0.3% -3.3% 3.0% 4.9% 3.9% 3.1% 4.2% 3.8% 3.9% 3.6% e-commerce Sales 19% 4.1% 2.8% 17.1% 17.5% 14.9% 13.0% 14.6% 14.7% 14.0% 16.0% Does Retail Stores Growth Reduced by E-commerce Growth? Null Hypothesis: Ho: Retail stores growth doesn’t reduce by E-commerce growth. Alternative Hypothesis: Ha: Retail stores growth does reduce by E-commerce growth Do the chi-square test for goodness of fit. with the level of...
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026...
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 BVPS, start of year 7 7.61 8.51 9.51 10.73 11.77 13.17 14.4 15.91 17.58 19.43 21.47 23.72 25.38 27.16 29.06 EPS 0.81 1.1 1.3 1.52 1.64 2 2.03 2.16 2.39 2.64 2.91 3.22 2.37 2.54 2.72 2.91 ROE 0.116 0.145 0.153 0.16 0.153 0.17 0.154 0.15 0.15 0.15 0.15 0.15 0.1 0.1 0.1 0.1 Payout Ratio 0.247 0.182 0.231 0.197 0.366 0.3 0.394 0.3...
Year 2015 2014 2013 2012 2011 Net income $1042 $903 $753 $850 $805 Net sales $11454...
Year 2015 2014 2013 2012 2011 Net income $1042 $903 $753 $850 $805 Net sales $11454 $10773 $10459 $10364 $9613 Profit margin 9.1 8.4 7,2 8.2 8,4 Industry profit margin 2.8 2.5 8,2 2,2 2,1 How to create journal entries in a correct format for this problem.
You are given the following information about the economy. 2010 2011 2012 2013 u 0.03 0.09...
You are given the following information about the economy. 2010 2011 2012 2013 u 0.03 0.09 0.06 0.03 Y 2244 2343 1134 5678 The natural rate of unemployment is 0.04 and the Phillips curve relationship is ? = ?e - 2 (u - 0.04). Please show your work in answering the following questions: (a) Using the following formula ( Y(overbar)- Y)/ Y(overbar)= 2(u - u(overbar)) estimate full-employment level of output (Y(overbar)) in each year? (b) Calculate the growth rate of...
Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013...
Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013   Sales $ 2,500,000 $ 3,780,000 $ 4,340,000 $ 4,940,000 $ 5,510,000    What would be the forecast for next year’s sales using regression to estimate a trend?
Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013...
Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013   Sales: $ 2,430,000. $ 3,850,000 $ 4,440,000 $ 4,920,000 $ 5,540,000 What would be the forecast for next year’s sales using regression to estimate a trend? Next years sales?
Refer to the following mentioned data. (In millions) 2014 2013 2012 Net revenues $ 8,268 $...
Refer to the following mentioned data. (In millions) 2014 2013 2012 Net revenues $ 8,268 $ 8,052 $ 7,175 Cost of products sold 5,370 5,140 4,365 Gross margin $ 2,898 $ 2,912 $ 2,810 (a) Calculate the gross profit ratio for each of the past three years. (Round your answers to 1 decimal place.) (b) Assume that Campbell’s net sales for the first four months of 2015 totaled $2.7 billion. Calculate an estimated cost of goods sold and gross profit...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT