Consider the Following Data on the Returns from Bonds A Construct the Markowitz Portfolio Model Using a Required Expected

question 50

Essay

Consider the following data on the returns from bonds. $$\begin{array}{l}                                                            \text { Year }\\\begin{array} { | l | c | c | c | c | c | c | c | c | } \hline & \mathbf { 1 } & \mathbf { 2 } & \mathbf { 3 } & \mathbf { 4 } & \mathbf { 5 } & \mathbf { 6 } & \mathbf { 7 } & \mathbf { 8 } \\\hline \text { Bon d 1 } & 0.20 & 0.126 & 0.321 & - 0.39 & - 0.67 & 0.135 & 0.52 & 0.75 \\\hline \text { Bon d 2 } & 0.128 & 0.21 & 0.325 & - 0.243 & 0.169 & 0.125 & 0.304 & 0.286 \\\hline \text { Bon d 3 } & 0.167 & 0.27 & 0.426 & - 0.84 & 0.143 & - 0.46 & 0.147 & 0.704 \\\hline\end{array}\end{array}$$
a. Construct the Markowitz portfolio model using a required expected return of at least 15 percent. Assume that the 8 scenarios are equally likely to occur.
b. Solve the model using Excel Solver.

---

Definitions:

Movement

The action of changing physical location or position, often under the control of the muscular and nervous systems in organisms.

On-Center

On-Center describes a type of neuronal response characterized by activation when the center of its receptive field is stimulated by light, while stimulation of the surrounding area inhibits activation.

Off-Surround

A concept in visual processing referring to the inhibitory mechanism surrounding the central point of stimulation, enhancing edge detection and contrast in visual perception.

Color Opponent Retinal Ganglion Cell

Color opponent retinal ganglion cells are neurons in the eye that help in the processing of color vision by responding differently to light from different parts of the color spectrum.