Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investing In Real Estate Private Equity

Authors: Sean Cook

1st Edition

1980587027, 978-1980587026

More Books

Students also viewed these Finance questions

Question

Identify the universal properties of all languages.

Answered: 1 week ago

Question

explain what is meant by redundancy

Answered: 1 week ago