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:

Self-dealing

A situation in which an individual with fiduciary duties acts in their own best interest rather than in the interest of the beneficiaries, potentially leading to a conflict of interest.

Business

The practice of making one's living by engaging in commerce, trade, or services.

Personal

Relating to or affecting a particular person rather than anyone else.

Indemnification

Indemnification refers to the obligation of one party to compensate another for losses or damages incurred, as specified in a contractual agreement.