You can find a spreadsheet containing annual returns on stocks end Treasury bonds in Connect. Copy the data for the last 20 years into a new spreadsheet, Analyze the risk return trade-off that would have characterized portfolios constructed from large stocks and long-term Treasury bonds over the last 20 years.
a. What was the average
b. What was the correlation coefficient of their annual returns?
c. What would have been the average return and standard deviation of portfolios with differing weights in the two assets? For example. consider weights in stocks starting at mm and incrementing by .10 up to a weight of 1.
d. What was the average return and standard deviation of the minimum-variance combination of stacks and bonds? (LO 6-2)
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
Connect 1-Semester Access Card for Essentials of Investments
- What is the stand-alone risk? Use the scenario data to calculate the standard deviation of the bonds return for the next year.arrow_forwardBond valuation related problems should be solved by using a financial calculator or MS excel spreadsheet. Accordingly, you must show the values of all relevant time valu of money variables If D1 = $1.25, g(which is constant) = 4.7%, and Po= $26.00 what is the stocks expected dividend yield for the coming year?arrow_forwardThe table below presents the returns on stocks ABC and XYZ for a five-year period. Year ABC XYZ 1 0.16 0.12 2 0.42 0.62 3 -0.02 -0.23 4 -0.26 -0.62 5 0.48 0.52 Calculate the average return, and standard deviation of stock ABC and XYZ. Also calculate the correlation between the two stocks. What does the correlation tell you about the return movements of the two stocks? Calculate the weight of each stock in the minimum variance portfolio, assume the expected return equals to average return for each stock. Find the mix of stocks ABC and XYZ that gives a portfolio on the efficient frontier AND demonstrate why this portfolio is on the efficient frontier by showing that there exists another portfolio of stocks ABC and XYZ that has the same level of risk (portfolio standard deviation) but inferior return. Hint: manipulate the weights you get from part b. Suppose the risk-free rate is 6%. Also assume the…arrow_forward
- Problem 3:Here are the annual returns for five different stocks. Determine the expected return and risk for a period of five years for each of the stocks. Problem 4:a. Find the coefficient of variation (CV) for each of the actions in problem 3.b. Explain which of the investments a risk averse investor would prefer and which a risk lover investor would prefer. Answer clearly and in detail. Show all the computations that led to the result.arrow_forwardYou are given the following returns on "the market" and Stock F during the last three years. We could calculate beta using data for Years 1 and 2 and then, after Year 3, calculate a new beta for Years 2 and 3. How different are those two betas, i.e., what's the value of beta 2 - beta 1? (Hint: You can find betas using the Rise-Over-Run method, or using your calculator's regression function.) Year Market Stock F 1 6.10% 19.50% 2 12.90% −3.70% 3 16.20% 21.71% A. 10.96 B. 10.91 C. 11.06 D. 11.01 E. 11.11 Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forwardYou have developed data which give (1) the average annual returns of the market for the past five years and (2) similar information on Stocks A and B. If these data are as follows, which of the possible answers best describes the historical beta for A and B? Please circle the correct answer: Years Market Stock A Stock B 1 .03 .16 .05 2 -.05 .20 .05 3 .01 .18 .05 4 -.10 .25 .05 5 .06 .14 .05 a. bA > 0; bB = 1. b. bA > +1; bB = 0. c. bA = 0; bB = -1. d. bA < 0; bB = 0. e. bA < -1; bB = 1.arrow_forward
- Using the data in the following table, LOADING... , consider a portfolio that maintains a 75% weight on stock A and a 25% 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. c. Show that (i) the average return of the portfolio is equal to the (weighted) average of the average returns of the two stocks, and (ii) the volatility of the portfolio equals the same result as from the calculation in Eq. 11.9. d. Explain why the portfolio has a lower volatility than the average volatility of the two stocks. Question content area bottom Part 1 a. What is the return each year of this portfolio? Enter the return of this portfolio for each year in the table below: (Round to two decimal places.) Year 2010 2011 2012 2013 2014 2015 Portfolio enter your response here% enter your response here% enter your response…arrow_forwardUsing the data in the following table,, 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. c. Show that (i) the average return of the portfolio is equal to the (weighted) average of the average returns of the two stocks, and (ii) the volatility of the portfolio equals the same result as from the calculation in Eq. 11.8. d. Explain why the portfolio has a lower volatility than the average volatility of the two stocks. a. What is the return each year of this portfolio? Enter the return of this portfolio for each year in the table below (Round to two decimal places.) Year Portfolio Data table 2010 % 2011 % 2012 % 2013 % (Click on the following icon in order to copy its contents into a spreadsheet.) 2014 2015 %1 1% Year 2010 2011 2012 2013 2014 2015 Stock A -10% 20% 5% 5% 2% 9% Stock B 21% 7% 30% -3% 8%…arrow_forwardThe following table represents the rate of returns of two stocks in different economic conditions along with their probabilities (the data are also uploaded on moodle) RATES OF RETURN ON STOCKS EXPECTED ECONOMIC PROBABILITY STOCK A STOCK B CONDITIONS RECESSION 0.55 -0.04 -0.02 STABLE 0.35 0.25 0.30 EXPANDING 0.10 0.15 0.20 Answer the following by using mathematical calculations: a) Calculate the expected rate of return for each stock respectively. Explain what the expected value implies. b) Calculate the standard deviation for each stock respectively. Explain what the standard deviation implies. c) If you were an investor in which stock you were going to invest? Justify your answer. d) Calculate the covariance between Stock A and stock B. Discuss. e) Calculate the expected return and the standard deviation of the portfolio consisting 40% in stock A and 60% in stock B. f) Discuss the risk and return associated with investing i All of your funds in stock A ii. All of your funds in stock…arrow_forward
- Using the data in the following table, consider a portfolio that maintains a 60% weight on stock A and a 40% 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. c. Show that (i) the average return of the portfolio is equal to the (weighted) average of the average returns of the two stocks, and (ii) the volatility of the portfolio equals the same result as from the calculation in Eq. 11.9. d. Explain why the portfolio has a lower volatility than the average volatility of the two stocks. a. What is the return each year of this portfolio? Enter the return of this portfolio for each year in the table below: (Round to two decimal places.) Year 2012 Portfolio % 2010 % 2011 % b. Based on your results from part (a), compute the average return and volatility of the portfolio. The average return of the portfolio is%. (Round to two decimal places.) 2013 % 2014 % 2015 % The…arrow_forwardYou are considering an investment in either individual stocks or a portfolio of stocks. The two stocks you are researching, Stock A and Stock B, have the following historical returns: Year r ̄A r ̄B 2014 -20.00% -5.00% 2016 42.00 15.00 2017 20.00 -13.00 2018 -8.00 50.00 2019 25.00 12.00 Calculate the average rate of return for each stock during the 5-year period. Suppose you had held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate of return on the portfolio in each year? What would have been the average return on the portfolio during this period? Calculate the standard deviation of returns for each stock and for the portfolio. Suppose you are a risk-averse investor. Assuming Stocks A and B are your only choices, would you prefer to hold Stock A, Stock B,…arrow_forwardBased on the information you have compiled below please calculate the average return and standard deviation over this 5 year period for each of the stocks and the portfolio. Once you have done that please explain to the Head Analyst how the results show the value of diversification.arrow_forward
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning