Standard Deviations of Five Possible Investments Follow the instruction to answer 13 questions based on the dataset and reading materials. 200words for eac

Standard Deviations of Five Possible Investments Follow the instruction to answer 13 questions based on the dataset and reading materials. 200words for each question

I have attached the reading material and the data needed.

Please read all materials carefully before you placed your bid.

This is a financial investment master course. Please don’t place your bid if you are non finance majored.

All the work must be original and professional

Turnitin report is required MGSM836
Investment Management
T1 2019
Individual Assignment Instructions
Notes:
–
These instructions are to be read in conjunction with the Darden Case Study Portfolio
Selection and the associated excel workbook
As described in the case, there are two clients to be addressed in this assignment –
the 28 year old professional manager and the 60 year old retiree (Clients)
There are six parts to the assignment. These parts are designed to step through the
portfolio analysis and should be addressed in sequence
Investment recommendations MUST include supporting reasons
The Individual Assignment has a total possible mark of 60
The Individual Assignment has a unit assessment weight of 35%
P a r t 1: (10 marks total)
1.A
Using the stock return data provided, calculate the returns for a portfolio invested
equally in the three stocks. This portfolio will be referred to as the equally weighted portfolio
(EWP). Calculate the mean (average) return and standard deviation of the realized returns
for each stock, the S&P 500 index, and the EWP. (5 marks)
1.B
Compare and contrast the means and standard deviations of these five
possible investments and make a recommendation for each of the Clients. (5 marks)
Part 2: (10 marks total)
2.A
Calculate the correlation between the three stocks, the S&P 500 and the EWP. (3
marks)
2.B
Using the template provided (two asset portfolio), construct a graph that shows the
relation between the expected returns (vertical axis) and standard deviations (horizontal axis)
of pairs of the stock investments (all three pairs). (3 marks)
2.C
Discuss inferences arising from the correlations between the individual stocks and
from the correlation between the EWP and the S&P 500 index. (4 marks)
page 1 of 2
Part 3: (10 marks total)
3.A
Using the template provided (three asset portfolio), construct a graph that shows
the expected returns and standard deviations of combinations of the three stocks arising from
the allocation of weights to each stock. (5 marks)
3.B
Restricting yourself to the above combinations of the three stocks, make a
recommendation for each of the Clients. (5 marks)
Part 4: (10 marks total)
We can expand the set of portfolio combinations by considering the addition of a risk free
asset (such as a USA government bond). This risk free asset can be combined with the
market portfolio to generate another set of possible investments. This addition to the portfolio
graph is referred to as the capital market line.
4.A
To the graph prepared in Part 3, add the capital market line. Assume that the return
on the bond is 0.45%. (3 marks)
4.B
Consider all the possible investments you have identified (the three individual
stocks, all combinations of the three stocks and the capital market line) and make a
recommendation for each of the Clients. (7 marks)
Part 5: (10 marks total)
5.A
Using regression analysis (see the regression tool from the Data Analysis Toolkit in
Excel) calculate Beta for each stock. (5 marks)
5.B
With reference to the three calculated Beta, discuss inferences in relation to risk.
Compare these inferences with those made in Part 1.B. (5 marks)
Part 6: (10 marks total)
6.A
For Harris, calculate the expected monthly return expressed as a function of S&P 500
Index returns and assuming that the monthly risk free rate is 0.45% and the monthly risk
premium is 0.50% (refer equation (4) in the case). (5 marks)
6.B
As a function of S&P 500 Index returns, graph the actual returns for Harris (a scatter
plot) and the expected returns for Harris (a straight line). Comment on the usefulness of
expected returns as a predictor of future returns. (5 marks)
oooOOOooo
page 2 of 2
rP
os
t
UV2565
Rev. Aug. 29, 2017
PORTFOLIO SELECTION
AND THE CAPITAL ASSET PRICING MODEL
op
yo
What portfolio would you recommend to a 28-year-old who has just been promoted
to a management position, and what portfolio would you recommend to a 60-yearold who has just retired?
The perennial question in the world of personal finance seems to be “What should I buy?”
A far better question would be “What portfolio should I hold?” The research exercise described in
this note provides an opportunity to explore the reasoning behind this distinction. More
importantly, it will become apparent that the answers to the portfolio question provide critical
insights into how we measure risk and determine appropriate rates of return for a given level of
risk. In particular, the analysis described here will develop familiarity with the capital asset pricing
model (CAPM), a model of appropriate returns based on the relation between the returns on an
individual asset and the returns on a broad market portfolio.
No
tC
The analysis described here is organized around the question stated at the top of this page.
To focus our analysis, we will ignore issues related to the amount of wealth these individuals might
have, the tax situation each may face, and specific expenditure plans they might have. Simply
assume that both have relatively large amounts to invest, but not so large that they are indifferent
to the returns they might earn. Both would, of course, prefer higher returns to lower returns. The
newly promoted manager, however, would be able to accept a higher degree of risk than the retiree.
Do
The analysis will proceed as follows. The accompanying spreadsheet (UVA-F-1604X)
presents historic returns of three stocks as well as the returns on the S&P 500 index. You will be
guided through the analysis of these data. Each analysis will be accompanied by a series of
questions. The first set of steps examines various portfolios of investments; the second set explores
the implications of the portfolio results for individual stocks.
This technical note was prepared by Associate Professor Marc Lipson. Copyright 2009 by the University of Virginia
Darden School Foundation, Charlottesville, VA. All rights reserved. To order copies, send an e-mail to
sales@dardenbusinesspublishing.com. No part of this publication may be reproduced, stored in a retrieval system,
used in a spreadsheet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording,
or otherwise—without the permission of the Darden School Foundation.
This document is authorized for educator review use only by MARK STEWART, University of New South Wales until Jul 2018. Copying or posting is an infringement of copyright.
Permissions@hbsp.harvard.edu or 617.783.7860
Portfolio Selection
rP
os
t
-2-
UV2565
We will begin this analysis by considering just single investments and then proceed to add
additional alternatives, including portfolios combining individual investments.1 The analysis will
make use of basic statistical descriptions of returns and employ a very simple regression analysis.
Step 1: Calculate the realized returns for a hypothetical portfolio invested equally in the three
stocks. You may simply average the three returns.2 We will refer to this as the equally weighted
portfolio. Calculate the mean (average) realized return and standard deviation of the realized
returns for each stock, the S&P 500 index, and the equally weighted portfolio.
op
yo
Compare and contrast the mean and standard deviations of these five possible
investments. What are the noticeable differences?
When choosing between the three individual stock investments and ignoring
combinations of these investments, which would you suggest to our hypothetical
investors? Why?
How does your answer change if you add the index as an allowable investment?
No
tC
Step 2: Calculate the correlation between each of the three stocks and between the S&P 500
and the equally weighted portfolio. Assume that the average return, standard deviation and
correlation of each of these assets from 1990 to 2009 are a good estimate of these same
measures for the future. Using the template provided in the second tab, construct a graph that
shows the expected future relation between the returns (vertical axis) and standard deviations
(horizontal axis) of a pair of the stock investments (your choice which pair).3
1
A portfolio can consist of a single investment and need not have more than one component.
Averaging the returns implicitly assumes that each month, you are rebalancing the portfolio so that an equal
value is invested in each stock.
3
The template produces the graph by first generating a set of observations and then plotting those observations.
This is done as follows. A table was created that has one column with the weight assigned to one stock (using
increments of 1%); a second column with the weight assigned to the second stock (one minus the weight of the first
stock); a third column with the anticipated standard deviation of this two-asset portfolio based on the weights, standard
deviations, and correlation. The formula for the mean would be r p w1 r1 w2 r2 where rp is the portfolio return, r1
Do
2
is the mean historic return of stock number one, r2 is the mean historic return of stock number two, and w refers to
the proportional weight invested in each subscripted security. For example, if 30% of a portfolio is invested in security
number one, then w1 = 0.30 and, since all weights must sum to 1, w2 would equal 0.70. For the standard deviation, the
formula would be p sqrt ( w12 12 w 22 std 22 2 w1 w 2 1 2 corr1,2 ) where σ denotes the standard deviation of historic
returns for the subscripted security, corr denotes the correlation between the subscripted securities, and the p subscript
indicates the portfolio you are examining. The resulting expected returns are plotted against the standard deviations.
This document is authorized for educator review use only by MARK STEWART, University of New South Wales until Jul 2018. Copying or posting is an infringement of copyright.
Permissions@hbsp.harvard.edu or 617.783.7860
rP
os
t
-3-
UV2565
Is there an intuitive explanation for the shape of the curve you have generated?
How does the shape of the curve change as you alter the correlation (which is bounded
by −1 and 1, inclusive)?
What do the correlations between the individual stocks indicate? What insight is
provided by the correlation between the equally weighted portfolio and the S&P 500
index?
op
yo
Step 3: Using the template provided, construct a graph that shows the expected returns and
standard deviations of all possible combinations of the three stocks. This graph was constructed
in a fashion analogous to the two-asset graph, but expanded to three stocks.4 This graph
describes the complete investment space offered by the three stock investments.
Restricting yourself to combinations of the three stocks, what portfolio of stock
investments would you recommend for our two hypothetical investors?
Locate the S&P 500 index on this graph. Explain the location of this index relative to
the set of possible three-stock combinations.
Step 4: We can expand the set of financial assets by considering a risk-free bond (U.S.
government security). We will assume that the return on the bond is 0.45% a month, which is
about 5.5% per year.
No
tC
What would be the diversification benefits from adding a bond?
This risk-free asset can be combined with the market portfolio to yield another set of possible
investments. This line is referred to as the capital market line. Add the capital market line to
your graph from Step 3. The can be done by adding points to the graph that represent linear
combinations of the bond and the market.
Explain the shape of the capital market line.
Do
Now consider all the possible investments you have identified (the three individual
stocks, all combinations of the three stocks, the index, and the security market line).
What would you recommend to our two hypothetical investors? Be very specific in
your recommendation.
4
The formula for the mean would be rp
would be
p
sqrt ( w12
2
1
w 22
2
2
w32
2
3
w1 r1
2 w1 w 2
w2 r2
1
w3 r3 and for the standard deviation for three stocks
2 corr1,2
2 w1 w3
1
3 corr1,3
2 w 2 w3
2
3 corr2,3 ) .
Given
the number of possible combinations, the graph uses increments of 5% in the weights and starts by generating all 5%
incremented combinations of weights on the three stock investments.
This document is authorized for educator review use only by MARK STEWART, University of New South Wales until Jul 2018. Copying or posting is an infringement of copyright.
Permissions@hbsp.harvard.edu or 617.783.7860
rP
os
t
-4-
UV2565
Individual Asset Returns
It should be clear from the previous steps that portfolios of stocks offer significant
advantages over individual stocks. In fact, a case could be made that an extremely broad portfolio
(a market index) is the optimal portfolio of risky investments, and this portfolio would be combined
with an appropriate amount of riskless bonds to achieve a desired optimal overall investment
portfolio.
op
yo
The optimality of holding portfolios has important implications for individual stocks.
When considering the riskiness of an individual stock, investors will ignore the total risk of the
stock (since much of it will be diversified away) and consider only that level of risk that cannot be
diversified away. This can be described as the risk an individual stock adds to a particular portfolio.
The remaining steps develop a measure of this risk and link that measure to returns.
Step 5: To measure the risk a stock adds to a given portfolio, one simply regresses the returns
of the individual stock on the returns of the portfolio. The regression coefficient on the portfolio
reflects exactly that risk. For example, if we regress an individual stock’s returns on a broad
market index, the resulting coefficient on the market is called a market beta (or, more
commonly, simply the beta). The beta reflects the variation in individual stock returns that
cannot be diversified away. One simple form for the regression is the following:5
ri , t
alpha
beta rm , t
t
(1)
No
tC
In the regression model above, returns are observed for each time period t for an individual
stock i and market return m. The regression acknowledges individual error terms each period
of ε since stock returns will deviate from this relation due to firm-specific events. Please
calculate the alpha and beta for each of the three stocks relative to the S&P 500 index. This
can be done using the regression tool from the Data Analysis Toolkit in Excel or using the
following simple formulas:
beta
alpha
corri ,m
i
m
ri
beta rm
(2)
(3)
Do
The regression analysis will provide additional statistical information on the relationship, but
the above equations are sufficient.
5
Market beta regressions are often run using returns in excess of a risk-free rate and are often also adjusted for
various statistical problems; however, this simple form typically provides very similar results.
This document is authorized for educator review use only by MARK STEWART, University of New South Wales until Jul 2018. Copying or posting is an infringement of copyright.
Permissions@hbsp.harvard.edu or 617.783.7860
rP
os
t
-5-
UV2565
Based on the betas, which firm is the most risky? Least risky? How does your answer
compare with the answer you provided based on standard deviations? Which one is
appropriate for our hypothetical investors? Explain why.
What is the economic meaning of the alpha?
op
yo
Step 6: Since the beta provides a measure of risk, one should be able to link expected return to
this risk measure. By expected return, we mean the return that an individual investor would
expect to earn from holding this stock. This can be calculated quite easily. First, one recognizes
that a riskless bond has a beta of zero and that the market portfolio has a beta of one. Since all
the diversification benefits associated with portfolios have already been accounted for, the
graph of the relationship between beta and returns for portfolios combining the risk-free bond
and the market portfolio is linear. All individual stocks must lie on this same line. Thus, the
equation for returns for every security is the equation of the line that connects the market return
and the bond return in a graph of returns (vertical axis) against beta (horizontal axis).6 That
equation and the theories that justify it are referred to as the CAPM). The equation is
ri
rrf
(rm
rrf )
rrf
( MRP)
(4)
No
tC
where ri is the expected return for an individual stock, rrf is the expected risk-free rate of return,
β is the beta, rm is the expected return on the market, and (in the simplified version) MRP is
the market risk premium (the difference between the expected return on the market and the
expected risk-free rate of return).
Given the calculated beta for each stock, calculate the expected monthly return for each stock
assuming that the monthly risk-free rate is 0.45% (about 5.5% annually) and the monthly risk
premium is 0.50% (about 6% annually). Calculate the annual expected returns implied by these
monthly returns. Calculate the realized annual returns from the mean returns in Step 1.
How do the realized returns compare with the expected returns? Assuming the CAPM
describes the appropriate expected returns for these stocks, describe how prices might
respond if, at some point, the expected returns on the three stocks differed from what
was predicted by the CAPM.
Summary
Do
These steps illustrate the essential link between risk and returns as it would be viewed in a
world where individuals can (and therefore do) hold portfolios of investments. We have used past
data to generate a description of the world and considered our choices assuming the past behavior
would indicate future (expected) behavior. There are a number of reasons one needs to be cautious
6
It is crucial to recognize that this graph is plotting returns relative to beta while the earlier graphs plot returns
relative to standard deviations.
This document is authorized for educator review use only by MARK STEWART, University of New South Wales until Jul 2018. Copying or posting is an infringement of copyright.
Permissions@hbsp.harvard.edu or 617.783.7860
rP
os
t
-6-
UV2565
Do
No
tC
op
yo
about this assumption, and in many cases the results for past data would not be a reasonable
estimate for the future. Applying the ideas developed here should be based on best estimates of
future expected return behavior.
This document is authorized for educator review use only by MARK STEWART, University of New South Wales until Jul 2018. Copying or posting is an infringement of copyright.
Permissions@hbsp.harvard.edu or 617.783.7860
This spreadsheet supports STUDENT analysis of the case “Portfolio Selection and the Capital Asset Pricing Model” (UVA-F-1604).
This spreadsheet was prepared by Associate Professor Marc Lipson. Copyright © 2010 by the University of Virginia Darden School Foundation, Charlottesville, VA. All rights reserved. For
customer service inquiries, send an e-mail to sales@dardenbusinesspublishing.com. No part of this publication may be reproduced, stored in a retrieval system, posted to the Internet, or
transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of the Darden School Foundation. September 29, 2010.
Security Monthly Return Data
Returns in Percent and for Month Indicated (not annualized)
Short Name
S&P
Harris
Urban
Maya
Year
1990
1990
1990
1990
1990
1990
1990
1990
1990
1990
1990
1990
1991
1991
1991
1991
1991
1991
1991
1991
1991
1991
1991
1991
1992
1992
1992
1992
1992
1992
1992
1992
1992
1992
1992
1992
1993
1993
1993
1993
1993
Name
S&P
Harris Packaged Goods
Urban Educational Products
Maya Medical Technologies
Month
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
Description
S&P 500 Index
Producer of packaged food products that food chains brand with their own name
Small and young firm with good prospects developing educ…
Purchase answer to see full
attachment