Question
The table below shows the stock prices of 6 stocks at the end of each 30 holding periods (including at the end of period 0),
The table below shows the stock prices of 6 stocks at the end of each 30 holding periods (including at the end of period 0), and the dividends given during holding periods 13 and 24.
Your team of investment managers shall form portfolios of investments in 2 stocks according to the list below.
The 2 chosen stocks are Casper and Dresden
Required:
-
Calculate the returns for your 2 chosen stocks and any 2 others over each holding period.
-
Calculate the expected return and (population) standard deviation for the 4 stocks, as well as the
correlation coefficients for each pair of stocks (correlation matrix).
-
Construct portfolios using your 2 chosen stocks only. Show the risk-return profile of your portfolios of
investments in various weights in your 2 chosen stocks. Also, plot a chart (in Excel) showing the risk-return
profile.
-
Using your 2 chosen stocks only, show how much (weights) in each stock would you invest in to construct
the minimum variance portfolio, and portfolios X, Y and Z (Refer to the table above for the required standard deviations of Portfolios X, Y and Z). Calculate the expected returns of these portfolios. Show how you would spend $100,000 to construct the minimum variance portfolio and portfolios X, Y and Z respectively at the end of holding period 30.
-
If risk-free borrowing and lending rates are 4% and 2% respectively, show how you can improve on your portfolios of investments in your chosen stocks by allowing borrowing and/or lending. Explain briefly the basis of the improvements you are making. Show the risk-return profile of your portfolios of investments in various weights in your 2 chosen stocks and borrowing/lending.
-
Using your 2 chosen stocks and borrowing/lending, show how much (weights) in each stock would you invest in and how much borrowing/lending is needed to construct portfolios X*, Y* and Z* (if possible). Portfolios X*, Y* and Z* are the improved portfolios that have the same standard deviations as X, Y and Z respectively. Calculate the expected returns of these portfolios and compare with the expected returns of portfolios X, Y and Z respectively to justify your decisions. Show how you would spend $100,000 to construct these portfolios X*, Y* and Z* (if possible) respectively at the end of holding period 30.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started