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

vix trading strategytvix etfhow to calculate mean in excel 2007butterfly spread calculatorvix future quotesexponential moving average c#squaring negative numbersoptions vs futures advantagesderivation of black scholes modelfxc etfstats variancevix vs vxxcalculating rsihow to calculate var xshort tvixwhat is svxyskewness calculator onlinecalculating sample variancebull spread using callsmacd parametershow to calculate arithmetic densitycovariance calculator financeformula of average deviationstd dev calculatorultra etfmacd chartsberkshire hathaway sec filingsstock market return calculator historicalpayoff graphblack scholes option pricing model excelvariance formula for excelblack scholes definitionaapl earnings historyproshare short s&p 500unbiased estimate of population variancepayoff diagrams for call and put optionsnorm s dist excelbuy vixgreek calculatordef of standard deviationkurtosis spss interpretationwhat is a formula in excel definitionhistorical volatility formulahow is dow jones calculatedvix pricesvix options chainannualized volatility formulasharp ratio definitionvix tradingfx option valuationstandard variance calculatorrsi formula excelinterpreting variance and standard deviationhow to use normdist in excelcoefficient of skewnessgreeks of optionsvix ticker symbolcomputational formula for the sample varianceipath barclaysyahoo finance indicescalculators with negativesformula black scholesarithmetic percentagesvix chart yahooexcel calculate rate of returnleveraged etf liststock average down calculatorvix index definitiondow jones industrial average calculationexponential moving average c#standard deviation finance formulaformula for calculating average in excelubs etncftc commitment of tradersreward to variability ratio formulapercentile calculator excelultra short etf