Please show the steps on how to solve in excel and please show the formulas Investments in storage facilities in San Diego, CA has a 62% return correlation with investments in multi-family properties in Atlanta. using the information provided below please solve a and b. Expected return - San Diego Storage 8.0%Expected return - Multi-Family Atlanta 7.0%SD of expected return - San Diego Storage 12.5%SD of expected return - Multi-Family Atlanta 15.0% a. What is the expected return on a portfolio that invests 40% in San Diego storage facilities and 60% in Atlanta multi-family properties? b. What can be said about the annual standard deviation of return of a portfolio that invests 40% in San Diego storage facilities and 60% in Atlanta multi-family properties? (note: the answer should only indicate a value that is smaller or larger than a specific percentage)
Please show the steps on how to solve in excel and please show the formulas
Investments in storage facilities in San Diego, CA has a 62% return correlation with investments in multi-family properties in Atlanta. using the information provided below please solve a and b.
Expected return - San Diego Storage 8.0%
Expected return - Multi-Family Atlanta 7.0%
SD of expected return - San Diego Storage 12.5%
SD of expected return - Multi-Family Atlanta 15.0%
a. What is the expected return on a portfolio that invests 40% in San Diego storage facilities and 60% in Atlanta multi-family properties?
b. What can be said about the annual standard deviation of return of a portfolio that invests 40% in San Diego storage facilities and 60% in Atlanta multi-family properties? (note: the answer should only indicate a value that is smaller or larger than a specific percentage)
Step by step
Solved in 2 steps