Question
The spreadsheet Group Report Data.xlsx contains monthly returns on eleven Australian industry portfolios from January 2016 to February 2021. The industry abbreviations are in the
The spreadsheet Group Report Data.xlsx contains monthly returns on eleven Australian industry portfolios from January 2016 to February 2021. The industry abbreviations are in the table below.
Investor utility is represented by: U = E(R) - A2 . There are two investors with different risk aversion coefficients (A). Angela has a risk aversion coefficient of 5 and Boris has a risk aversion coefficient of 2. Investors are able to short-sell each industry throughout the report. Investors are unable to borrow or lend at the risk-free rate except for part 5 of the report. The expected returns per month to be used throughout the report are in the following table. Do not use historical average returns as expected returns. You need to use the historical returns to estimate the covariance matrix.
IndustryAbbreviation Expected Return (per month)
Consumer DiscretionaryCOND 0.96%
Consumer StaplesCONS0.83%
Energy ENGY1.09%
Health CareHC0.86%
IndustrialsINDU0.92%
Information TechnologyIT1.00%
MaterialsMATL0.87%
TelecomTELE0.90%
UtilitiesUTIL0.80%
FinancialsFIN0.90%
Real EstateRE0.96%
Question: Consider the MATL and HC industries. What is the optimal portfolio for both Boris and Angela that contains these two industries? Discuss what happens to each investor's utility and portfolio risk for this portfolio compared to holding these two industries individually. Will you always reach this conclusion or is specific to these two portfolios?
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