Question: Please help me figure this out using excel! Suppose stocks D, E and F monthly returns have the following mean and variances: Stock D: Mean

Please help me figure this out using excel!

Suppose stocks D, E and F monthly returns have the following mean and variances:

Stock D: Mean () of 1.1%, and Variance ( 2 ) of 0.0064 - i.e. monthly volatility of 8%

Stock E: Mean () of 0.5%, and Variance ( 2 ) of 0.0025 - i.e. monthly volatility of 5%

Stock F: Mean () of 0.7%, and Variance ( 2 ) of 0.0036 - i.e. monthly volatility of 6%

o Stocks D and E have pairwise covariance of 0.0017

o Stocks D and F have pairwise covariance of 0.0028

o Stocks E and F have pairwise covariance of 0.0013

9) What is the expected return and standard deviation for a portfolio that involves 40% investment in stock D, 30% in Stock E, and the rest in Stock F?

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!

I'm trying to answer question 12 Suppose stocks D, E and F monthly returns have the following mean and variances: Stock D: Mean () of 1.1%, and Variance ( 2 ) of 0.0064 - i.e. monthly volatility of...

Hello, please help me answer this question using excel and show the formulas you have used in excel. I need help answering A-H. Thank you. 7-2 The data below are annual total returns for General...

Please help with the bottom portion using excel. What am I missing or doing wrong? Thank you. Week 5 Homework X Q Cell Styles L! Format Clipboard Font Alignment Number Styles Cells Editing Ideas...

please emergency !!! (25 points total) in the Excel file that is linked to this question, you will see the stock prices for 2 different stocks. a) (5 points) Please calculate the Mean Variance,...

D E B F Objective: This assignment is intended to give you experience in preparing a Master Budget and will help you understand the relationship between the Operation Budget and the Financial Budget....

check on the file and download the...

Please help with wrong questions or blank ones Excel Activity: Evaluating Risk and Return Bartman Industries's and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are...

please help me by wring down the Excel operating steps Real Data. Spreadsheet file Project2_Data.xlsx contains the closing prices for stocks of six large companies and the values of the S&P 500 Index...

please help me by writing down the Excel operating steps ,thank you so much Real Data. Spreadsheet file Project2_Data.xlsx contains the closing prices for stocks of six large companies and the values...

I can't seem to get any answers, please help asap! Problem Set #7 1. (a) (b) (c) (d) In a multifactor APT model, the coefficients on the macro factors are often called: systemic risk. firm-specific...

Two candidates, A and B, vie for office. Each of an odd number of citizens may vote for either candidate. (Abstention is not possible.) The candidate who obtains the most votes wins. (Because the...

The graph shows the ages of both men and women at first marriage (www.census.gov). Clearly, the patterns for men and women are similar. But are the two lines getting closer together? Here's a...

7. Calculating Annuity Values (LO1) If you deposit $5,000 at the end of each of the next 20 years into an account paying 10.8 percent interest, how much money will you have in the account in 20...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".