Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show the excel formula to understand which items were used The expected returns and standard deviations of stocks A and B are listed below,

Please show the excel formula to understand which items were used

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.25
Use the scratchpad to show your work in Excel.
Type your numercial answers 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

Financial Management for Public Health and Not for Profit Organizations

Authors: Steven A. Finkler, Thad Calabrese

4th edition

133060411, 132805669, 9780133060416, 978-0132805667

More Books

Students also viewed these Finance questions