Question: can you answer this question for me please and using excel to answer it ? Assume that you manage a risky portfolio with an expected

can you answer this question for me please and using excel to answer it ?

can you answer this question for me please and using excel to

Assume that you manage a risky portfolio with an expected rate of return of 15% and a standard deviation of 37%. The T-bill rate is 5% A client prefers to invest in your portfolio a proportion (y) that maximizes the expected return on the overall portfolio subject to the constraint that the overall portfolio's standard deviation will not exceed 25%. Required: a. What is the investment proportion, y ? (Do not round intermediate calculations. Round your answer to 2 decimal places.) 36 b. What is the expected rate of return on the overall portfolio? (Do not round intermediate calculations. Round your answer to 2 decimal places.) 36

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!

can you answer this question for me please and using excel to answer it ? Assume that you manage a risky portfolio with an expected rate of return of 12% and a standard deviation of 28%. The T-bill...

can you answer this question for me please and using excel to answer it ? Required information [The following information applies to the questions displayed below.] A pension fund manager is...

can you answer this question for me please and using excel to answer it ? Worran Zuffet is the investment manager for Berkdale Harmony Fund with an expected rate of return of 14% and a standard...

can you answer this question for me please and using excel to answer it ? You are researching stock investments. The risk-free is 5%. The expected return required by the market for a portfolio with a...

can you answer this question for me please and using excel to answer it ? Consider the following information: Required: a. Based on CAPM, what is required return for portfolio A with a beta of 0.7....

can you answer this question for me please and using excel for it ? Required: A share of stock is now selling for $85. It will pay a dividend of $7 per share at the end of the year. Its beta is 1.0....

can you answer this question for me please and using Excel sheet? Question 2 15pts Answer this question in your Excel Worksheet tab. Show all work completely. Since going public recently, Spotify has...

can you answer this question for me please and using excel to answer this question ? Required: Katy Wud manages Covenant Equity Fund which has an expected risk premium of 10.2% and a standard...

can you answer this question for me please and using excel sheet to answer ? Elan opened an account to short-sell 1,000 shares of Twister at $110 per share. The initial margin requirement was 50%....

Assume there exist multiple risky stocks and that investors may invest or borrow at the risk-free rate of 4%. Using Excel, you determine that the optimal risky portfolio has an expected return of 13%...

We take a sample of adults and measure their heights. If we record the gender of each person, we can calculate the average height and the variance of the height, separately, for men and women....

A piezoresistive accelerometer has the following properties and inputs: Axial acceleration = 75 gs Maximum temperature effect on sensitivity = 10% Sensitivity = 0.4 mV/g What is the maximum reading...

QUESTION 4 Assume that the Instruction Pointer, EIP, contains 9 6 1 0 and the assembly language representation of the instruction in memory at address 9 6 1 0 is JB 1 7 5 . If the flags are currently...

To say that a contract is means that the contract cannot be enforced by the courts because of an applicable law. voidable unfathomable equitable unenforceable

3. Explain in detail what you would do to improve the training process at Apex. Make sure to provide specific suggestions.

2. Choose a task with which you are familiarmowing the lawn, making a salad, or studying for a testand develop a job instruction sheet for it.

4. Find a provider of management development seminars. Obtain copies of its recent listings of seminar offerings. At what levels of managers are the offerings aimed? What seem to be the most popular...