Question
You want to form a portfolio between two stocks: MEG Energy, and B2Gold Corporation. Download the monthly closing price data from Yahoo!. Finance pages for
You want to form a portfolio between two stocks: MEG Energy, and B2Gold Corporation. Download the monthly closing price data from Yahoo!. Finance pages for MEG Energy (ticker symbol: MEG.TO) and B2Gold Corporation (ticker symbol: BTO.TO) from January 2017 to December 2021. Calculate the monthly holding period returns for each stock in MS Excel using the adjusted closing prices. Use this data and Excel to answer the following questions:
a. What is the average monthly return and standard deviation of returns for MEG Energy?
b. What is the average monthly return and standard deviation of returns for B2Gold Corporation?
c. Find the correlation between MEG Energy and B2Gold Corporation.
d. Does the risk-return relationship (trade-off) hold between these two stocks?
e. Use these values, calculate the portfolio return and standard deviation for various weights in MEG Energy and B2Gold Corporation:
i. Calculate the portfolio return and standard deviation for weights with alternatively 0%, 5%, 10%, 15%..., 95%, 100% weights in MEG Energy and the rest of B2Gold Corporation.
ii. Graph this portfolio return and standard deviation for all possible portfolios on a graph with Return on the vertical axis and Standard deviation on the horizontal axis (hint: Use Scatter Plot graph type)
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