956 WordsNov 25, 20104 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

Related

## Portfolio Management: Practice Problems

1301 Words | 6 Pagesof 1%? Part II. Construction of Feasible Investment Opportunity Set and the Efficient Frontier (Lecture 3) 1. Consider two securities for the potential portfolio inclusion: E(r1)=25%,E(r2)=10%, 1=75%, 2=25%, 12 Draw all feasible investment combinations given these two risky assets in a plane of P, E(rp)} in Excel for four cases: (1) 12 =1, (2) 12 = 0.2, (3) 12 = - 0.2, (4) 12 = -1. What does the Efficient Frontier look like? 1 Part of this practice problem is constructed based on the homework

## 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

## 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

## The Capital Asset Pricing Model Essay

1565 Words | 7 Pagesutility concept. 2. Investors have Homogeneous Expectations of Risk and Return: Investors have similar expectations of Risk and Return because without this, the estimates of mean and variance may lead to different forecasts with the result that the efficient portfolio of each will be different from that of others. 3. Investors Make Choices on the Basis of Risk and Return: Investors make investment decision on a rational basis, depending on their assessment decision on a rational basis, depending on

## Portfolio Theory As An Investment Decision Instrument

1697 Words | 7 Pagesprinciple of raw numbers accessible with respect to the choice. Instability, then again, is a circumstance where either the raw numbers are not accessible, or the probabilities cannot be given. The efficient market theory The effective market theory is commonly referred to as a hypothesis, and therefore efficient market hypothesis (EMH) states that financial markets are "educationally proficient". That is, one cannot always accomplish returns in excess of normal market returns on a risk-adjusted basis

## 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,

## Benefits Of The Financial Services Industry Outweigh The Disadvantages

1396 Words | 6 Pagesexpected level of risk (Vörös,1986) Figure 1 The Efficient Frontier Source: Producing Graphics with the Toolbox. After listing every and of each individual asset in the same coordinate, with as Y-axis and as X-axis, the optimal portfolios are on the line describing the outline all of the dots, which is the blue one in the Figure 1. If every investor can follow the assumptions above, then every point on the blue line represents an efficient portfolio that maximizes the return for any given

## 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

## CAPM And Factor Models Project Essay

1640 Words | 7 Pagescompanies that you will work with throughout this project. The first company should be a large cap stock with high book to market (BM) ratio. The second company should be a small cap stock with low BM ratio. You can check how Prof. Kenneth French constructs these ratios. Look at the explanations from the data library on his website: http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html Report the information on book value, market value, etc., for your two companies. 4. In WRDS

## Key Issues Relative to Portfolio Analysis and Investment

1899 Words | 8 Pagesto the U. S. Stock markets only. This essay will be built upon extant portfolio theory and will discuss different types of risks that investors might face and how they go about managing such risks. Under consideration will be topics such as efficient frontier and optimal portfolios as well as their relevance to investment theory, under the assumption of direct investment in the stock market. DETERMINING THE PURPOSE OF YOUR INVESTMENT One of the steps in building an investment portfolio is

### Portfolio Management: Practice Problems

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

1254 Words | 6 Pages### A Brief Note On Risk Management Through Traditional Diversification

1443 Words | 6 Pages### The Capital Asset Pricing Model Essay

1565 Words | 7 Pages### Portfolio Theory As An Investment Decision Instrument

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

1161 Words | 5 Pages### Benefits Of The Financial Services Industry Outweigh The Disadvantages

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

2185 Words | 9 Pages### CAPM And Factor Models Project Essay

1640 Words | 7 Pages### Key Issues Relative to Portfolio Analysis and Investment

1899 Words | 8 Pages