Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show work in excel. Consider the following two funds and their estimated returns under different states of the economy State of Probability Estimated Return

please show work in excel.
image text in transcribed
Consider the following two funds and their estimated returns under different states of the economy State of Probability Estimated Return (Fund A) Estimated Return (Fund B) economy Great 30% 10% 25% Average 30% 15% 11% Poor 40% 20% 15% Calculate the following: a. Expected return for fund A and for fund B b. Standard deviation of returns for fund A and fund B c. Covariance between returns of fund A and fund B d. Correlation between returns of fund A and fund B If you invest $2,000 in Fund A and $8,000 in Fund B, Calculate the following: e. Portfolios' Expected Return f. Portfolio's Standard Deviation Bonus (1) Construct the complete covariance and correlation matrixes for A & B Bonus (2) Find the minimum variance portfolio using solver and report its variance, Standard Deviation and Expected Return

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

Step: 3

blur-text-image

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

Chronic Regulatory Focus And Financial Decision Making Asset And Portfolio Allocation

Authors: Navin Kumar

1st Edition

9812876936, 978-9812876935

More Books

Students also viewed these Finance questions

Question

Modify sum.py to correct the error.

Answered: 1 week ago