Question: PLEASE HELP. Just the python code or excel instructions will be great too. Suppose that there are four risky assets A , B , C

PLEASE HELP. Just the python code or excel instructions will be great too. Suppose that there are four risky assets A, B, C, and D. Below, the table
on the left lists the expected return and standard deviation of the return for each of the four assets, while
the table on the right lists the correlations of returns between the four assets.
In this problem, we are going to create the Capital Market Line (CML) and the Security Market Line
(SML) from these 4 risky assets and the riskless asset. Let the return on the riskless asset be Rf=0.035.
Problem. (a) Use the table of correlations above, along with the standard deviations of each of the four
assets to construct (44) variance-covariance matrix V for the 4 risky assets A, B, C, and D. Also, construct
(41) vector of expected excess return vec(r) for the 4 risky assets.
Problem. (b) Let's first start with the CML. We can trace out the CML using the formulas developed in
Section 3 "Mean-Variance Portfolio with Riskless Asset" of Lecture Note 4(which corresponds to Section 5
of Constantinides-Malliaris paper). Specifically, let rp denote a target mean excess return. Then, we know
from the formulas that the standard deviation p of the minimum variance portfolio with the target mean
excess return of rp is the following.
p=rpvec(r)'V-1vec(r)2
Using software of your choice, let rpin[0,0.2](use at least 10 different values of rp within this range)
and calculate what the p must be. Then, graph the CML by plotting the standard deviations p on the
horizontal axis and the target expected return Rp=rp+Rf on the vertical axis. You only need to print
out one final figure. DO NOT draw the figure by hand. Attach a printed copy of the figure generated
from the computer. Also, no need to print out the actual values of expected returns and standard deviations
you've used to construct the CML. I only need to see the final graph. [Hint: I suggest that you do matrix
inversion using computer software. It is not so easy to invert a 4 by 4 matrix by pen and paper.]
PLEASE HELP. Just the python code or excel

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 Accounting Questions!