956 Words4 Pages

Instructions for Efficient-Frontier Construction

a. Estimation

The goal is to obtain the raw ingredients – expected returns, standard deviations and correlations. Historical data are used for this purpose. As a rule of thumb, five years of daily data are probably right (one year should be the absolute minimum). Keep in mind the following: 1) make sure to use the adjusted close prices to calculate returns (so that you won’t have large, spurious negative returns due to dividend payments or splits), and 2) calculate log returns (so that you can aggregate daily returns to obtain holding period returns, if ever needed).

In Excel, the function for mean and standard deviation are “= average (range)” and “stdev(range).” To calculate the*…show more content…*

The only constraint is: all the weights sum to one, i.e., set cell b42 equal to 1.0. Then simply click on “solve.” The solutions will be in a34..a39. Of course, the portfolio’s return and std are simultaneously calculated in cells b44 and b45, and the slope linking the portfolio and the T-bill is in cell b46.

Step 4. Obtain market portfolio: maximize Slope subject to sum of weight = 1.0

Follow the same logic/procedure as in Step 3, except that you want to maximize cell b46.

Step 5. Obtain market portfolio with no short selling: maximize Slope subject to sum of weights = 1.0 and all weight being positive

This part is just for completeness: to show you how to construct the market portfolio when short selling is prohibited. Here you also maximize cell b46, except that, aside from the weights-summing-to-one constraint, you would add six more constraints: a34 > 0, a35 > 0, …, a39 > 0. It turns out that, the weights on Securities 2 and 3 are zero, since they command the most amount of short selling in the unconstrained case (Step 4). However, it is not always true that any security that is being shorted in the unconstrained case will have a weight of zero in the constrained case. Security 5 is a case in point.

Step 6. Generating efficient frontier

Here, everything is already self-explanatory. Essentially, we need to plot the parabola and the CML. To this end, we first get the functions for each, and then use Excel to

a. Estimation

The goal is to obtain the raw ingredients – expected returns, standard deviations and correlations. Historical data are used for this purpose. As a rule of thumb, five years of daily data are probably right (one year should be the absolute minimum). Keep in mind the following: 1) make sure to use the adjusted close prices to calculate returns (so that you won’t have large, spurious negative returns due to dividend payments or splits), and 2) calculate log returns (so that you can aggregate daily returns to obtain holding period returns, if ever needed).

In Excel, the function for mean and standard deviation are “= average (range)” and “stdev(range).” To calculate the

The only constraint is: all the weights sum to one, i.e., set cell b42 equal to 1.0. Then simply click on “solve.” The solutions will be in a34..a39. Of course, the portfolio’s return and std are simultaneously calculated in cells b44 and b45, and the slope linking the portfolio and the T-bill is in cell b46.

Step 4. Obtain market portfolio: maximize Slope subject to sum of weight = 1.0

Follow the same logic/procedure as in Step 3, except that you want to maximize cell b46.

Step 5. Obtain market portfolio with no short selling: maximize Slope subject to sum of weights = 1.0 and all weight being positive

This part is just for completeness: to show you how to construct the market portfolio when short selling is prohibited. Here you also maximize cell b46, except that, aside from the weights-summing-to-one constraint, you would add six more constraints: a34 > 0, a35 > 0, …, a39 > 0. It turns out that, the weights on Securities 2 and 3 are zero, since they command the most amount of short selling in the unconstrained case (Step 4). However, it is not always true that any security that is being shorted in the unconstrained case will have a weight of zero in the constrained case. Security 5 is a case in point.

Step 6. Generating efficient frontier

Here, everything is already self-explanatory. Essentially, we need to plot the parabola and the CML. To this end, we first get the functions for each, and then use Excel to

Related

## Portfolio Management: Practice Problems

1301 Words | 6 Pagesasset and 50% in the risky asset; and (ii) -50% in the riskless asset and 150% in the risky asset. c. Compute the expected rate of return and standard deviation for (i) and (ii). d. Suppose you have a target risk level of 50% per year. How would you construct a portfolio of the risky and the riskless asset to attain this target level of risk? What is the

## Partners Healthcare Case Aanlysis Essay examples

1254 Words | 6 Pages15(0.054) = 10.8% In order to find the optimal portfolio allocation, the group needs to find the portfolio structured with lowest risk under a given return. This can be achieved by applying Mean-Variance Theory and Markowitz model find the efficient frontier, which yields the most optimal portfolio under given returns. It can be expressed in mathematical terms and solved by quadratic programming. [Appendix A] In this case, the Partner’s Treasury Department has computed all the portfolios for

## Portfolio Theory Essay example

2185 Words | 9 Pagescrucial role in explaining the relationship between risk and return where more than one investment is held. It also enables us to identify optimal and efficient portfolios.” With Reference to this statement, describe, discuss and illustrate the principles of portfolio theory. Your essay should include coverage of the Markowitz Efficient Frontier and the Capital Market Line. Declaration: I confirm that this submission is my own work. Vinita Java Introduction: An investor would

## A Brief Note On Risk Management Through Traditional Diversification

1443 Words | 6 Pagesasset classes, but in fact has a very concentrated exposure to underlying equity risk. Understanding these risk factors is key to creating an efficient, risk-managed allocation strategy. Figure 2.1 Asset class exposure Traditional portfolio construction approaches, which focus on asset class diversification, may fall short of investors’ goals. A more efficient diversification strategy may be to allocate across the underlying “risk factors.” Risk factors are the underlying risk exposures that drive

## Applying Economics Using An Example Of Economic Problem From Your Own Life Essay

1949 Words | 8 Pagesbuying a book mean the loss of the benefit that would have been gained from the 10 pencils. b) Outline the steps needed to develop an economic model. Explain how models help in economic decision-making. An Economic model is defined as a theoretical construct that represents economic processes through a set of variables and a set of logical or quantitative relationships between the two. The steps needed to develop an economic model are:- 1. Identify the problem 2. Identify stakeholders in the problem

## The Capital Asset Pricing Model Essay

1565 Words | 7 PagesQ.22: DISCUSS CAPM (WILLIAM SHARPE’S MODEL) WITH ITS ASSUMPTIONS. ALSO EXPLAIN THE CONCEPTS OF CML AND SML. (EXPLAIN THE SINGLE INDEX MODEL PROPOSED BY WILLIAM SHARPE.) ANS.: INTRODUCTION CAPM tells how assets should be priced in the capital markets if, indeed, everyone behaved in the way portfolio theory suggests. The capital asset pricing model (CAPM) is a relationship explaining how assets should be priced in the capital market. The capital asset pricing model (CAPM) is a widely-used finance

## Nestle Value Chain Analysis

10755 Words | 44 PagesDeveloping Robust Asset Allocations1 Working Paper First Version: February 17, 2006 Current Version: April 18, 2006 Thomas M. Idzorek, CFA Director of Research Ibbotson Associates 225 North Michigan Avenue Suite 700 Chicago, Illinois 60601-7676 312-616-1620 (Main) 312-616-0404 (Fax) tidzorek@ibbotson.com Abstract Over the last 50 years, Markowitz’s mean-variance optimization framework has become the asset allocation model of choice. Unfortunately the model often leads to highly concentrated asset

## Benefits Of The Financial Services Industry Outweigh The Disadvantages

1396 Words | 6 PagesInvestment has become a growing tendency and a method for people dealing with their income, while portfolio is an important investment vehicle. In the same time, financial services industry has played a critical part in making investment portfolio available to ordinary people. In this essay, the meaning and functions of portfolio will be analyzed and it will argue the advantages of the financial services industry outweigh the disadvantages. Firstly, portfolio theory has become an essential strategy

## The Role Of Dea Is A Linear Programming Methodology Measuring The Model Affects The Results?

1161 Words | 5 Pagesassumed in the above model. When the constraint is added, we have a variable return to scale model [6]. The DEA estimates of is an indicator of efficiency. It measures the distance between the observed input/output combination and the efficiency frontier. The Malmquist Productivity Index (MPI) is based on ideas similar to the DEA, but MPI allows comparisons between two periods. Assume the technology at is implied in a set , where all feasible are included, i.e., .The output distance function,

## Advantages Of Portfolio Optimization

1531 Words | 7 Pagesreturn and the risk of return. As shown in Figure 1, among all efficient portfolios, the efficient frontier consisted of all those with highest return at each given risk level. C_1,C_2,and C_3 were the investors indifference curves which showed that traders prefer portfolios with high return or low risk. The tangent point R of the highest indifference curve and the efficient frontier gave the optimized portfolio. Figure 1: Efficient Portfolio and Trader’s Indifference Curve in

### Portfolio Management: Practice Problems

1301 Words | 6 Pages### Partners Healthcare Case Aanlysis Essay examples

1254 Words | 6 Pages### Portfolio Theory Essay example

2185 Words | 9 Pages### A Brief Note On Risk Management Through Traditional Diversification

1443 Words | 6 Pages### Applying Economics Using An Example Of Economic Problem From Your Own Life Essay

1949 Words | 8 Pages### The Capital Asset Pricing Model Essay

1565 Words | 7 Pages### Nestle Value Chain Analysis

10755 Words | 44 Pages### Benefits Of The Financial Services Industry Outweigh The Disadvantages

1396 Words | 6 Pages### The Role Of Dea Is A Linear Programming Methodology Measuring The Model Affects The Results?

1161 Words | 5 Pages### Advantages Of Portfolio Optimization

1531 Words | 7 Pages