(a) Download returns.xls, and clear the contents of columns F - Z (you will only need...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(a) Download "returns.xls", and clear the contents of columns F - Z (you will only need the data contained in columns A - E). In columns G and H, compute the annual net simple return of value and growth stocks in natural units by tak- ing an weighted average of big value and small value for value and a weighted average of big growth and small growth for growth, with of weight of 0.9 on big and 0.1 on small (e.g., in G3, put =(B3*0.9+D3*0.1)/100, and in H3, put =(C3*0.9+E3*0.1)/100). Also compute the average annual return, variance and standard deviation for both value and growth, using the average, var, and stdev functions in Excel. These are our estimates of the expected return, variance and standard deviation. (b) Calculate the covariance of value stocks with growth stocks using the covar func- tion. If value had a high return in a year, what would you expect happened to growth? What is the correlation coefficient? (c) Now we are going to look at portfolios of value and growth stocks. Find four empty columns next to each other. Put -0.5 in the first cell of the first column, and -0.45 in the cell below it. Select both cells, grab the lower right corner of the selection box, and drag down until you have created a column that runs from -0.5 to 1.5 in increments of 0.05 - this column contains the possible portfolio weights of growth stocks. In the first cell of the second column, calculate the expected return of the associated portfolio. Fill the third column with variances based on the weights in the first column. Use the fourth column to take the square roots of these variances (the standard deviations). (d) Now plot the portfolio standard deviation as a function of weight on growth stocks. (e) Now plot the mean-standard deviation frontier for value and growth in the mean- stdev diagram using a similar procedure. Make sure that the standard deviation is on the horizontal axis. Where is the efficient frontier? What is (approximately) the global minimum variance portfolio? What is the mean and standard deviation of the return for that portfolio? How does it compare with the mean and standard deviation of value and growth? (f) Now we will construct the efficient frontier when there also exists a safe asset. Assume that the annual riskfree rate of return is rƒ = 2%. In a fifth column next to the previous four columns, compute the Sharpe-ratio of the various portfolios of value and growth. Which portfolio has the highest Sharpe-ratio? What is the mean and standard deviation of this (approximate) tangency portfolio? Where is the efficient frontier now? = (g) Suppose that you would like to invest in a portfolio of value stocks, growth stocks, and the riskfree asset. If your coefficient of risk aversion is A : 5, what is the composition of your optimal portfolio (what are the shares of your wealth invested in value, growth and the riskfree asset)? What is the mean and standard deviation of the annual portfolio return? (h) Now suppose that you wish to hold a portfolio of value, growth and the riskfree asset such that the standard deviation of your annual return is equal to 16%. What is the composition of your optimal portfolio? What is the mean and standard deviation of the annual portfolio return? (a) Download "returns.xls", and clear the contents of columns F - Z (you will only need the data contained in columns A - E). In columns G and H, compute the annual net simple return of value and growth stocks in natural units by tak- ing an weighted average of big value and small value for value and a weighted average of big growth and small growth for growth, with of weight of 0.9 on big and 0.1 on small (e.g., in G3, put =(B3*0.9+D3*0.1)/100, and in H3, put =(C3*0.9+E3*0.1)/100). Also compute the average annual return, variance and standard deviation for both value and growth, using the average, var, and stdev functions in Excel. These are our estimates of the expected return, variance and standard deviation. (b) Calculate the covariance of value stocks with growth stocks using the covar func- tion. If value had a high return in a year, what would you expect happened to growth? What is the correlation coefficient? (c) Now we are going to look at portfolios of value and growth stocks. Find four empty columns next to each other. Put -0.5 in the first cell of the first column, and -0.45 in the cell below it. Select both cells, grab the lower right corner of the selection box, and drag down until you have created a column that runs from -0.5 to 1.5 in increments of 0.05 - this column contains the possible portfolio weights of growth stocks. In the first cell of the second column, calculate the expected return of the associated portfolio. Fill the third column with variances based on the weights in the first column. Use the fourth column to take the square roots of these variances (the standard deviations). (d) Now plot the portfolio standard deviation as a function of weight on growth stocks. (e) Now plot the mean-standard deviation frontier for value and growth in the mean- stdev diagram using a similar procedure. Make sure that the standard deviation is on the horizontal axis. Where is the efficient frontier? What is (approximately) the global minimum variance portfolio? What is the mean and standard deviation of the return for that portfolio? How does it compare with the mean and standard deviation of value and growth? (f) Now we will construct the efficient frontier when there also exists a safe asset. Assume that the annual riskfree rate of return is rƒ = 2%. In a fifth column next to the previous four columns, compute the Sharpe-ratio of the various portfolios of value and growth. Which portfolio has the highest Sharpe-ratio? What is the mean and standard deviation of this (approximate) tangency portfolio? Where is the efficient frontier now? = (g) Suppose that you would like to invest in a portfolio of value stocks, growth stocks, and the riskfree asset. If your coefficient of risk aversion is A : 5, what is the composition of your optimal portfolio (what are the shares of your wealth invested in value, growth and the riskfree asset)? What is the mean and standard deviation of the annual portfolio return? (h) Now suppose that you wish to hold a portfolio of value, growth and the riskfree asset such that the standard deviation of your annual return is equal to 16%. What is the composition of your optimal portfolio? What is the mean and standard deviation of the annual portfolio return?
Expert Answer:
Answer rating: 100% (QA)
To address the question based on the information provided in the search results a To compute the annual net simple return of value and growth stocks i... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1285190907
8th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Obtain monthly stock-price data for the following stocks from Yahoo Finance (http://finance.yahoo.com/). Watch the video Chapter 12, Part 8. Also, the video Using Stock Price Data with Excel (posted...
-
Big bang Pty (Ltd) is a company which is involved in sale of manufacturing goods. The company had the following income and expenses for the year of assessment: R15 000 for the collection of debts...
-
A car drives straight down toward the bottom of a valley and up the other side on a road whose bottom has a radius of curvature of 115 m. At the very bottom, the normal force on the driver is twice...
-
Tables in the news Find a frequency table of categorical data from a newspaper, a magazine, or the Internet. 1. Is it clearly labeled? 2. Does it display percentages or counts? 3. Does the...
-
Teddys daily budget constraint is shown in the following chart. Teddys employer pays him a base wage rate plus overtime if he works more than the standard hours. What is Teddys daily nonlabor income?...
-
The payroll of YellowCard Company for September 2013 is as follows. Total payroll was $480,000, of which $110,000 is exempt from Social Security tax because it represented amounts paid in excess of...
-
Write a three page paper on Compare and contrast Online Analytic Processing (OLAP) and Online Transaction Processing (OLTP); also discuss Codds rules for TP databases and OLAP databases. Cite any...
-
On January 1, 2022, Mobile Technology, Incorporated issued $850,000 of $1,000 par value, 6%, 6-year bonds. Interest is payable semiannually each January 1 and July 1 with the first interest payment...
-
(1 point) Suppose f(x, y) = x + y and D is the closed triangular region with vertices (4, 0), (0, 4), and (0, 4). Answer the following. 4x - 1. Find the absolute maximum of f(x, y) on the region D....
-
A company's operating cash flow and its free cash flow Multiple choice question. differ in that free cash flow subtracts capital expenditures are basically the same thing differ in that free cash...
-
I need help with a code that mitigates the vulnerability IDS50-J. Use conservative file naming conventions. File and path name with certain characters can cause the error when used as a file or path...
-
Joyce and Melvin have been married for 30 years. In 2020, they received $22,000 of Social Security benefits and had $12,000 of interest income. What portion of the Social Security benefit is taxable?
-
The faculty ________ vowed to oppose further budget cuts. Question 24 options: has are have is
-
Relocating 200 employees from one building to another is your new responsibility in a recent company reorganization. Because there is a large volume of people involved with this project, a multiphase...
-
Estimate the area between the graph of the function f and the interval [a, b]. Use an approximation scheme with n rectangles similar to our treatment of f(x) = x in this section. If your calculating...
-
Use the graphs of f and g to graph h(x) = (f + g) (x). To print an enlarged copy of the graph, go to MathGraphs.com. 1. 2. y 24 8. 2. -2 -2 4 6
-
Whirlpool manufactures and sells home appliances under various brand names. IBM develops and manufactures computer hardware and offers related technology services. Target operates a chain of general...
-
Henry Company is a marketer of branded foods to retail and foodservice channels. Exhibit 6.18 presents Henry's income statements for Year 10, Year 11, and Year 12. Notes to the financial statements...
-
Using the following key, identify the effects of the following transactions or conditions on the various financial statement elements: I ¼ increases; D ¼ decreases; NE ¼ no...
-
Describe how competence, caring, and character affect your credibility as a communicator.
-
Explain the importance of establishing credibility for business communications.
-
Define and explain business ethics, corporate values, and personal values.
Study smarter with the SolutionInn App