Concept explainers
The following are the monthly
Month Madison Cookies Sophie Electric
1 −0.04 0.07
2 0.06 −0.02
3 −0.07 −0.10
4 0.12 0.15
5 −0.02 −0.06
6 0.05 0.02
Compute the following.
a. Average monthly rate of return Ri for each stock
b. Standard deviation of returns for each stock
c. Covariance between the rates of return
d. The correlation coefficient between the rates of return
What level of correlation did you expect? How did your expectations compare with the computed correlation? Would these two stocks be good choices for diversification? Why or why not?
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps
- Use the times and corresponding closing prices of the stock to create coordinate pairs. Let x represent the number of weeks since the first data point, and let y represent the closing price at each time. So, x=0 represents the data point from 5 years ago. There are 52 weeks in a year, and you can write the time for each closing price recorded in terms of weeks that have passed since 5 years ago, when x=0. Fill in the table to represent your data as coordinate pairs. x (weeks since 5 yrs ago) most recent 260 7days ago 259 1 month ago 256 6 months ago 234 1 year ago 208 3 years ago 104 5 years ago 0 y (closing price, in $) most recent 7 days ago 1 month ago 6 months ago 1 year ago 3 years ago 5 years agoarrow_forwardcks A and B have the following historical returns: Year 2016 2017 2018 2019 2020 Stock A's Returns, ra (17.90%) 30.00 13.25 (3.50) 29.75 Stock B's Returns, ra (14.20%) 22.70 a. Calculate the average rate of return for each stock during the period 2016 through 2020. Round your answers to two decimal places. Stock A 39.50 (7.10) 10.70 Stock B b. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock 8. What would the realized rate of return on the portfolio have been each year? Round your answers to two decimal places. Negative values should be indicated by a minus sign. Year 2016 2017 2018 2019 2020 What would the average return on the portfolio have been during this period? Round your answer to two decimal places. Portfolio CV e. Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? ele Calculate the standard deviation of returns for each stock and for the portfolio. Hound your answers to two decimal places.…arrow_forwardStocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rA 2014 (19.00 (14.70 %) 2015 34.75 19.50 2016 13.75 30.90 2017 (4.25 (9.30 ) 2018 34.25 33.10 Calculate the coefficient of variation for each stock and for the portfolio. Round your answers to two decimal places. Stock A Stock B Portfolio CV Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio?arrow_forward
- A stock has had the following year-end prices and dividends: Year 1234 in 10 5 6 Price $64.68 71.55 77.35 63.62 73.81 83.25 Dividend Arithmetic average return. Geometric average return $.67 .72 .78 .87 .94 What are the arithmetic and geometric returns for the stock? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g.. 32.16. % %arrow_forwardStocks A and B have the following historical returns: Year 2016 2017 2018 2019 2020 Stock A's Returns, ra (15.40%) 29.00 14.25 (5.00) 26.00 Stock B's Returns, ra (15.80%) 21.10 37.30 (6.20) 12.45 a. Calculate the average rate of return for each stock during the period 2016 through 2020. Round your answers to two decimal places. Stock A: Stock B: b. 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 each year Round your answers to two decimal places. Negative values should be indicated by a minus sign. Portfolio CV Year 2016 2017 2018 2019 2020 What would the average return on the portfolio have been during this period? Round your answer to two decimal places. % % % c. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places. Stock A Stock B Portfolio Standard Deviation d. Calculate the coefficient of variation for each…arrow_forwardYou find a certain stock that had returns of 16 percent, −23 percent, 24 percent, and 9 percent for four of the last five years. The average return of the stock over this period was 10.2 percent. a. What was the stock’s return for the missing year? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) b. What is the standard deviation of the stock’s returns? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)arrow_forward
- please help me out here !!!!arrow_forwardA stock has had returns of 10 percent, 17 percent, 26 percent, −14 percent, 24 percent, and −9 percent over the last six years. What are the arithmetic and geometric average returns for the stock? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)arrow_forwardStocks A and B have the following historical returns:YearStock A's Returns, raStock B's Returns, ra2016(18.60%)(14.50%)201734.2520.40201814.7539.902019(1.00)(9.70)202026.7520.05a. Calculate the average rate of return for each stock during the period 2016 through 2020. Round your answers to two decimal places.Stock A:11.23%Stock B:11.23%b. 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 each year? Round your answers to two decimal places. Negative values should be indicated by a minus sign.YearPortfolio2016-16.55%201727.33201827.33%2019-5.35202023.40What would the average return on the portfolio have been during this period? Round your answer to two decimal places.11.23c. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places.Stock AStock BPortfolioStandard Deviationd. Calculate the coefficient of variation for each…arrow_forward
- A stock has had returns of 39.00 percent, 23.00 percent, 34.00 percent, -11.00 percent, 21.00 percent, and -53.00 percent over the last six years. What are the arithmetic and geometric returns for the stock? (Do not round intermediate calculations. Round the final answers to 2 decimal places.) Arithmetic average return Geometric average returnarrow_forwardD (Solving a comprehensive problem) Use the end-of-year stock price data in the popup window, E, to answer the following questions for the Harris and Pinwheel companies. a. Compute the annual rates of return for each time period and for both firms. b. Calculate both the arithmetic and the geometric mean rates of return for the entire three-year period using your annual rates of return from part a. (Note: you may assume that neither firm pays any dividends.) c. Compute a three-year rate of return spanning the entire period (i.e., using the ending price for period 1 and ending price for period 4). d. Since the rate of return calculated in part c is a three-year rate of return, convert it to an annual rate of return by using the following equation: W S J-(₁. 1+ e. How is the annual rate of return calculated in part d related to the geometric rate of return? When you are evaluating the performance of an investment that has been held for several years, what Time 1 X 2 3 4 Time 1 3 2 3 4 #…arrow_forwardStocks A and B have the following historical returns:YearStock A's Returns, raStock B's Returns, ra2016(18.60%)(14.50%)201734.2520.40201814.7539.902019(1.00)(9.70)202026.7520.05a. Calculate the average rate of return for each stock during the period 2016 through 2020. Round your answers to two decimal places.Stock A:11.23%Stock B:11.23%b. 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 each year? Round your answers to two decimal places. Negative values should be indicated by a minus sign.YearPortfolio2016-16.55%201727.33201827.33%2019-5.35202023.40What would the average return on the portfolio have been during this period? Round your answer to two decimal places.11.23c. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places.Stock AStock BPortfolioStandard Deviationd. Calculate the coefficient of variation for each…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education