Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have invested a portfolio comprised of Dell, Apple and Microsoft. Calculate the expected return and standard deviation of the portfolio given the information below.

You have invested a portfolio comprised of Dell, Apple and Microsoft. Calculate the expected return and standard deviation of the portfolio given the information below. (SHOW IN EXCEL). Provide step by step solution.

1)Calculate the Expected return of the portfolio. (EXCEL)

2) The variance of the portfolio (EXCEL)

3) The standard deviation of the portfolio ( EXCEL)

Money spent Dell $1680
Money spent Apple $1805
Money spent Microsoft $1584
Expected Return Dell 41%
expected return Apple 23%
expected return Microsoft 20%
standard deviation dell 14%
standard deviation apple 15%
standard deviation Microsoft 11%
correlation coefficient dell and apple 0.22
correlation coefficient dell and Microsoft 0.42
correlation coefficient Apple and Microsoft 0.25

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

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

Analysis For Financial Management

Authors: Robert C Higgins

8th International Edition

0071257063, 9780071257060

More Books

Students also viewed these Finance questions