[PDF] Chapter 1 Portfolio Theory with Matrix Algebra





Previous PDF Next PDF



Efficient Portfolios in Excel Using the Solver and Matrix Algebra

24 thg 11 2009 The portfolio standard deviation in cell C14 is the square root of the portfolio variance



Portfolio analysis - Excel and VBA

21 thg 5 2012 formulas for standard deviation and variance (the Excel 2010 equivalent formula is in column F). Descriptive statistics can also be produced ...



?P = x1 ?1 + x2 ?2 + x3 ?3

Earlier versions of Excel include the solver function under a menu titled Although the formula for the standard deviation of a portfolio of three risky ...



Note on Using Excel to Compute Optimal Risky Portfolios

This document shows how to. (1) Compute the expected return and standard deviation of a portfolio of N given risky assets;. (2) Construct the portfolio 



Markowitz Portfolio Analysis: The Demonstration Portfolio Problem

benefits comes when the portfolio standard deviation and coefficient of The Excel spreadsheet model shown in figure 1does the necessary calculations.



Am I Diversified? An Exercise for Finance Students

The standard deviation o! a portfolio drops as more securities are added to We have constructed an Excel spreadsheet that allows students to select up.



MIT Sloan Finance Problems and Solutions Collection Finance

What is the return standard deviation of your portfolio? (Hint: You would need to use Excel Solver or some other optimization software to solve the optimal 



Chapter 1 Portfolio Theory with Matrix Algebra

7 thg 8 2013 like Microsoft Excel



Information Management and Business Review (ISSN 2220-3796

Excel Based Financial Modeling for Making Portfolio Management Decisions ratio of portfolio excess returns divided by portfolio standard deviation.



University of Texas at Dallas School of Management Finance 6310

demonstrating how Excel can be used to build a spreadsheet model for solving asset a. determine the portfolio weights and the standard deviation of the ...



Using Excel s Solver Tool in Portfolio Theory

The standard deviation of the portfolio is given by the formula SQRT(G22) and the formula for the slope of the portfolio is =(F22-R_F)/H22 where R_F refers to the cell containing the value of the risk-free rate



Chapter 1 Portfolio Theory with Matrix Algebra

Aug 7 2013 · The investment opportunity set is the set of portfolio expected return and portfolio standard deviation values for all possible portfolios whose weights sum to one As in the two risky asset case this set can be described in a graph with on the vertical axis and on the horizontal axis



Portfolio Variance - Definition Formula and Example

The basic input necessary to solve the portfolio question is an assumption about the joint distribution of the underlying assets that can be combined to form a portfolio Following the CER model w e assume a joint normal distribution This means the behaviour of the assets can be summarized completely by the means variances and covariance



Portfolio analysis - Excel and VBA

PORTFOLIO ANALYSIS A portfolio can be viewed as a combination of assets held by an investor For each asset held such as company stocks the logarithmic or continuously compounded rate of returnrat time tis given by where is the stock price at time t and is the stock price in the prior period



Portfolio Optimization - SpreadsheetML

The standard deviation of the portfolio is the proportion of total assets invested in the risky asset multiply by the standard deviation of the risky asset This is because the standard deviation of the riskless asset is considered to be zero 1 3 3 Risk Reward Trade Off Line



Searches related to portfolio standard deviation excel filetype:pdf

Standard deviation is the measure of the total volatility or risk in a portfolio Standard deviation tells how widely a portfolio’s returns have varied around the average over a period of time 2023 BlackRock Inc All Rights Reserved BLACKROCK is a trademark of BlackRock Inc All other trademarks are those of their respective owners

How do you calculate standard deviation of a portfolio?

    Portfolio Standard Deviation is calculated based on the standard deviation of returns of each asset in the portfolio, the proportion of each asset in the overall portfolio i.e., their respective weights in the total portfolio, and also the correlation between each pair of assets in the portfolio. A high portfolio standard deviation highlights ...

How do I calculate standard deviation Excel?

    How to Calculate Standard Deviation in Excel (Sample) 1. Open the Microsoft Excel Document containing your data. 2. Click an empty cell. Any will suffice. 3. Start your Standard Deviation formula with =. 4. Type STDEV.S. 5. Select the cells you want the Standard Deviation computed for.

What does standard deviation measure in my portfolio?

    Portfolio Standard Deviation is the standard deviation of the rate of return on an investment portfolio and is used to measure the inherent volatility of an investment. It measures the investment’s risk and helps in analyzing the stability of returns of a portfolio.

Chapter 1

Portfolio Theory with Matrix

Algebra

Updated: August 7, 2013

When working with large portfolios, the algebra of representing portfolio expected returns and variances becomes cumbersome. The use of matrix (lin- ear) algebra can greatly simplify many of the computations. Matrix algebra formulations are also very useful when it comes time to do actual computa- tions on the computer. The matrix algebra formulas are easy to translate into matrix programming languages like R. Popular spreadsheet programs like Microsoft Excel, which are the workhorse programs of manyfinancial houses, can also handle basic matrix calculations. All of this makes it worth- while to become familiar with matrix techniques for portfolio calculations.

1.1 Portfolios with Three Risky Assets

Consider a three asset portfolio problem with assets denoted andLet (=)denote the return on assetand assume that the constant expected return (CER) model holds: 2 cov(

Example 1Three asset example data

1 Stock

Pair (i,j)

A 0.0427 0.1000 (A,B) 0.0018

B 0.0015 0.1044 (A,C) 0.0011

C 0.0285 0.1411 (B,C) 0.0026

Table 1.1: Three asset example data.

Table 1.1 gives example data on monthly means, variances and covariances for the continuously compounded returns on Microsoft, Nordstrom and Star- bucks (assets A, B and C) based on sample statistics computed over the five-year period January, 1995 through January, 2000 1 .Thevaluesof and (risk-return trade-os) are shown in Figure 1.1. Clearly, Microsoft provides the best risk-return trade-oand Nordstrom provides with worst. Let denote the share of wealth invested in asset(=)and assume that all wealth is invested in the three assets so that =1

The portfolio return,

is the random variable (1.1) The subscript "" indicates that the portfolio is constructed using the x- weights and

Theexpectedreturnontheportfoliois

(1.2) and the variance of the portfolio return is 2 =var( )(1.3) 2 2 2 2 2 2 +2 +2 +2 Notice that variance of the portfolio return depends on three variance terms and six covariance terms. Hence, with three assets there are twice as many covariance terms than variance terms contributing to portfolio variance. Even with three assets, the algebra representing the portfolio characteristics (1.1) - (1.3) is cumbersome. We can greatly simplify the portfolio algebra using matrix notation. 1 This example data is also analyized in the Excel spreadsheet 3firmExample.xls.

1.1 PORTFOLIOS WITH THREE RISKY ASSETS3

0.00 0.05 0.10 0.15 0.20

0.00 0.01 0.02 0.03 0.04 0.05 0.06

p p MSFT NORD SBUX

GLOBAL MINE1

E2 Figure 1.1: Risk-return tradeos among three asset portfolios. The portfo- lio labeled "E1" is the ecient portfolio with the same expected return as Microsoft; the portfolio labeled "E2" is the ecient portfolio with the same expected return as Starbux. The portfolio labeled GLOBAL MIN is the min- imum variance portfolio consisting of Microsoft, Nordstrom and Starbucks, respectively.

1.1.1 Portfolio Characteristics Using Matrix Notation

Define the following3×1column vectors containing the asset returns and portfolio weights R= x= In matrix notation we can lump multiple returns in a single vector which we denote byRSince each of the elements inRis a random variable we call Rarandom vector. The probability distribution of the random vectorRis simply the joint distribution of the elements ofR.IntheCERmodelall returns are jointly normally distributed and this joint distribution is com- pletely characterized by the means, variances and covariances of the returns. We can easily express these values using matrix notation as follows. The

3×1vector of portfolio expected values is

[R]= and the3×3covariance matrix of returns is var(R)= var( )cov( )cov( cov( )var( )cov( cov( )cov( )var( 2 2 2 Notice that the covariance matrix is symmetric (elements othe diago- nal are equal so that= 0 ,where 0 denotes the transpose of)since cov( )=cov( )cov( )=cov( )andcov( cov( Example 2Example return data using matrix notation

Using the example data in Table 1.1 we have

00427
00015 00285

00100 00018 00011

00018 00109 00026

00011 00026 00199

1.1 PORTFOLIOS WITH THREE RISKY ASSETS5

In R, these values are created using

> asset.names <- c("MSFT", "NORD", "SBUX") > mu.vec = c(0.0427, 0.0015, 0.0285) > names(mu.vec) = asset.names > sigma.mat = matrix(c(0.0100, 0.0018, 0.0011, + 0.0018, 0.0109, 0.0026, + 0.0011, 0.0026, 0.0199), + nrow=3, ncol=3) > dimnames(sigma.mat) = list(asset.names, asset.names) > mu.vec

MSFT NORD SBUX

0.0427 0.0015 0.0285

> sigma.mat

MSFT NORD SBUX

MSFT 0.0100 0.0018 0.0011

NORD 0.0018 0.0109 0.0026

SBUX 0.0011 0.0026 0.0199

The return on the portfolio using matrix notation is =x 0 R=( Similarly, the expected return on the portfolio is =[x 0 R]=x 0 [R]=x 0

The variance of the portfolio is

2 =var(x 0 R)=x 0 x=( 2 2 2 2 2 2 2 2 2 +2 +2 +2 The condition that the portfolio weights sum to one can be expressed as x 0 1=( 1 1 1 =1 where1is a3×1vector with each element equal to 1.

Consider another portfolio with weightsy=(

0

The return on

this portfolio is =y 0 R= Later on we will need to compute the covariance between the return on port- folioxand the return on portfolioycov( )Using matrix algebra, this covariance can be computed as =cov( )=cov(x 0 Ry 0 R) =x 0 y=( 2 2 2 2 2 2

Example 3Portfolio computations in R

Consider an equally weighted portfolio with

=13This portfolio has return =x 0

Rwherex=(131313)

0

Using R, the

portfolio mean and variance are > x.vec = rep(1,3)/3 > names(x.vec) = asset.names > mu.p.x = crossprod(x.vec,mu.vec) > sig2.p.x = t(x.vec)%*%sigma.mat%*%x.vec > sig.p.x = sqrt(sig2.p.x) > mu.p.x [,1]

1.1 PORTFOLIOS WITH THREE RISKY ASSETS7

[1,] 0.02423 > sig.p.x [,1] [1,] 0.07587 Next, consider another portfolio with weight vectory=( 0 =(08 0402)
0 and return =y 0

RThecovariancebetween

and is > y.vec = c(0.8, 0.4, -0.2) > names(x.vec) = asset.names > sig.xy = t(x.vec)%*%sigma.mat%*%y.vec > sig.xy [,1] [1,] 0.003907

1.1.2 Finding the Global Minimum Variance Portfolio

The global minimum variance portfoliom=(

0 for the three asset case solves the constrained minimization problem min 2 2 2 2 2 2 2 (1.4) +2 +2 +2 s.t. =1

The Lagrangian for this problem is

2 2 2 2 2 2 +2 +2 +2 1) and thefirst order conditions (FOCs) for a minimum are 0= Cp =2 2 +2 +2 +(1.5) 0= Cp =2 2 +2 +2 0= Cp =2 2 +2 +2 0= C= 1 The FOCs (1.5) gives four linear equations in four unknowns which can be solved tofind the global minimum variance portfolio weights and Using matrix notation, the problem (1.4) can be concisely expressed as min m 2 =m 0quotesdbs_dbs19.pdfusesText_25
[PDF] portfolio standard deviation formula

[PDF] portion sizes for toddlers 1 3 years

[PDF] portland area bike routes

[PDF] portland bike map app

[PDF] portland bike rides 2018

[PDF] portland maine police arrests records

[PDF] portland maine police beat

[PDF] portland maine police department non emergency number

[PDF] portland maine police staff

[PDF] portland police academy

[PDF] portland police activity log

[PDF] portland police department maine arrest log

[PDF] portland police recruitment

[PDF] portland police written test

[PDF] portland rainfall 2020