Question: or 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

or 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 over the 10 year period -- January 1997 -- December 2006. In this file, the expected monthly return for each stock is calculated using excel function AVERAGE (), 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 ().

Assume that the yearly risk free rate is 2% (A monthly risk free rate of 0.001652).

For questions (b), (c), and (d), we assume that investors invest in the risk-free asset and 4 risky assets (PG, Microsoft, BAC, and Exxon).

(b) Find the optimal investment portfolio in the risky assets. What are the mean and s.d. of the returns of this portfolio?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Can you please answer a and b? Can you please show me the solution step by step in excel sheet? Thank you. For this assignment, please use excel file group_assignment_1_portfolios.xls posted on...

Please answer question (d) F G H J Expected Monthly Return Expected Monthly Return PG 0.010848) Microsoft 0.014854 BAC 0.011589 Exxon 0.012043 000 PG Microsoft BAC Exxon Variance Variance 0.004478...

Use this excel to answer question Hello i would like help on Question D. It is based on the excel sheet above. Any help is good. I will give you thumbs up! Microsoft BAC Expected Monthly Return 8...

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 over the 10 year...

Hello i would like help on Question A. It is based on the excel sheet above. Any help is good. I will give you thumbs up! Microsoft BAC Expected Monthly Return 8 2/3/1997 0.039059 -0.04394...

Need step by step 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...

QUESTION: (b) Find the optimal investment portfolio in the risky assets. What are the mean and s.d. of the returns of this portfolio? For this assignment, please use excel file...

Date PG Microsoft BAC Exxon Expected Monthly Return 2/3/1997 0.0390590324 -0.04393505253 0.1097708082 -0.02516692347 Expected Monthly Return 3/3/1997 -0.04485262708 -0.05994005994 -0.07010869565...

Use this excel sheet to answer question Hello i would like help on Question B. It is based on the excel sheet above. Any help is good. I will give you thumbs up! Microsoft BAC Expected Monthly Return...

Millennium Textiles Company makes silk banners and uses the weighted-average method of process costing. Direct materials are added at the beginning of the process, and conversion costs are added...

Who is authorized to determine what level of spending can be made from the Federal treasury? A) The President B) Federal employees at every level Co he C) Congress D) All of the above

1 . 5 Driving an automobile safely requires considerable skill. Even if not generally recognized, the driver needs an intuitive ability to utilize feedforward and feedback control methods. ( a )...

On January 1, Year 1, Black Dog Corp. began operations and issued 30,000 shares of $ 5 par common stock for $ 9/ share. On June 30, the company bought back 10,000 shares for $ 8/ share. Then, on...

(a) If Leonard Company had net income of $360,000 in 2010 and it experienced a 24.5% increase in net income for 2011, what is its net income for 2011? (b) If six cents of every dollar of Leonard...

Hutchins Company had 200,000 shares of common stock, 50,000 shares of convertible preferred stock, and $ 2,000,000 of 10% convertible bonds outstanding during the current year. The preferred stock...

Rainbow Company reported $ 239,000 net income for the current year. It has 100,000 shares of common shares outstanding for the entire year and another 50,000 shares of 3% nonconvertible, cumulative,...

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

What are the normal costs of a product?

Assigning Costs to Jobs: The following transactions occurred at the March Production Company, a job order custom manufacturer: 1. Purchased $40,000 in materials. 2. Issued $2,000 in supplies from the...

Assigning Costs to Jobs: Refer to the information in exercise 7-12. Prepare journal entries representing the transactions discussed in the exercise.