Let me talk about the key point first: I think the number that investors should pay most attention to is the annualized return on investment (aka Internal return rate: IRR).
In the first chapter of the book “The Rules of Super Growth Stocks Investing”, section 1-1, I listed my historical return on investment for the past two decades, compared with the S&P 500 index and the Taiwan stock price-weighted index for the same period of each year. In addition, I once wrote an article “What information should investors take notes? Why? “, you can find out the figures that investors should record.
How I calculate?
I personally use Google spreadsheet to calculate. The numbers listed below are the numbers that I think investors should record, as well as my calculation methods, or where to obtain them, and points to pay attention to:
|How to calculate?|
|Annual return||= (The amount of the investment portfolio on the 12/31 of the year-the fund added during the period-the handling fees-the amount of the investment portfolio on the 12/31 of the previous year) / the amount of the investment portfolio on the 12/31 of the previous year|
|S&P 500||= (S&P 500 index on 12/31 of the year-S&P 500 index on 12/31 of the previous year)/S&P 500 index on 12/31 of the previous year|
|Annualized rate of return (IRR)||=(Present value of portfolio/100)^(1/(number of investment years))-1|
Some tips when calculating IRR
Here are some tips when calculating, and my personal experience:
- All my annual figures are calculated based on the figures on the 12/31 of the year minus the figures on the 12/31 of the previous year.
- Why is the annualized return on investment (IRR) important? Because according to the rule of 72, you only need to divide 72 by your annualized return on investment to know that your assets will double in about a few years.
- How to calculate the extra funds added during the investment period? My own calculation method is to deduct the funds invested every year (regardless of the day of the period), various handling fees, commissions, taxes, ADR storage fees, securities dealers’ other fees, and remittance handling fees. Deducted from the total remuneration.
- Excel’s annualized return on investment calculation formula cannot calculate numbers with negative returns, but Google Sheet does not have this situation, so I personally don’t use the formula, write a piece of code to calculate it, and then pull the year in the Excel sheet.
Why is the annualized return on investment important?
In addition, I think two thing is very important:
- The law of large numbers, with the increase of investment years and the expansion of funds, it will be more and more difficult to achieve a certain annual return rate every year.
- Investors should pay attention to their annualized investment rate of return (IRR). Why?
- Because according to the rule of 72, you only need to divide 72 by your annualized return on investment. You can know how many years your wealth will be doubled ───we care about this number.
- We are unlikely to get an extraordinary annual rate of return every year. It doesn’t make much sense to only look at the annual rate of return in a single year, because it is also possible that our good luck and excellent market conditions have contributed to the flames (and vice versa).
- The content of this site is the author’s personal opinions and is for reference only. I am not responsible for the correctness, opinions, and immediacy of the content and information of the article. Readers must make their own judgments.
- I shall not be liable for any damages or other legal liabilities for the direct or indirect losses caused by the readers’ direct or indirect reliance on and reference to the information on this site, or all the responsibilities arising therefrom, as a result of any investment behavior.