A Proven Tool for Managing Your Portfolio
In school, we learned that to take the average of something, you take the sum and divide by the number of items.
This is called the simple average. For some things, this works well enough.
But when it comes to managing your investments, knowing the simple average isn’t enough.
Take a look at the following table.
The table shows Joe’s $10,000 stock portfolio. He has three stocks. Stock A yields 4%, Stock B 2%, and Stock C 3%. What is the portfolio’s dividend yield?
If you take the simple average, you would just add 4%, 2%, and 3% together and then divide by 3.
The answer is 3%!?
But that’s wrong.
The Proper Way to Do It
As you can see in the Annual Dividend column, John actually gets $330 in dividend a year ($200 + $40 + $90), so his portfolio’s current yield is actually 3.3% ($330 ÷ $10,000)!
The simple average does not work because the three stocks are not equally weighted. In real life, a real-money portfolio is almost never truly equally weighted, because stock prices move and change the market value.
To properly calculate the portfolio’s yield, you have to take into account the different weight of each position in the portfolio. This is where weighted average comes in.
Let’s go back to our example.
For each stock position, you must calculate its percentage of the portfolio, and then multiply that percentage by the yield.
Therefore, to calculate the weighted yield for Stock A, you multiply 50% by 2% to get 2%. Repeat the process for B and C.
After that’s done, you just have to take the sum of all the weighted dividend yields of each stock to get the weighted average yield of the portfolio.
What About Stocks That Don’t Pay a Dividend?
Don’t forget to include the stocks that don’t pay a dividend in the calculation. After all, they are also part of your portfolio!
Let’s change our example a little bit and add a Stock D that doesn’t pay any dividend. The same method still works.
Nowadays, online brokers usually have a button you can click to export your account summary into a spreadsheet (such as Excel).
For each position, the account summary should already display the percentage weighting and the yield, so you just have to multiply the two numbers together and then add them up for all the positions.
The weighted average calculation method is not rocket science, but it is a useful tool that comes in handy when it comes to investments. Besides the dividend yield, if you want to figure out your portfolio’s return or the interest rate you are paying on a group of loans, taking the weighted average works.
Knowing how to accurately calculate the weighted average enables you to better manage your portfolio. After all, if you don’t have a clear picture of your portfolio’s characteristics, it’s harder to steer.
Editor’s Note: Investing Daily’s Scott Chan just provided you with timeless investing tools that work even in difficult conditions.
But we’ve only scratched the surface of our team’s expertise. To mitigate market risk and still make money, consider the advice of our colleague Jim Pearce.
Jim Pearce is the chief investment strategist of our flagship publication, Personal Finance. Jim has found the optimal way to cash in on the artificial intelligence (AI) super-boom. It’s an obscure “picks-and-shovels” play that you won’t hear about on CNBC.
Jim’s AI investment lets you get started for about $100…and it generates regular cash payouts of up to $5,397. Want to learn more? Click here.