Question

In: Math

Reconsider the portfolio selection example, including its spreadsheet model in Figure 8.13, given in Section 8.2....

Reconsider the portfolio selection example, including its spreadsheet model in Figure 8.13, given in Section 8.2. Note in Table 8.2 that Stock 2 has the highest expected return and stock 3 has by far the lowest. Nevertheless, the changing cells Portfolio (C14:E14) provide an optimal solution that calls for purchasing far more of Stock 3 than of Stock 2. Although pur- chasing so much of Stock 3 greatly reduces the risk of the portfo- lio, an aggressive investor may be unwilling to own so much of a stock with such a low expected return.
For the sake of such an investor, add a constraint to the model that specifies that the percentage of Stock 3 in the portfolio can- not exceed the amount specified by the investor. Then compare the expected return and risk (standard deviation of the return) of the optimal portfolio with that in Figure 8.13 when the upper bound on the percentage of Stock 3 allowed in the portfolio is set at the following values.
a.   20%

c.   Generate a parameter analysis report using RSPE to
systematically try all the percentages at 5% intervals from 0% to 50%

Solutions

Expert Solution

Given:

Reconsider the portfolio selection example, including its spreadsheet model in Figure 8.13, given in Section 8.2. Note in Table 8.2 that Stock 2 has the highest expected return and stock 3 has by far the lowest. Nevertheless, the changing cells Portfolio (C14:E14) provide an optimal solution that calls for purchasing far more of Stock 3 than of Stock 2. Although pur- chasing so much of Stock 3 greatly reduces the risk of the portfo- lio, an aggressive investor may be unwilling to own so much of a stock with such a low expected return.
For the sake of such an investor, add a constraint to the model that specifies that the percentage of Stock 3 in the portfolio can- not exceed the amount specified by the investor. Then compare the expected return and risk (standard deviation of the return) of the optimal portfolio with that in Figure 8.13 when the upper bound on the percentage of Stock 3 allowed in the portfolio is set at the following values.

NOTE : I hope you are happy with my answer

*  Please help me with your rating  *

     THANK YOU


Related Solutions

Essay Selection of Asset Portfolio by Markowitz model
Essay Selection of Asset Portfolio by Markowitz model
Refer to the Scheer Industries example in Section 8.2. Use 6.85 days as a planning value...
Refer to the Scheer Industries example in Section 8.2. Use 6.85 days as a planning value for the population standard deviation. a. Assuming 95% confidence, what sample size would be required to obtain a margin of error of 1.5 days (round up to the next whole number)? b. Assuming 90% confidence, what sample size would be required to obtain a margin of error of 2.5 days (round up to the next whole number)?
Below is the data for the spreadsheet for a project selection model: Project              NPV (return)       cash...
Below is the data for the spreadsheet for a project selection model: Project              NPV (return)       cash investment personnel requirements 1              75,000                 30,000                          10 2              50,000                 45,000                          5 3              25,000                 75,000                          10 4              85,000                 30,000                          4 5              50,000                 45,000                          8 6              25,000                 75,000                          7 7              95,000                 45,000                          6 8              25,000                 60,000                          1 9              75,000                 30,000                          2 10            65,000                 45,000                          2 You have $250,000 to invest and 36 people. Maximize NPV by approving/rejecting projects. Multiple Choice #8: How many projects of the...
IV. Investment Portfolio In this section you should provide an example of an Investment Portfolio. Meaning...
IV. Investment Portfolio In this section you should provide an example of an Investment Portfolio. Meaning provide ideas for developing your own investment portfolio. Your explanation should include ideas on diversity across companies and sectors, security and speculation, and stock and bonds.
A project model of some sort is implied by any conscious decision, including the selection of...
A project model of some sort is implied by any conscious decision, including the selection of projects. The choice between two or more alternative projects requires reference to some objective. Determine the nature of project selection models
Match the type of selection with the example. **Why is each its respective match?** Directional Selection...
Match the type of selection with the example. **Why is each its respective match?** Directional Selection Stabilizing Selection Disruptive Selection Negative Frequency Dependent Selection A) Squirrels that learn fastest have the most offspring B) Squirrels feed on acorns or birdseed. When most squirrels feed on acorns, those that eat birdseed have the highest fitness (and vise versa) C) Long ears attract the most mates. Short ears improve survival in the winter. Medium sized ears provide neither benefit. D) Squirrels that...
Explain the dividend discount model as a basis for stock valuation, including a example in your...
Explain the dividend discount model as a basis for stock valuation, including a example in your initial post. What are the challenges of predicting future dividends, and what other factors affecting stock price are not accounted for in the dividend discount model?  
Explain and describe the Parity of Healthcare Model, including the models that it incorporates, and its...
Explain and describe the Parity of Healthcare Model, including the models that it incorporates, and its usefulness to healthcare leaders.
Solve the given initial-value problem by finding, as in Example 4 of Section 2.4, an appropriate...
Solve the given initial-value problem by finding, as in Example 4 of Section 2.4, an appropriate integrating factor. (x2 + y2 ? 3) dx = (y + xy) dy,    y(0) = 1
Give your own example of a plane figure and its quadrature. How does the quadrature of...
Give your own example of a plane figure and its quadrature. How does the quadrature of the triangle depend on the quadrature of the rectangle? Draw a lune like Hippocrates.’ What is the relationship between the large semicircle and the semicircle that contains the lune?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT