StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Minimum Variance Portfolio - Assignment Example

Cite this document
Summary
This paper under the title "Minimum Variance Portfolio" focuses on the variance which refers to the rate of inconsistency in variously related variables. In the context of this paper, portfolio refers to a group of stock that is possessed by an individual or firm. …
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER93.4% of users find it useful
Minimum Variance Portfolio
Read Text Preview

Extract of sample "Minimum Variance Portfolio"

Minimum Variance PortfolioVariance refers to the rate of inconsistency in various related variables. In the context of this paper, portfolio refers to a group of stock that is possessed by an individual or firm. Therefore, minimum variance portfolio (MVP) refers to the least possible level of inconsistency in the rates of stock possessed in a stock market by an individual or firm. Minimum variance portfolio is important for the purpose of valuation and prediction of variables, such as stock.

For the purpose of this paper, the Microsoft Excel file attached will be the basis of our minimum variance portfolio. It shows the rates of stock for a year running. This MVP analysis was be preceded by the calculation of correlation matrix of the stocks as well as their standard deviation variance. Both this values are indicated on the Microsoft Excel attachment.Maple Syntax TestDuring the calculation of the correlation matrix and the standard deviation variance, maple concepts were used. This section of the paper is going to test and prove the validity of the procedures and statements used in order to ascertain that no syntax errors were committed during the process.

This can be proven as follows:Use of the colon and comma: in maple, statements must end with a colon and arguments separated with a comma (Monagan, Geddes et al., 14).For instance, during the development of correlation, for example inStandard Life stock, we use the formula =CORREL(N3:JF3,N3:JF3). The comma shows the distinction of the two arguments while the colon relates one variable to the other.Use and match of parentheses: a maple can only be executed if the arguments are enclosed in parentheses.

The opening parenthesis must be similar to the closing one(Monagan, Geddes et al., 19). In the attached case, all the maples have the parentheses () matching in all stocks.Division and multiplication signs: a back stroke (/) is used for division while asterisk (*) is used for multiplication (Monagan, Geddes et al., 18).Creation of Matrices, MVP and PortfolioThe syntax provided is an M X M square matrix of stocks, as shown in the attachment. The correlation coefficient between i and j (for example between Standard Life and Resolution) is given by the (ij)th element.

All diagonal elements are 1.0000 since this is correlation of variables with themselves(Monagan, Geddes et al., 59).The total risk is a function of all five components of the stock:W = j Mj.Total Risk(Diag Matrix) = Tot risk * Diag matrix.Minimize W = Corr(5; Standard life, Petrofac, Glencore Xstrata, Resolution, Vodafone Group)In calculation of MVP, we must use the standard deviation and correlation of the stocks provided. Standard deviation can be calculated following the following steps:Divide the value of each stock with its proceeding one and subtract one from the result; which in our instance we are going to take Standard Life as an example.

The standard deviation presented on 1/1/2013 is determined as the value of the stock on 1/1/2013 divide by the value on 31/12/2012 and subtract one from the result. Mathematically, this is:(332.1/334.6) – 1 to get -0.0075. We do the same for the standard deviation of all stocks for each day, and this has been done on the red coloured parts of the Excel attachment that extends from cell N3 to cell JG3. Once this has been determined, we calculate correlation as follows:Get the risk value of one stock and divide it by the standard deviation obtained for the other four stocks.

This can be expressed as, correlation = risk/(SD of stock one)(SD of stock two)(SD of stock three)(SD of stock four). In the Excel attachment file, this correlation is found in the region extending from G3 to H3. To get MVP, then we proceed as follows:W(stock 1) = (SD stock 1)/(SD stock 2) + (SD stock 3) + (SD stock 4) + (SD stock 5).From the valuation, the portfolio would consist of 0.246928 of STANDARD LIFE, 0.336753 of PETROFAC, 0.296969 of GLENCORE XSTRATA, 0.18714 of RESOLUTION and 0.195374 of VODAFONE GROUP.

ConclusionThe portfolio calculated is from the MVP of each of the five stocks. Valuation at the rates will give the minimum variance possible of the stocks value.Works CitedMonagan, B., Geddes, K. et al. Maple: Introductory Programming Guide. Canada: Waterloo Maple Inc, 2009.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Minimum Variance Portfolio Assignment Example | Topics and Well Written Essays - 500 words”, n.d.)
Minimum Variance Portfolio Assignment Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/finance-accounting/1631592-i-have-written-the-topic-in-order-description-due-to-the-word-limit
(Minimum Variance Portfolio Assignment Example | Topics and Well Written Essays - 500 Words)
Minimum Variance Portfolio Assignment Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/finance-accounting/1631592-i-have-written-the-topic-in-order-description-due-to-the-word-limit.
“Minimum Variance Portfolio Assignment Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/finance-accounting/1631592-i-have-written-the-topic-in-order-description-due-to-the-word-limit.
  • Cited: 0 times

CHECK THESE SAMPLES OF Minimum Variance Portfolio

The Different Types of Assets

By combining the two assets in a portfolio, any potential unsystematic risk will be compensated because any unexpected I agree to this because diversification spreads the risk over the different types of assets.... I totally disagree to the statement; it is quite opposite of the fact that there is a direct relationship between correlation of the portfolio assets and its risk.... The higher the correlation between the portfolio assets, the more chances will be that the downside movement of one asset will accompany the same in the other and thus the investment will turned to be the worst....
6 Pages (1500 words) Essay

Introduction to Financial Accounting

2 (d) In order to find out if diversification would reduce the risk of the portfolio, the correlation of assets must be studied (Reilly and Brown, 2003, p.... The greater the number of negatively correlated assets in a portfolio, the lesser will be the risk.... 637 which shows that the two stocks are moderately correlated, that might not help much in diversifying the risk of the portfolio....
5 Pages (1250 words) Assignment

CAPM and its Practical Applications

The CAPM is built on the portfolio model that Harry Markowitz (1959) developed.... In the model, a portfolio is selected by an investor at time t-1 which at t produces a stochastic return.... This results in investors choosing “mean-variance-efficient” portfolios, the portfolios in this case 1) given variance, maximizes returns and 2) given expected returns, minimize portfolio return variance.... This algebraic statement is turned by the CAPM into a prediction that is testable about the connection between expected returns and risk through identification of an efficient portfolio if asset prices should clear all the assets off the market....
6 Pages (1500 words) Essay

Investment Fund Objectives

The long term portfolio purpose could be served effectively with no diversification due to certain special situations.... Long term investments are diverse to minimize the chances of potential loses unless it is determined by the concerned parties such as the finance committee.... hellip; In this case short term funds should provide return, liquidity as well as safety (Aggarwal and Wysocki 2005)....
5 Pages (1250 words) Essay

Selling Short, Initial Margin Deposit

An investor will receive a margin call when the value of the shares held in investors' portfolio against margin borrowing fall below a particular threshold level.... From the paper "Selling Short, Initial Margin Deposit" it is clear that semi-strong form of efficiency outline that share prices have already discounted the publically available information and as such, any attempts to utilize publically available information may not result into any abnormal profits....
6 Pages (1500 words) Assignment

Efficient Frontier and the Famous Portfolio Theory of Markowitz

All such portfolios are called Minimum Variance Portfolio.... For a two asset portfolio, the weight of assets in the Minimum Variance Portfolio can be computed byThe efficient frontier curve would have changed if the assumption that borrowing or lending is not allowed at the same rate.... inimum variance portfolio is relevant with the concept of efficient frontier, as, in order to find the efficient portfolio, we must identify the portfolios that have the minimum variance for each level of expected rate of return....
8 Pages (2000 words) Assignment

Financial Management: Cash Flows of the Company

The paper presents calculating the fair price of the bond and a stock's intrinsic value.... The intrinsic value of a stock is the underlying value of a company.... This approach is considered to be having numerous cons in complex country indices like those of emerging markets.... hellip; The substitute basket is made up with a mounted view to attempt and minimizing costs while maximizing tax as they complying with legal requirements....
10 Pages (2500 words) Coursework
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us