In a report not to exceed five double-spaced typewritten pages, analyze the results obtained from the three simulations performed, identify the source of the differences, and select (and justify your selection of) a single strategy to manage the risk-return relationship.
Then, graph the final risk-return relationships achieved by your three simulation results on a hypothetical efficient frontier presented in two-dimensional space (with portfolio expected return measured on the y-axis and portfolio risk (standard deviation) measured on the x-axis).
The essential purpose of the term project is to demonstrate how a commercial bank''s asset and liability structure can be viewed as a portfolio. In a manner analogous to an investment portfolio for which the underlying components have been selected and to which efficient diversification principles have been applied, the expected return and risk characteristics will be altered by varying the weights of these underlying components. In this application, the portfolio consists of long (assets) and short (liabilities) positions. Consistent with the objective function of maximizing shareholder wealth (and within the constraints imposed), the separate expected return—risk relationships achieved should demonstrate the tradeoffs arising from varying the weighting schemes used for the bank''s assets and liabilities. Where the bank resides on the efficient frontier implied by these weighting schemes is determined by management''s degree of risk aversion.
If the "naïve" weighting scheme is performed correctly (that is, in a manner consistent with the same overall constraints applied to the other two weighting schemes), the expected return to risk ratio will not exceed the ratio achieved for the maximization simulation and the risk measure (standard deviation) will not fall below that standard deviation measure achieved for the risk-minimization simulation. The plot of the efficient frontier should correspond to the corresponding graph provided by the course text; demonstrating the risk-return tradeoffs achieved.
You should devote your analysis to an assessment of the results you achieved and what the meaning and implications of these results are. The analysis should be conceptually based; in other words, do not focus the bulk of your treatment on the steps you implemented with the computer. The purpose of this portion of the term project is for you to demonstrate your conceptual understanding of the steps you have implemented and results you have obtained; consistent with the principles of portfolio expected return and risk presented by the course material.
I have a spreadsheet; which goes along with this project. Please let me know how, I could attach it to the question.