Question: Please show steps and answer the question fully The expected returns and standard deviations of stocks A and B are listed below, along with the

Please show steps and answer the question fully

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

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!

Q:

I know the answer is 11.10. However, I don't know how to calculate it on excel. I need ALL the steps included in the formula, please. I will give thumps up G 0.1891 0.1661 1.0000 B D E F 7 Here are...

Q:

Please show excel calculations thank you QUESTION 2 MONTHLY Expected Returns, Standard Deviations, and Correlations July 1990 through December 2014, 294 months, returns are total stock market returns...

Q:

U Question 9 12 pts An investor wants to construct an optimal risky portfolio based on one stock and one bond. The expected returns and standard deviations are as follows: Expected Return Standard...

Q:

I am just struggling with these problems. No matter how I put it in I am coming up wrong. I don't know if I am rounding the numbers to early or what. Can someone please help me? 1. Consider the...

Q:

If you can submit answers in excel with clear inputs, formulas for results Could you please make excel calculators for the below questions? Question 1 There is a 46% probability of a below average...

Q:

Please provide EXCEL formula on how to solve this problem Suppose the expected returns and standard deviations of Stocks A and B are E( R A ) = .086, E( R B ) = .146, A = .356, and B = .616. a-1....

Q:

Could you answer in excel with clearly labeled inputs and cells with formulas in them Could you please make excel calculators for the below questions? Question 1 There is a 46% probability of a below...

Q:

Show all steps please. Portfolio Standard Deviation Suppose the expected returns and standard deviations of Stocks A and B are E(R_A) = 11. E(R_B) = .13, sigma_A = .39, and sigma_b = .76. Calculate...

Q:

Please answer all questions 1-5 l Verizon LTE 11:06 AM Exit D Question 1 3 pts There is a 41% probability of a below average economy and a 59% probability of an average economy. If there is a below...

Q:

Need help with the attached questions from finance major Assignment 3 Questions 1. Anle Corporation has a current price of $27, is expected to pay a dividend of $2 in one year, and its expected price...

Q:

Use Fubini's theorem to evaluate the integral ! ! xey dx dy. no

Q:

The occupied states are inside the Fermi sphere in k-space as shown below; the radius is Fermi h? ( 37N 2/3 wave number kp. EF EF 2m V 2m. From these two equations, kp can be found as, Fermi Surface...

Q:

Which of the following is an attack that either exploits a software flaw or floods a s from occurring? On - path attack Denial - of - service attack Privilege escalation Brute force attack

Q:

Which of the following should you discuss in your CPFR cadence calls? Competitors' plans Integrated financial plan Human resource needs Expected demand

Q:

Suppose an individual prefers to drink beer during college but enjoys winemore during middle age. This is a classic example of time-inconsistent preferences.

Q:

Evidence indicates that exponential discounting functions are very rare in humans.

Q:

If a person discounts utility from future periods, her preferences are time-inconsistent because she does not value utility in all periods equally.