Question: Please show work using excel with equations A K. L. 2 #4 A portfolio has 30% of its value in IBM shares and the rest

Please show work using excel with equations A K. L. 2

Please show work using excel with equations

A K. L. 2 #4 A portfolio has 30% of its value in IBM shares and the rest in Microsoft (MSFT). The volatility of IBM and MSFT are 35% and 30%, 3 respectively, and the correlation between IBM and MSFT is 0.5. What is the standard deviation of the portfolio (using the equation on LC9 Slide 4 #17)? 5 #5 Standard Expected Correlation with Correlation with Correlation with 6. Stock Duke Energy Microsoft Wal-Mart Return Deviation 8 Duke Energy 9 Microsoft 14% 6% -1 44% 24% -1 1 0.7 10 Wal-Mart 23% 14% 0.7 1 11 12 (a) Usin above table, calculate the volatility of a portfolio that is equally invested in Duke Energy and Microsoft. 13 (b) Usin above table, calculate the volatility of a portfolio that is equally invested in Duke Energy and Walmart. 14 15 16 17 18 19 20 21 22 23

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!

Please show work in excel with correct cell formulas. Thank you Managerial Finance 1. You bought a stock one year ago for $51.53 per share and sold it today for $58.26 per share. It paid a $1.59 per...

please help me find the WACC, please show work in excel. thank you!! Estimate the most current Weighted Average Cost of Capital of Fiserv Inc (ticker: Fl, old ticker FISV). Use CAPM to estimate the...

Please show work in excel with all the formulas like the excel posted thanks. A B D F G - K * L L M z H N o P Q R S T U COLD AND SWEET COMPANY 900,000 0 10 Corporate tax rate Cost of capital 30% 14%...

1. A bond investor is considering two 10 year maturity bonds both rated AAA: the municipal bond is yielding 1.15% and the corporate bond is yielding 2.10%. At what marginal tax rate would the bond...

Please show work in excel. My filled in answers are correct. B D E F G H j L M 10 Please use the following information to answer the questions concerning stocks that follow. 11 12 You are considering...

I need these problems worked out because I can't grab the concept , is their any possible way it can be done in 5 hours please! I never had to use this extra feature up until now so I was wondering...

#4 A portfolio has 30% of its value in IBM shares and the rest in Microsoft (MSFT). The volatility of IBM and MSFT are 35% and 30%, respectively, and the correlation between IBM and MSFT is 0.5. What...

Please show work and finance calculator inputs. A portfolio has 30% of its value in IBM shares and the rest in Microsoft (MSFT). The volatility of IBM and MSFT are 35% and 30%, respectively, and the...

please show everything in excel with cell reference. F G H par 100 1 Issuer 2 Theartcommunications 3 Revlon Consumer Products 4 Petroleum Geo Services ASA" 5 California Resources 6 Lennar 7 Athabasca...

City Technology began the year with inventory of $244,000 and purchased $1,540,000 of goods during the year. Sales for the year are $4,000,000, and City's gross profit percentage is 60% of sales....

Compute estimated profit in 1 year if XYZ buys a put option with a strike of $0.95, $1.00, or $1.05. Draw a graph of profit in each case.

What do you understand about Computer Systems?

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

a lack of management responsibility concerning ecological issues and the utilization of scarce resources.

a neglect of quality in relationship to international competitors;

full employment policies, and therefore lack of concern with negative appraisal, as salaries varied very little and there was no danger of unemployment;