In my previous post, I wrote about the Beardstown Ladies who had to suffer public humiliation because they couldn’t tell what their annualized returns were.
In their defense, not many investors do know what their actual returns are!
Why? Because most brokers, don’t provide that information, including online portfolio managers like Google Portfolio and Yahoo Finance.
Don’t Confuse Return On Investment With Annualized Returns
This 50% is what’s called Return On Investment. It simply tells you your overall gain (or loss).
Nice to know, but that’s not what you should be looking at when measuring portfolio performance. Why? Because in this example, I never told you how long it took me to make that money! What if I told you that I made this trade in 1999, got spooked, and have been sitting on this profit ever since?
Growth And The Time Factor
That is, had I invested in say Treasuries or CDs (bank rates were much higher back then and prime rate was about 8%) that offered 3.44%, I would’ve made the same amount today without the stress and with no risk!
That’s why time value is important and ROI does not take that into account.
The 3.44% is also called the APY that we are all so familiar with. From an investor’s perspective that’s exactly what you should be looking at. If you put in a certain amount of money for certain number of years, what is your return? That’s your annualized return (also called CAGR- Compound Annual Growth Rate).
But when you invest in the stock market, you don’t make a single trade and sit on it for a set number of years. The deposits and withdrawals are spread out and at irregular intervals plus you have dividends, dividends reinvested, stock splits, taxes… no wonder brokers don’t want to do this!
The trick is to find out your APY or your annualized return taking the above into consideration. That’ll tell you how you really are doing.
How To Find The Annualized Rate Of Return (APY) Of Your Portfolio?
Or you could simply use the FREE online tool I’ve provided to calculate the APY which looks like the read only view shown below.
What You’ll Need
- A copy of the APY spreadsheet. Click on File..Make a copy for an editable version of this tool. (If this menu is greyed out, make sure you are signed in to Google – top right ‘Sign In’ menu)
- Your portfolio value as of the start date from which you wish to calculate APY. You can pick any date
- The current date and the ending value of your portfolio as of this date
- All cash deposits and withdrawals during this period along with their dates
Howto Calculate The Personal Rate of Return or APY
- Enter the beginning date and value of your portfolio in the first row as a negative number. This should include cash plus the market value as of your investments as of that date
- Enter the current date and value of your portfolio in the last row as a positive value
- Fill out any cash deposits(negative) and withdrawals(positive) during this period
- Don’t leave blank rows. Delete by right clicking on the row and selecting delete. You can insert additional rows using the same technique
- The APY is automatically displayed in the final cell!
What About Taxes And Dividends?
Glad you asked! Taxes are entered as a negative number. Don’t include dividends unless you withdraw them. If left as cash, it is a part of your overall portfolio value. Never include dividends reinvested.
I’m Confused With What’s Positive And What’s Negative!
Focus on your pocket! If cash goes out, that’s negative. If cash comes in, that’s positive. Your initial amount is the cash you paid to purchase your assets in your portfolio, hence that is negative. The final amount is the cash you would’ve withdrawn had you sold all your securities, so that’s positive. If you withdraw dividends, that’s money coming in; enter that as a positive value. When you pay taxes, capital gains or for the dividends, that’s money going out of your pocket and that should be entered as a negative value.
There you have it! Now how did you do compared to the S&P 500?
The Moment Of Truth!
Here’s how the market did for the past 1, 5 and 10 years. How did you do?
|1 Year||5 Years||10 Years|
Did you beat the market Mr. Investor?