Question: e. Let us now compute an envelope portfolio with constant c = 4%, where the vector z solves the system of simultaneous linear equations E(r)

e. Let us now compute an envelope portfolio with constant c

e. Let us now compute an envelope portfolio with constant c = 4%, where the vector z solves the system of simultaneous linear equations E(r) - c= Sz. Then, this solution produces a portfolio x and y on the envelope of the feasible set. Write down and explain the Excel formula used to calculate the values in Cells A20, F20, F24 (portfolio weights and sum of portfolio weights), F26:F28 (mean, variance and standard deviation), and B30:B31 (covariance, correlation), in the Excel spreadsheet below: H B C D E CALCULATING THE FRONTIER Variance-covariance, s 1 ET) Mean minus returns constan 2 Er) t 3 0.10 0.01 0.03 0.05 6% 2.00% 4 0.01 0.30 0.06 -0.04 896 4.00% 5 0.03 0.06 0.40 0.02 10% 6.00% 6 0.05 -0.04 0.02 0.50 15% 11.00% 7 8 Constant, 4.00% 9 10 Computing an envelope portfolio with constant - 0 Envelope Z portfolio 11 X 12 0.3861 0.3553 13 0.2567 0.2362 14 0.1688 0.1553 15 0.2752 0.2532 16 Sum 1.0000 17 18 Computing an envelope portfolio with constant = 4.00% Envelope Z portfolio 19 y 20 0.0404 ? 0.0782 ? 21 0.1386 0.2684 22 0.1151 0.2227 23 0.2224 0.4307 24 Sum 1.0000 ? 25 26 E(X) 9.37% EV 11.30% ? 27 Var(x) 0.0862 Vary) 0.1414 ? 28 Sigmax) 29.37% Sigma 37.60% ? 29 30 Covix. 0.1040 ? 31 Comix 0.9419 ? 32 ? e. Let us now compute an envelope portfolio with constant c = 4%, where the vector z solves the system of simultaneous linear equations E(r) - c= Sz. Then, this solution produces a portfolio x and y on the envelope of the feasible set. Write down and explain the Excel formula used to calculate the values in Cells A20, F20, F24 (portfolio weights and sum of portfolio weights), F26:F28 (mean, variance and standard deviation), and B30:B31 (covariance, correlation), in the Excel spreadsheet below: H B C D E CALCULATING THE FRONTIER Variance-covariance, s 1 ET) Mean minus returns constan 2 Er) t 3 0.10 0.01 0.03 0.05 6% 2.00% 4 0.01 0.30 0.06 -0.04 896 4.00% 5 0.03 0.06 0.40 0.02 10% 6.00% 6 0.05 -0.04 0.02 0.50 15% 11.00% 7 8 Constant, 4.00% 9 10 Computing an envelope portfolio with constant - 0 Envelope Z portfolio 11 X 12 0.3861 0.3553 13 0.2567 0.2362 14 0.1688 0.1553 15 0.2752 0.2532 16 Sum 1.0000 17 18 Computing an envelope portfolio with constant = 4.00% Envelope Z portfolio 19 y 20 0.0404 ? 0.0782 ? 21 0.1386 0.2684 22 0.1151 0.2227 23 0.2224 0.4307 24 Sum 1.0000 ? 25 26 E(X) 9.37% EV 11.30% ? 27 Var(x) 0.0862 Vary) 0.1414 ? 28 Sigmax) 29.37% Sigma 37.60% ? 29 30 Covix. 0.1040 ? 31 Comix 0.9419 ? 32

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

a. Suppose we form a portfolio invested in Mercedes and BMW stocks. The two stocks are equally weighted in the portfolio. The table below displays each stocks mean return, variance, and standard...

Suppose we form a portfolio invested in Mercedes and BMW stocks. The two stocks are equally weighted in the portfolio. The table below displays each stocks mean return, variance, and standard...

Math 636 Final - Quiz Component 1. The system of linear equations 2x2 x3 = 3 2x1 + x2 + 2x3 = 1 x1 + x2 + 3x3 = 2 (a) is consistent with a unique solution. (b) is consistent with infinitely many...

a) Consider four risky assets having the following expected returns E() and variance- covariance matrix (S), where c is a constant: B D E Variance-covariance, S F G Er) Mean minus returns constan...

6.1. Carbondale Company has the following credit policy 2/10, net 30. Carbondale also charges 1% per month interest on all accounts after 30 days. The following table shows the collection schedule of...

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

(1) Consider the following system of linear equations with two parameters a, be R rty+ 2: 2ar + (3a - 1)and + (50 - 2)= 2+ 2a 2ar + (3a - 1)y + (50 - 2+ 63)= = 20 - b+2 (a) State the...

All questions. 05:50:42 VA; 25% ' ASSIGNMENTNM1.pdf IQ 0+ Numerical Methods-Assignment-l Mathematical Prelimanaries, Taylor's Theorem, Order of Convergence (1) Let L be a real number and let {an} be...

(1) Consider the following system of linear equations 3x + 2y + 203 = -13 -5 5x + 2ay - 3: = -18 where a E R is a constant. (a) Classify the system according to the values of a b) Solve the above...

Can scientists ever be completely objective when conducting research? Why or why not? Support your argument with resources. What might be the consequences (positive and/or negative) of emotion in...

Sara is a salesperson for Cameras Etc. which is a retailer for high end digital cameras. Historically, Sara has averaged selling 2.1 extended warranties per day for cameras that she sells. Assume the...

Baht Company charges cost plus 3 0 percent. What is the price of an item with cost equal to $ 6 5 ? Question 9 options: $ 1 2 . 5 0 $ 5 0 . 0 0 $ 6 0 . 0 0 $ 8 4 . 5 0

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Assume that you are preparing a visual aid that will not fit on the page with the text that relates to it. Where would you place this visual aid in the report? (Objective 2)

Construct a graph for the following data. Include appropriate content, placement, and format for the number of the visual (assume it is the first visual in a report), title, and source note. Assume...

You have several items to compare differences in quantities. What type of graph would you prepare? Why? (Objective 4)