Why You Need Weighted Average for Calculating Total Portfolio Return

This is a very basic article explaining why unweighted arithmetic average is not suitable when portfolio is not equally weighted. See more about When to Use Arithmetic Average and When Not.

3 stock portfolio example

Let’s say you have 1 million dollars and you want to invest it in stocks. You construct a fairly concentrated portfolio – you particularly like stock ABC. At the beginning of the year you have invested 1 million dollars in 3 stocks:

The important factor for illustrating the point of this article is that the positions have different weights in the portfolio: 80%, 10%, and 10%.

Performance of individual stocks

One year later, you are looking at your portfolio’s performance. The 3 stocks performed like this:

Arithmetic average of the stocks’ returns

What is the arithmetic average? The sum of -20%, +10% and +40% equals +30%. Divided by 3, the arithmetic average of the stocks’ returns in the last year is +10%. (See How to Calculate Arithmetic Average: The Very Basics).

Percentage return and P/L of total portfolio

How much money have you made?

The whole portfolio P/L is negative 160,000 plus 10,000 plus 40,000, which equals a loss of USD 110,000. On percentage basis, you have lost 11% of your initial investment.

Why is arithmetic average not working?

Though 2 of the 3 stocks have risen and arithmetic average of the 3 stocks’ returns is +10%, your portfolio has lost money, as your biggest (and losing) position in stock ABC has outbalanced the two smaller positions. Had your portfolio been equally weighted (each stock 33.3%), its return would have been +10%. But you were unlucky to allocate more to ABC, the one stock that has lost in the end.

Weighted average is better for calculating total portfolio return

For calculating average return of a portfolio or basket of stocks, arithmetic average is only suitable when all stocks have equal weights in the portfolio, which is rarely the case. When the weights are different, you need to take it into account and use weighted average instead.

Related pages

cost of capital wacccboe vix term structureimplied volatility standard deviationdelta formulasthe black scholes formulas&p correlationskewness calculationbond volatility formulahow many shares in 1 option contractspx cboecalculate exponential moving average excelconvert standard deviation to variancenorm disttrading today black scholes calculatorvix historicalbull call credit spreadnormdist functionvix futures margincalculate the mean variance and standard deviationformula for calculating variance in statisticsprice weighted index calculationdefine implied volatilitystock sharpe ratiowhat is negative three squaredskewness of distributione excel formulanormsdist formulacftc cot reportvariance and standard deviation for grouped datastraddle position optionscalculate mean sdhow to subtract standard deviationssoros fund management websiteblack scholes option pricing model formulasharpe calculationaapl share price historyoptions the greeks2 period rsimeasures of dispersion calculatorskewness moments and kurtosishow to calculate deviation in excel3x volatility etftremont hedge fund indexetf s&p 500 shorthow to read the vixvix futures marginstock standard deviation calculatorlognormal volatilityformula to calculate average in excelhow to calculate sample variance in excelintrinsic value calculatorspx chartsblack scholes dividendmacd calculationhow to calculate weighted average in excel with percentageshull options futurescalculate moving average excelrelative strength calculatorcommitment of traders charteur usd etfexcel calculations formulasweighted average cost of capital formula excelcalculating standard deviation excelcalculate historical volatilityberkshire hathaway 13-fput option premium calculatorcalculate delta of optionstocks at all time lowsexcel calculator formulagreeks calculatordelta hedgeinverse volatilitycalculate realized volatilitycftc cot reportblack scholes option pricing