Building an active portfolio. In this problem, we will build an active portfolio, that is, a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Building an active portfolio. In this problem, we will build an active portfolio, that is, a portfolio consisting of individually selected stocks to complement our passive investments. To do this, create an Excel worksheet. Use the following instructions with a market risk premium TM-T; of 5%. Consider the following annualized information regarding a selection of six stocks (Apple Inc, Amazon.com Inc, Intuitive Surgical Inc, Target Corp, Walmart Inc, and Exxon Mobil Corp) and the S&P 500 that we have obtained from a regression analysis: SD of SD of Excess Beta Systematic Return SD of Residual Component S&P 500 0.1701 1.00 0.1701 0.0000 $AAPL 0.2869 1.20 0.2041 0.2016 $AMZN 0.3554 1.60 0.2721 0.2286 $ISRG 0.3409 1.50 0.2551 0.2261 $TGT 0.2761 0.80 0.1361 0.2403 $WMT 0.2296 0.60 0.1020 0.2057 $XOM 0.2163 0.85 0.1446 0.1609 • Find the covariance matrix according to the index model, where the covariance between two assets is defined as Cov(r) = BB,o. [Hint: You can find the σ from the above table if you compute the covariance of the index with itself because ẞS&P 500 = 1.] • Create a forecast of a for each company, that is, the return in percent you anticipate in excess over the return expected through its ẞ in the coming year. [Example: If the ẞ of the company were to be 1, you'd expect an excess return of 5% in the absence of a. However, if you anticipated that the company's stock was going to realize an excess return of 4% or 6%, then its a would be -1% or +1%, respectively.] This forecast can just be a guess for this problem! • Construct the risky portfolio according to Table 27.1 in your book or according to "How to build your portfolio" in today's lecture slides. Compute and report the following parameters for your portfolio: 1. Weights of the securities in your active portfolio and its a. 2. Weight of the active portfolio in the overall portfolio. 3. Aggregate alpha and beta of the active portfolio and of the overall portfolio. 4. Compare the Sharpe ratio of an investment in the market with the Sharpe ratio of the overall portfolio you have constructed! You need to report answers with your own assumptions. But you can check your work with: AAPL Alpha 0.5% AMZN 0.5% ISRG 1.0% TGT -0.5% WMT XOM 1.0% -0.8% Using these values for each stock, your active portfolio should have ap = 3.263%, p = 1.584. The overall portfolio should come out to do = 0.527%, Bo= 1.094. The Sharpe ratio of this overall portfolio is 0.308, whereas the Sharpe ratio of the market portfolio is 0.294. Building an active portfolio. In this problem, we will build an active portfolio, that is, a portfolio consisting of individually selected stocks to complement our passive investments. To do this, create an Excel worksheet. Use the following instructions with a market risk premium TM-T; of 5%. Consider the following annualized information regarding a selection of six stocks (Apple Inc, Amazon.com Inc, Intuitive Surgical Inc, Target Corp, Walmart Inc, and Exxon Mobil Corp) and the S&P 500 that we have obtained from a regression analysis: SD of SD of Excess Beta Systematic Return SD of Residual Component S&P 500 0.1701 1.00 0.1701 0.0000 $AAPL 0.2869 1.20 0.2041 0.2016 $AMZN 0.3554 1.60 0.2721 0.2286 $ISRG 0.3409 1.50 0.2551 0.2261 $TGT 0.2761 0.80 0.1361 0.2403 $WMT 0.2296 0.60 0.1020 0.2057 $XOM 0.2163 0.85 0.1446 0.1609 • Find the covariance matrix according to the index model, where the covariance between two assets is defined as Cov(r) = BB,o. [Hint: You can find the σ from the above table if you compute the covariance of the index with itself because ẞS&P 500 = 1.] • Create a forecast of a for each company, that is, the return in percent you anticipate in excess over the return expected through its ẞ in the coming year. [Example: If the ẞ of the company were to be 1, you'd expect an excess return of 5% in the absence of a. However, if you anticipated that the company's stock was going to realize an excess return of 4% or 6%, then its a would be -1% or +1%, respectively.] This forecast can just be a guess for this problem! • Construct the risky portfolio according to Table 27.1 in your book or according to "How to build your portfolio" in today's lecture slides. Compute and report the following parameters for your portfolio: 1. Weights of the securities in your active portfolio and its a. 2. Weight of the active portfolio in the overall portfolio. 3. Aggregate alpha and beta of the active portfolio and of the overall portfolio. 4. Compare the Sharpe ratio of an investment in the market with the Sharpe ratio of the overall portfolio you have constructed! You need to report answers with your own assumptions. But you can check your work with: AAPL Alpha 0.5% AMZN 0.5% ISRG 1.0% TGT -0.5% WMT XOM 1.0% -0.8% Using these values for each stock, your active portfolio should have ap = 3.263%, p = 1.584. The overall portfolio should come out to do = 0.527%, Bo= 1.094. The Sharpe ratio of this overall portfolio is 0.308, whereas the Sharpe ratio of the market portfolio is 0.294.
Expert Answer:
Answer rating: 100% (QA)
To solve this problem we can follow these steps 1 Calculate the covariance matrix according to the index model using the formula Covri rj i j 2 2 Crea... View the full answer
Related Book For
Probability and Random Processes With Applications to Signal Processing and Communications
ISBN: 978-0123869814
2nd edition
Authors: Scott Miller, Donald Childers
Posted Date:
Students also viewed these finance questions
-
THE DATA PROJECTOR MARKET Alset recognises that mini data projector demand is growing rapidly, although actual numbers are difficult to obtain. The latest figures show the market is $13 billion...
-
In this problem we will use Figure to estimate the expected return on the stock market. To estimate the expected return, we will create a list of possible returns and we will assign a probability to...
-
One persons reform in some cases may be considered an attack on another persons vital interests. Describe how the antebellum reform movementsparticularly temperance, colonization, and womens...
-
Suppose the rate of change of the expected life span l at birth of people born in the United States can be modeled by where t is the number of years past 1920. (a) Use integration and the data point...
-
What groups of people lack contractual capacity? How do the courts view contracts that minors create? Intoxicated people? Insane people?
-
Ann Snodgrass, an Illinois resident, was at various times an instructor at Massachusetts Institute of Technology, Berklee College of Music, and Boston University. Each of these schools is located in...
-
Blue Sky Company reports the following costing data on its product for its first year of operations. During this first year, the company produced 44,000 units and sold 36,000 units at a price of $140...
-
(a) A Ltd. has issued convertible bonds, which carries a coupon rate of 14%. Each bond is convertible into 20 equity shares of the company A Ltd. The prevailing interest rate for similar credit...
-
Mr. Juan Dela Cruz is a self-employed professional based in the Philippines. He provides consulting services in the field of information technology. As a resident Filipino citizen, Mr. Dela Cruz is...
-
After reading Tatums chapter on Titles of Honor discuss the issue of Jesus's self-awareness. Did Jesus see himself as God in the Gospel stories? What are the significance of the other titles...
-
AI Rewrite this AI and keep the quotes the same: Bagranoff remains optimistic about the accounting profession, citing its adaptability to emerging technologies and evolving stakeholder needs....
-
Determine if a,, = 5" is a solution to the following recurrence relation. Be sure to check both the initial conditions and the recurrence. an=4an-1+5an-2 a = 1, a = 5
-
Explain a situation that you have been in where excessive turnover or excessive absenteeism was an issue. How was the situation handled? Do you believe the situation was handled well or what do you...
-
imagine that you are living during one of the time periods we are studying during the semester, and also that you are a close friend of Socrates write a series of diary entries (8-10 entries in all)...
-
AI Rewrite this AI: This article provides valuable insights into the trends and challenges facing the accounting profession, particularly in terms of education and recruitment. It offers data on the...
-
From SS 221 in the Standard Federal Tax Reporter, use the Document Path and select Interest on Education Loans - Sec 221. In the Browse window, expand the tree for SS 221. Which Standard Federal Tax...
-
H.J. Heinzs annual dividends were as follows: 1990 ..............$0.540 1991.............. 0.620 1992 .............. 0.700 1993.............. 0.780 1994 .............. 0.860 1995 .............. 0.940...
-
(Adapted from the battle game Bowsers Bigger Blast from Nintendos Mario Party 4) In this game, 4 players compete in a deadly game of chance against each other. On a stage, there are 5 detonators. One...
-
The output of a filter is given in terms of its input by Y (t) = X (t) + X (t to) + X (t 2to) (a) Determine as a function of R XX (). (b) Find E [y2 (t)].
-
The input to a linear filter is a random process with the following autocorrelation function: The impulse response of the filter is of the same form and is Determine the autocorrelation function of...
-
Milj-Spe AS produces two joint products, cooking oil and soap oil, from a single vegetable oil refining process. In July 2022, the joint costs of this process were NOK 24 000 000. Separable...
-
Galinha-Esquina SA grows and processes chickens. Each chicken is disassembled into five main parts. Information pertaining to production in July 2022 is as follows: Joint costs of production in July...
-
Claude Deux-Bussy is the owner and operator of Boissons Barbe-Bleue Sarl, a bulk soft-drink producer. A single production process yields two bulk soft drinks, Pellas (the main product) and Mlisande...
Study smarter with the SolutionInn App