Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please help me solve this using excel! suppose sto

Please help me solve this using excel! Suppose stocks D, E and F monthly returns...

90.2K

Verified Solution

Question

Finance

Please help me solve this 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

10) Find a minimum variance portfolio invested in the three stocks, without short-selling. What are the weights, expected return, and standard deviation for this portfolio?

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

3. Are younger drivers more likely to have accidents in their driveways? Traffic engineers tabulated types...

Statistics
Q

Describe the key properties of a signal sequence (or leader sequence or leader peptide). Explain the...

Biology
Q

Choose two expansionary monetary policy actions that the FED has taking recently to counter the economic...

Economics
Q

P18-3 Eloisa corporation applies IFRS. Information about Eloisa corporation income before income tax of 633,000 for its...

Accounting
Q

Write an arithmetic sequence that has three arithmetic means between 155 and 215.155, 165, 175,...

Basic Math
Q

Determine whether the geometric series is convergent or divergent 80 16 0 64 1 n...

Calculus
Q

X Evaluate the formula p for n 1059 and x 556 n p Round to...

Algebra
Q

20 x 7x 5x 40x x 15x 56

Algebra
Q

Crane Electric sold $5,310,000, 13%, 10-year bonds on January 1, 2020. The bonds...

Accounting
Q

The Ground Up Construction Company began operations in January 2016. After the first year of...

Accounting
Q

True or False: Dividends declared and paid cause a corporation's retained earnings balance to increase...

Accounting
Q

Greenbercy tinc 5 trat balince foloss Q iclidi the icen so ver the ention ?...

Accounting