Question

In: Finance

Your portfolio manager has suggested two high-yielding stocks: The Altria Group (MO) and Reynolds America (RAI)....

Your portfolio manager has suggested two high-yielding stocks: The Altria Group (MO) and Reynolds America (RAI). MO shares cost $50, yield 4.5% in dividends, and have a risk index of 2.0 per share. RAI shares cost $55, yield 5% in dividends, and have a risk index of 3.0 per share. You have up to $11,150 to invest and would like to earn at least $510 in dividends. How many shares (to the nearest tenth of a unit) of each stock should you purchase to meet your requirements and minimize the total risk index for your portfolio? What is the minimum total risk index?

Solutions

Expert Solution

ANswer No of shares of Mo = 9500 / 50 = 190 and RAI = 1650/55 = 30 shares.

Minimum Total Risk will be 2.148

The problem can be solved by using the solver function in excel. The formula used and the solver constraints are also added

The results are


Related Solutions

You are a fund manager and have a portfolio of high risk stocks. The beta of...
You are a fund manager and have a portfolio of high risk stocks. The beta of a firm is more likely to be high under which two conditions? A. high cylical busniess activity and high operating leverage B. high cylical business activity and low operating leverage C. low cylical business activity and low financial leverage D. low cylical business activity and low operating leverage E. low financial leverage and low operating leverage
Your client wants to construct a portfolio from two stocks (Stocks Y and Z) and has...
Your client wants to construct a portfolio from two stocks (Stocks Y and Z) and has asked you to determine the portfolio weights for each stock that will generate the portfolio with the smallest standard deviation. Use the relevant information in the table below to calculate the standard deviation for each portfolio weighting scenario and indicate the scenario that you should recommend to your client. Stock Y Stock Z Portfolio Weighting Scenario 1 60% 40% Portfolio Weighting Scenario 2 70%...
Your investment club has only two stocks in its portfolio. $30,000 is invested in a stock...
Your investment club has only two stocks in its portfolio. $30,000 is invested in a stock with a beta of 0.4, and $60,000 is invested in a stock with a beta of 2.2. What is the portfolio's beta? Round your answer to two decimal places. AA Corporation’s stock has a beta of 1.3. The risk-free rate is 7% and the expected return on the market is 11%. What is the required rate of return on AA's stock? Round your answer...
Your investment club has only two stocks in its portfolio. $10,000 is invested in a stock...
Your investment club has only two stocks in its portfolio. $10,000 is invested in a stock with a beta of 0.5, and $75,000 is invested in a stock with a beta of 1.5. What is the portfolio's beta? Round your answer to two decimal places. Required Rate of Return AA Corporation’s stock has a beta of 1.1. The risk-free rate is 2.5% and the expected return on the market is 11%. What is the required rate of return on AA's...
A portfolio manager has recently taken a long position in XYZ Plc’s stocks, and wants to...
A portfolio manager has recently taken a long position in XYZ Plc’s stocks, and wants to know whether this stock is still worth holding. She requests a sell-side analyst to provide an estimate of the stock’s twelve month forward price target. The analyst decides to use the Free Cash Flow to the Firm (FCFF) valuation model, and collects the following information for the year just ended: Earnings: £130m Sales: £1,300m Depreciation: £50m Investment in fixed capital: £90m Interest expense: £55m...
A portfolio manager has recently taken a long position in XYZ Plc’s stocks, and wants to...
A portfolio manager has recently taken a long position in XYZ Plc’s stocks, and wants to know whether this stock is still worth holding. She requests a sell-side analyst to provide an estimate of the stock’s twelve month forward price target. The analyst decides to use the Free Cash Flow to the Firm (FCFF) valuation model, and collects the following information for the year just ended: Earnings: £130m Sales: £1,300m Depreciation: £50m Investment in fixed capital: £90m Interest expense: £55m...
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 a portfolio of two stocks that has a total value of $32,000. The portfolio is 44 percent
You have a portfolio of two stocks that has a total value of $32,000. The portfolio is 44 percent invested in Stock J. If you own 205 shares of Stock K, what is Stock K's share price?
Jack has a portfolio with two stocks ABC and XYZ with the following parameters:
Jack has a portfolio with two stocks ABC and XYZ with the following parameters: $ Invested Expected Return Standard Deviation of Return ABC $4000 4.45% 8.23% XYZ $6000 7.96% 9.76% The correlation coefficient between ABC and XYZ is 0.40. A. Compute expected return of the portfolio. B. Calculate covariance of ABC and XYZ stock. C. Compute the standard deviation of the portfolio.
A broker has decided to to build a portfolio of two stocks for a retired individual....
A broker has decided to to build a portfolio of two stocks for a retired individual. The first stock "G" has an expected return of 10.25% with a variance of 73.96. The second stock "K" has an expected return of 7.75% with a variance of 18.49. The correlation between the two stocks is -0.58. a) With the given information, what is the covariance between the two stocks, to two decimal places? b) With the given information, what is the variance,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT