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

black scholes inputsexcel exponential formulamacd interpretationshort volatility etfdelta option greekvix derivativesskewness and kurtosis formulacalculating std deviationoption delta hedgeoption straddlesschedule 13fvix tradeintraday mean reversionstd deviation and varianceshort volatility etfthe black-scholes formulastdev ifswiss currency etfkurtosis definition in statisticsstock price volatility formulawhat is the formula for waccsample variance excel formulaequity hedge fund strategiessharpe ratio for stockshow to calculate rate of return in excelhow to calculate a sample varianceroot sum of squares formulaleveraged short etfvix historical chartdow jones price weightedmean mode median excelsample kurtosisdescriptive statistics calculatordeviation score formula0-100 calculatorwacc meaninginverse vxxwhat is the meaning of skewnesssample mean excelimplied volatility vs historical volatilityhow to calc varianceskewness statistics definitionformula for standard deviation on excelsec 13f filingshow to calculate variance on calculatorhow many shares in an option contractexcel var formulacalculate skewoex option chainstandard deviation finance formulacommitment of traders chartweighted average accounting formulaaapl stock historyoption payoff diagram generatorbloomberg s&p futuresformula for coefficient of skewnessblackscholes formulahistorical volatility calculationvix yahoo financeadvantages and disadvantages of mean median and modeotm optionfutures rollover datesmarket sharpe ratio13f reportingetf correlation calculatorintrinsic value calculator excelcalculating emameasures of skewnessskew formulawhat is skewness and kurtosisvix downloadvix tradingpopulation and sample varianceweighted average calculator accountingoption greek deltayahoo finance msftblack scholes call option calculators&p 500 short etfoptions greeks calculatorhow to buy vixstats variance formula