Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

could someone show me how to work this problem in excel? please includw cell references and formulas You combine two assets in a portfolio. Asset

could someone show me how to work this problem in excel? please includw cell references and formulas image text in transcribed
You combine two assets in a portfolio. Asset 1 has a standard deviation of 0.50 and Asset 2 has a standard deviation of 0.45 The correlation between Asset 1 and Asset 2 is.30. If you put 40% of the portfolio weight in Asset 1 and the remainder in Asset 2, what is the portfolio's standard deviation? Portfolio variance: o= wo+ wo + 2W, W221,20102 (46)(1509) +(60%).452) + 26.40)6.60) (-30%.50)6.45) 1453 8=.381

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Finance for Non Financial Managers

Authors: Pierre Bergeron

7th edition

176530835, 978-0176530839

More Books

Students also viewed these Finance questions

Question

2. Describe the basic elements of an ICT network. (8)

Answered: 1 week ago