Question

In: Finance

year rA rB 2009 -20.50 -17.50 2010 20.50 29.30 2011 14.00 33.80 2012 -4.50 -7.10 2013...

year rA rB
2009 -20.50 -17.50
2010 20.50 29.30
2011 14.00 33.80
2012 -4.50 -7.10
2013 25.76 -3.25

Calculate the average rate of return for stock A during the period 2009 through 2013. Round your answer to two decimal places.
%______

Calculate the average rate of return for stock B during the period 2009 through 2013. Round your answer to two decimal places.
%_____

Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would the realized rate of return on the portfolio have been in each year? Round your answers to two decimal places.

Year Portfolio
2009 %
2010 %
2011 %
2012 %
2013 %

What would the average return on the portfolio have been during this period? Round your answer to two decimal places.
%_______

Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places.

Stock A Stock B Stock C
Std Dev

Calculate the coefficient of variation for each stock and for the portfolio. Round your answers to two decimal places.

Stock A Stock B Stock C
Coef. Var.

Solutions

Expert Solution

I have used excel to do the calculations. Please find below the snapshot of the solution:

  1. Below the values, I have inserted a row titled "Formula Used". That will help you to understand the formula in each cell used to calculate average return, std deviation and coefficient of variation.
  2. You can use the formula to understand the mathematics and create your own sheet.
  3. The final answers are highlighted in yellow.
  4. Stock C in your solution template actually refers to Portfolio. Portfolio return has been calculated as = wA.rA + wB.rB = 0.5 x rA + 0.5 x rB
  5. Coefficient of variation = standard deviation / average return
  6. In the end i have filled in the answers in your template. That will help you understand what need to be fed into the blanks.

Please have a look at the snapshot below:

So your final answers will be:

Calculate the average rate of return for stock A during the period 2009 through 2013. Round your answer to two decimal places.
% 7.05

Calculate the average rate of return for stock B during the period 2009 through 2013. Round your answer to two decimal places.
%7.05

Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would the realized rate of return on the portfolio have been in each year? Round your answers to two decimal places.

Year Portfolio
2009 -19.00%
2010 24.90%
2011 23.90%
2012 -5.80%
2013 11.26%

What would the average return on the portfolio have been during this period? Round your answer to two decimal places.
%7.05

Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places.

Stock A Stock B Stock C (Portfolio)
Std Dev 17.16% 20.59% 17.11%

Calculate the coefficient of variation for each stock and for the portfolio. Round your answers to two decimal places.

Stock A Stock B Stock C (Portfolio)
Coef. Var.                                        2.43                                             2.92                                   2.43

Related Solutions

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?
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 ​Goods: exports ​77,939 ​102,175 ​123,876 ​153,530 ​199,065 ​167,958 ​230,967 ​307,847 ​298,321 ​319,110 ​329,633 ​Goods: imports ​-95,539 ​-134,692 ​-166,572 ​-208,611 ​-291,740 ​-247,908 ​-324,320 ​-428,021 ​-450,249 ​-433,760 ​-415,529      Balance on goods ​-17,600 ​-32,517 ​-42,696 ​-55,081 ​-92,675 ​-79,950 ​-93,353 ​-120,174 ​-151,928 ​-114,650 ​-85,895 ​Services: credit ​38,281 ​52,527 ​69,440 ​86,552 ​106,054 ​92,889 ​117,068 ​138,528 ​145,525 ​148,649 ​156,252 ​Services: debit ​-35,641 ​-47,287 ​-58,514 ​-70,175 ​-87,739 ​-80,349 ​-114,739 ​-125,041...
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...
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.
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...
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...
Exxon Mobil Chevron ($millions) 2011 2010 2009 2011 2010 2009 Revenue... $486,429 $383,221 $310,586 $253,706 $204,958...
Exxon Mobil Chevron ($millions) 2011 2010 2009 2011 2010 2009 Revenue... $486,429 $383,221 $310,586 $253,706 $204,958 $171,636 Cost of revenue... 306,802 233,751 185,833 171,572 135,655 117,510 Selling, general, & administrative expenses... 88,459 79,348 75,490 20,373 22,958 22,118 Net income... 41,060 30,460 19,280 26,895 19,024 10,483 Accounts receivable... 38,642 32,284 27,645 21,793 20,759 17,703 Dividends paid... 6326 8,779 8,303 6,210 5,746 5,373 Use the information above to forecast the next two year revenue for Exxon Mobil. Based your forecasts on the...
- 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...
a) Jane was a tax resident in 2011, 2012, 2013 and is planning to work in...
a) Jane was a tax resident in 2011, 2012, 2013 and is planning to work in Hong Kong throughout the year 2014. Jane will be returning to Malaysia in February 2015 and will then reside permanently in Kuala Lumpur. Required: For the basis year for the year of assessment 2014, determine Jane’s residence status. Explain and support your answer with relevant sections of the Income Tax Act 1967. b) In determining the residence status of an individual, certain periods of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT