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

kurtosis measureinventory average cost methodsharpe ratio interpretationformula for median in excelhow to calculate payoffmacd crossover indicatorvix chart yahoovariance and standard deviation formulasexcel goal seek macrocomputational formula for variancedelta of a call optionshort straddle positionexcel formula for varianceyahoo stock symbol searchyahoo finance download csvfinance.yahoo.com msftapple share price history graphexcel formula calculationshighest sharpe rationotepad font sizevix volatility chartvix term structure cboesquared deviation calculatorwhat is the formula for variance in excelwacc weighted average cost of capitalrsi interpretationexcel profit and loss formulabook on options tradingwhat is sharpe ratio with examplestandard deviation calculator with mean and sample sizedelta hedging optionsubs e tracscboe s&p 500downloading stock prices from yahoo financeoption profit calculatorequally weighted portfolioformula for mean variance and standard deviationvix index real timepi symbol excelvixy usprofit and loss formulasexcel exp functionhow to calc variancesharpe ratio formula examplecalculate realized volatilityuxvyvxx options settlementblack scholes calculator with dividendscftc commitment of traders reportadvantages of mean median modefutures notional valueput spread payoffvxx optionoption black scholes calculatorarithmetic basicss&p 500 csvmacd valuesdescriptive statistics calculatorpayoff diagram call optioncalculate smavix formulaoptions futures and other derivatives john c hull solution manualhow to calculate sigma squaredkurtosis coefficienthow to create formulas in excelstandard deviation of returns calculatorblack scholes normal distribution tableblack scholes with dividendvxx optionsmsft historical stock pricecalculating variance in excelfinding waccipath vxxkurtosis valuesample mean formula exceloption pricing calculator black scholescalculate median exceln d1 black scholes