Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show EXCEL Formula in EXCEL Spreadsheet how you came to the answers to the problem The expected returns and standard deviations of stocks A

Please show EXCEL Formula in EXCEL Spreadsheet how you came to the answers to the problem

The expected returns and standard deviations of stocks A and B are listed below, along with the correlation the returns of Stock A and Stock B. Calculate the expected return and standard deviation of a portfolio with the relative weights in the table below.
Stock A E(R) 12.00%
Stock B E(R) 18.00%
Stock A 36.00%
Stock B 60.00%
Weight Stock A 45.00%
Weight Stock B 55.00%
A,B 0.65
Use the scratchpad to show your work in Excel.
Type your numercial answer into the yellow cells below.
Answers should be to two decimal places, e.g. 1.23% or $123.45.
Portfolio Expected Return
Portfolio Expected Standard Deviation

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

Cases In Healthcare Finance

Authors: Louis C. Gapenski

3rd Edition

1567932444, 9781567932447

More Books

Students also viewed these Finance questions