Question
Download monthly returns of three stocks from any stock market for the period January 2011 to December 2020 (ten years). (a) Calculate time-series average returns
Download monthly returns of three stocks from any stock market for the period January 2011 to December 2020 (ten years).
(a) Calculate time-series average returns and standard deviations of returns of the three stocks respectively.
(b) Form an equally-weighted portfolio for the three stocks. Calculate time-series average return and standard deviation of returns of the portfolio.
(c) Calculate the correlation and covariance of returns for each pair of stocks.
(d) Construct the minimum-variance frontier in the Excel for the portfolio in (b). Produce also the table that shows the expected returns and standard deviations of the portfolios on the frontier.
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