Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider two stocks, stock A and B . We have annual return data for these two stocks along with the T Bill and market portfolio

Consider two stocks, stock A and B. We have annual return data for these two stocks along with the T Bill and market portfolio returns over the past 25 years.
OBS. STOCK A STOCK B MARKET T BILL
16.49%10.48%11.93%3.61%
24.04%11.36%9.80%4.11%
37.37%8.28%10.20%4.39%
42.84%1.06%1.69%2.50%
5-3.37%-1.86%-5.87%2.21%
64.65%13.81%11.00%4.45%
74.48%6.22%6.19%3.69%
82.06%2.87%2.66%2.63%
92.70%21.18%13.74%3.48%
10-0.32%12.52%4.60%3.78%
118.18%4.83%8.95%4.00%
12-0.24%19.64%10.94%3.03%
134.88%-11.59%-5.40%3.95%
145.89%7.60%8.74%3.06%
152.70%-2.63%-2.19%3.84%
163.35%3.24%3.82%3.40%
178.92%4.76%11.16%2.86%
18-0.69%11.05%4.44%2.75%
191.75%11.07%6.92%3.14%
200.02%15.77%6.89%4.69%
210.15%4.57%0.53%3.41%
225.55%8.26%7.58%4.26%
235.26%-1.64%2.26%3.59%
247.52%-0.44%5.12%3.22%
251.59%-0.01%-0.67%3.29%
According to this data;
E.RETURN A is 3.4308%
STDEV A is 3.1353%
E.RETURN B is 6.4160%
STDEV B is 7.5068%
CORRELATION A,B is -0.175
So, what is "expected return" according to this formula and notations:
w(A) the portion of the portfolio invested in asset A
R(A) the expected return on asset A
s(A) the standard deviation of asset As return
cov(A,B) the covariance between the returns of asset A and B
cor(A,B) the correlation between the returns of asset A and B
The statistical properties of P, portfolio return are:
expected return on P = R(P)= w(A)* R(A)+ w(B)* R(B)
variance of P = w(A)2* s(A)2+ w(B)2* s(B)2+2* w(A)* w(B)* cov(A,B)
standard deviation of P = square root of variance of P
our usual portfolio condition is w(A)+ w(B)=1
Answer it via excel and also with normal formula

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Financial Accounting An Integrated Statements Approach

Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren

2nd Edition

324312113, 978-0324312119

Students also viewed these Finance questions