Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve for Part C by showing your work/formulas on excel and thank you. Expected Monthly Return Expected Monthly Return PG Microsoft BAC Exxon 0.010848

please solve for Part C by showing your work/formulas on excel and thank you.
image text in transcribed
Expected Monthly Return Expected Monthly Return PG Microsoft BAC Exxon 0.010848 0.014854 0.011589 0.012043 Variance Variance PG Microsoft BAC Exxon 0.004478 0.012820 0.005611 0.002820 Covariance Cox(PG, Microsoft) Cov(PG, BAC) Cov(PG, Exxon) Cov(Microsoft, BAC) Cov(Microsoft, Exxon) COV(BAC, Exxon) -0.000649 0.000683 0.000433 0.001681 0.000804 0.000757 For this assignment, please use excel file group_assignment_1_portfolios.xls posted on blackboard under the folder of Excel Files. The file contains the monthly returns of 4 stocks ove the 10-year period -- January 1997 -- December 2006. In this file, the expected monthly return for each stock is calculated using excel function AVERAGE 0, for each stock, the variance of monthly returns is calculated using Excel function VAR (), and the covariance between the returns of each pair of stocks is calculated using Excel function COVAR 0. Assume that the yearly risk-free rate is 2% (A monthly risk-free rate of 0.001652). we assume that investors invest in the risk-free asset and 4 risky assets (PG, Microsoft, BAC, and Exxon). (c) Find the global minimum variance portfolio. What is the expected return and variance of return of this portfolio

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

The China Model Experience And Challenges

Authors: Yongnian Zheng

1st Edition

1433172003, 1433190214, 9781433190216

More Books

Students also viewed these Finance questions

Question

1. Signs and symbols of the map Briefly by box ?

Answered: 1 week ago

Question

Types of physical Maps?

Answered: 1 week ago

Question

Explain Intermediate term financing in detail.

Answered: 1 week ago