Question

In: Finance

You are a portfolio manager. There are 6 different funds you can invest in for your...

  1. You are a portfolio manager. There are 6 different funds you can invest in for your client. Each of the 4 scenarios are equally likely to occur.

Fund

Scenario 1

Scenario 2

Scenario 3

Scenario 4

A

22.61

26.6

6.54

-3.36

B

15.12

18.48

10.6

5.08

C

19.69

17.91

5.99

-2.11

D

14.03

11.2

-1.99

6.68

E

7.62

7.92

9.26

3.75

F

6.52

13.27

15.05

14.22

  1. Your client wants an annual return no less than 4%. All scenarios are equally likely to occur. Put your work in the tab labeled Moderate. How much should you invest in each stock? What is the maximum return you would expect for each scenario?
  2. If your client wants a conservative portfolio, how much should you invest in each stock? What is the maximum return you would expect for each scenario?

EXCEL FORMAT PLEASE

Solutions

Expert Solution

Please give a thumbs up. It will help me


Related Solutions

6. You are a portfolio manager. There are 6 different funds you can invest in for...
6. You are a portfolio manager. There are 6 different funds you can invest in for your client. Each of the 4 scenarios are equally likely to occur. Fund Scenario 1 Scenario 2 Scenario 3 Scenario 4 A 22.61 26.6 6.54 -3.36 B 15.12 18.48 10.6 5.08 C 19.69 17.91 5.99 -2.11 D 14.03 11.2 -1.99 6.68 E 7.62 7.92 9.26 3.75 F 6.52 13.27 15.05 14.22 a. Your client wants an annual return no less than 4%. All scenarios...
What is the duration of your bond portfolio if you invest 30% of your portfolio in...
What is the duration of your bond portfolio if you invest 30% of your portfolio in a bond with a duration of 12.2 (let’s denote it BA), 30% in a 20-year zero-coupon bond (let’s denote it BZ), and 40% in a 3-year bond with a 12% annual coupon, par value of $1000, and a yield to maturity of 7% (let’s denote it BB)? 10.74 years 12.5 years 9.3 years 4 years
As a portfolio manager for an Barletta Bank, you are about to invest $10 Billion in...
As a portfolio manager for an Barletta Bank, you are about to invest $10 Billion in one of four possible investments:             ♦          12-year zero-coupon bonds issued by Boudreaux Boats;             ♦          10-year 12%-coupon bonds issued by Boudreaux Boats;             ♦          7-year 8%-coupon bonds issued by Boudreaux Boats;           ♦          1-year commercial paper issued by Boudreaux Boats                         (commercial paper is 1-year debt, like a bank issuing a 1-year CD. You plan to maintain your investments for exactly one year....
Your client is willing to invest in Mutual funds industry to keep its portfolio diversified. Therefore...
Your client is willing to invest in Mutual funds industry to keep its portfolio diversified. Therefore he wants your advice in respect to which fund is better option for his risk level positions. He is risk averse investors and required high liquidity which enables him to meet day to day operations. You have gathered the data from Mutual funds and its allocation which are mentioned below:- Fund A Fund B Fund C Cash & Cash Equivalents 30.00% 5.00% 20.00% Equity...
You are a portfolio manager that is interested in incorporating a new share in your portfolio...
You are a portfolio manager that is interested in incorporating a new share in your portfolio multi-asset portfolio. Your portfolio currently holds bonds therefore you are faced with a simple two-asset problem. Assuming a risk-free rate of 6% and the data in the table below: Data Share_A Share_B Share_C Bonds Expected Return 14% 12% 11% 9% Standard Deviation 13% 15% 11% 3% Covariance with Bonds 0.003 0.0016 0.0022 NA Please calculate: 1. The optimal weight in a share versus your...
As a portfolio manager, you are considering three mutual funds: a stock fund, a bond fund,...
As a portfolio manager, you are considering three mutual funds: a stock fund, a bond fund, and a money market bond that yields a sure rate of         2.45           %. Below is the information concerning the two risky funds: (Total 50 points) Expected return Standard deviation Stock fund 0.22 0.56 Bond fund 0.06 0.25 The correlation between fund returns is     0.26­­     . Find the weights of the minimum-variance portfolio and calculate its expected return and its standard deviation....
As a portfolio manager, you are considering three mutual funds: a stock fund, a bond fund,...
As a portfolio manager, you are considering three mutual funds: a stock fund, a bond fund, and a money market bond that yields a sure rate of         2.45           %. Below is the information concerning the two risky funds: (Total 50 points) Expected return Standard deviation Stock fund 0.22 0.56 Bond fund 0.06 0.25 The correlation between fund returns is     0.26­­     . Find the weights of the minimum-variance portfolio and calculate its expected return and its standard deviation....
As a portfolio manager, you are considering three mutual funds: a stock fund, a bond fund,...
As a portfolio manager, you are considering three mutual funds: a stock fund, a bond fund, and a money market bond that yields a sure rate of        2.75      %. Below is the information concerning the two risky funds: (Total 50 points) Expected return Standard deviation Stock fund 0.28 0.43 Bond fund 0.06 0.11 The correlation between fund returns is    0.08    . Find the weights of the minimum-variance portfolio and calculate its expected return and its standard deviation. Show...
You are the manager of a portfolio of risky securities. Your portfolio has an expected return...
You are the manager of a portfolio of risky securities. Your portfolio has an expected return (E(rP)) of 12% and a standard deviation (P) of 18%. The risk free rate (rf) is 6%. The following two clients want to invest some portions of their investment budget in your portfolio and the balance in the risk free asset: Client 1 needs an expected return of 10% from her complete portfolio. Client 2 needs a complete portfolio with a standard deviation of...
You have $289969 to invest in a stock portfolio (this amount is your original wealth). Your...
You have $289969 to invest in a stock portfolio (this amount is your original wealth). Your choices are Stock H, with an expected return of 16.04 percent, and Stock L, with an expected return of 10.58 percent. Legal constraints require you to invest at least $44154 in stock L. If your goal is to create a portfolio with an expected return of 19.54 percent on your original wealth, what is the minimum amount you must borrow (and subsequently repay) at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT