Having selected two stocks, LLOY.L and BARC.L, from the FTSE100 Index and downloaded the day-to-day monetary values, crossing the period January 2008 – December 2010, it is now clip to cipher the day-to-day returns and the mean returns. The day-to-day returns are calculated by deducting from the shutting portion monetary value of the undermentioned twenty-four hours the shutting portion monetary value of the anterior twenty-four hours, all divided by the shutting portion monetary value of the anterior twenty-four hours. The day-to-day return of stocks represents the changing of the value of the stock in a short term point of position, so the value in per centum that could be obtained by merchandising the stock in different yearss at the midquote ( shuting ) monetary value. This paper does n’t take into history dividend in the return equation for simpleness.

The mean returns are the amount between the day-to-day returns of each stock divided by the figure of yearss: LLOY.L -0,09 % and BARC.L 0,05 % . As it is an norm of the amount of the day-to-day returns, the mean return of a stock is like a drumhead value in a long term point of position.

In order to cipher the discrepancy, which is the step of the variableness of measured informations from the mean value of the set of informations, we use the excel prepared formula =VAR and the consequences are LLOY.L 0,00329681532 and BARC.L 0,00298971628. Discrepancy is besides the step of scattering of a set of informations points around their average value.

The standard divergence of the two stocks is calculated by the prepared expression of excel =DEV.ST or merely by ciphering the extremist square of the discrepancy, LLOY.L 0,05741790071952 and BARC.L 0,054678298027727 and it represents the variableness of a distribution.

The value which represents the correlativity between two variables is the covariance of the two stocks which is 0,00197867681213.

Having constructed a portfolio which consists of 50 % in each stock it is now clip to cipher its return and criterion divergence which severally are -0,00018953911968 and 0,05060604020891: in order to cipher the standard divergence we have to cipher the discrepancy as the standard divergence is the extremist square of the discrepancy.

The tabular array below shows a set of portfolios of the two stocks with different weights. It is chiefly of import to detect two factors: the returns and the discrepancy. As the mean return of LLOY.L is negative, a rational investor would take to put merely in BARC.L in order to acquire a positive return ; consequently to the information of the discrepancy it is important to detect that it has high values in the extremes of the composing of the weights of the portfolio. High values of discrepancies mean high values of hazard. Actually, if an investor does non cut down the exposure to put on the line by variegation of his portfolio with different assets the hazard of losingss is higher. The hazard is higher because with variegation the investor is able to cut down the particular hazard of the house and will be subjected merely to the general market hazard.

The graph below summarizes a portfolio with different weights of assets. The result is what is called the efficient frontier ( the upper portion ) and so the graph shows the correlativity between returns and hazard ( standard divergences ) .

The old account meant to tag the difference between what appears to be the best pick for an investor and so the highest return and what is truly the best pick, which is maximising the public-service corporation of the investor by minimising his exposure to hazard. The minimal exposure to hazard is calculated by minimising the discrepancy and by ciphering the exact weights of the assets in the portfolio. This paper has used the excel prepared map convergent thinker to acquire the minimal discrepancy in the portfolio made with those two different stocks. The minimal discrepancy is 0,25 % with weights of 43 % LLOY.L and 57 % BARC.L as highlighted.

In order to accomplish a portfolio giving a return of 25 % the weight of each stock should be equal to: LLOY.L -17536 % and BARC.L 17636 % . This consequence has been obtained by utilizing the excel map convergent thinker and it mirrors the fact that an investor should sell LLOYD.L assets ( -17536 % ) and purchase BARC.L assets ( 17636 % ) in order to accomplish a return of 25 % .

Question ( B ) :

It is now clip to specify what a “ Market Portfolio ” is. This paper intends to get down depicting the market with hazardous assets and so trades with a portfolio with hazard free assets in order to size up the chief differences, because it is merely in the composing between these two different set of portfolios that there is the market portfolio. Before covering peculiarly with the market portfolio it is of import to analyse the functionaries moving in the fiscal environment, investors in peculiar. There are two sorts of investors: hazard averse and hazard takers. If we consider hazard as a step of uncertainness about both the development of the market and the success of our investing, hazard averse investors are those functionaries who prefer to put in low hazard assets even though they will non accomplish a high income. Risk takers alternatively are those investors whose purpose is to wager on the market development and invest in a more hazardous manner in order to acquire better returns.

The chief aim of the description of these functionaries it is to depict the combination of assets of their portfolios. Hazard takers invest on assets which have a high grade of scattering ( the discrepancy and so the standard divergence ) in the concluding income. There is a high opportunity that the concluding result will non be equal to the expected return. An efficient portfolio for hazard takers is made by maximising the expected returns for a given sum of hazard or minimising hazard when the expected return is given. Risk antipathetic investors will put in assets with a low or about nonexistent degree of hazard, even though the expected return is non high.

Efficient portfolios are shown in the efficient frontier, which is a curve demoing optimum portfolios made by assets of different grades of hazard. The efficient frontier offers the highest return for any degree of hazard and it is constructed by uniting mean and standard divergence, so return and hazard. In the graph below the efficient frontier is merely AB because for every degree of hazard ( discrepancy ) we can acquire higher expected return in AB alternatively of in AC: this represents efficiency in the choice of assets for a portfolio.

Having analyzed the portfolio made of hazardous assets it is now clip to depict the contrast to a portfolio of hazard free assets. A portfolio of hazard free assets reduces its hazard to zero. The expected return turns into realized return ( Expected ( R ) = Realized ( R ) ) . Government bonds are normally the closest illustration of hazard free assets. The most seeable alteration is that the efficient frontier becomes a consecutive line. This consecutive line is called capital market line and its equation is E ( Rp ) =Rf+ [ ( E ( Rm ) -Rf ) /I?m ] xI?p. The expected return on a portfolio depending on a hazard free rate of return suffers less hazard because the discrepancy of the portfolio is smaller, as the discrepancy of the hazard free assets and the covariance are equal to nothing. The chief advantage given by hazard free assets is that investors can borrow or impart any sum of money at the hazard free rate of return depending on the weight they have, as the graph below shows.

It is of import to pay attending to both the hazard constituent and the hazard free one in order to happen out the Market Portfolio ( M, in the graph below ) as it is merely the tangent point between the efficient frontier and the capital market line. The CML is the line used in the capital plus pricing theoretical account to exemplify the rates of return forA efficient portfolios depending on the riskless rate of return and the degree of hazard ( standardA divergence ) A for a peculiar portfolio. Markowitz introduced a new end for investors, which is to maximise their public-service corporation. The public-service corporation is maximized in the market portfolio, which is the equalisation between the efficient frontier and the capital market line. The public-service corporation is about calculated as the expected return minus the discrepancy of return, which is multiplied to a hazard averse variable. If an investor wants to accomplish the best public-service corporation from the combination between assets of his portfolio, he will seek to minimise the discrepancy in order to maximise the expected return. The Market Portfolio is where every investors will desire to put. Actually this portfolio must include all hazardous assets and as the market is in equilibrium all assets are included in their market value. Since the Market Portfolio contains all hazardous assets, it is a wholly diversified portfolio, which means that all the alone hazard of single assets ( unsystematic hazard ) is diversified off. In the presence of capital markets, rational hazard averse investors select efficient portfolios that lie in the CML with the highest expected Sharpe ratio ( hazard premium/standard divergence ) which means with the highest expected return and the lowest grade of hazard.

The construct of Market Portfolio is purely related to the construct of the “ Separation Theorem ” . James Tobin explained in the Separation Theorem that if an investor holds hazardous assets and he is able to borrow ( purchasing stocks on border ) or lend ( purchasing hazard free assets ) at the same rate, so the efficient frontier is a individual portfolio of hazardous assets plus adoption and loaning. Tobin ‘s Separation Theorem says an investor can divide the job into first happening that optimum combination of hazardous assets and so the tangency point ( Market Portfolio ) and so make up one’s minding whether to impart or borrow, depending on his attitude toward hazard. If there is merely one portfolio plus adoption and loaning, it is got to be the market.