Keeping Track of Your Dividend
How did you track your dividend income ?
|<Image credit: play.google.com>|
But how about dividend income ? as income investor , do you have ways to keep track on your dividend received ?
Concept explained : What is CAGR & IRR by Investopedia
The compound annual growth rate, or CAGR for short, measures the return on an investment over a certain period of time. The internal rate of return, or IRR, also measures investment performance but is more flexible than CAGR.
The concept of CAGR is relatively straightforward and requires only three primary inputs: an investment’s beginning value, ending value, and the time period. Online tools, including Investopedia’s CAGR calculator, will spit out the CAGR when entering these three values.
The CAGR is superior to average returns because it considers the assumption that an investment is compounded over time. One limitation is that it assumes a smoothed return over the time period measured, only taking into account an initial and a final value when, in reality, an investment usually experiences short-term ups and downs. CAGR is also subject to manipulation as the variable for the time period is input by the person calculating it and is not part of the calculation itself. Consider the following investment:
Initial Value = 1,000
Final Value = 2,200
Time period (n) = 4[(Final Value) / (Initial Value)] ^ (1/n) - 1
In the above case, the CAGR is 21.7%
IRR is also a rate of return but is more flexible in that it considers multiple cash flows and periods. While CAGR simply uses the beginning and ending value, in reality cash inflows and outflows occur when it comes to investments. IRR can also be used in corporate finance when a project requires cash outflows upfront but then results in cash inflows as an investment pays off. Consider the following investment:
|Time period||Cash Flow|
In the above case, using the Excel function “IRR,” we obtain 36.4%.
Differences Between CAGR and IRR
The most important distinction is that CAGR is straightforward enough that it can be calculated by hand. In contrast, more complicated investments and projects, or those that have many different cash inflows and outflows, are best evaluated using IRR. To back into the IRR rate, a financial calculator, Excel, or portfolio accounting system is ideal. The example above used Excel to calculate the IRR but computation on a financial calculator is similar.
The Bottom Line
The CAGR helps frame an investments return over a certain period of time. It has its benefits, but there are definite limitations that investors need to be aware of. With multiple cash flows, the IRR approach is usually considered to be better than CAGR.
Keeping Track of Your Dividend
Tracking your dividend income is important to establish the return and yield of your investments, both in the short and long term. You can furthermore keep tabs on the growth of your dividends on a stock per stock basis, but also for your entire portfolio.
Most of investors are so IT savvy now , I think using APPs must be very common nowadays.
I have been tracking my dividend income since day one of my investing and find that it is a powerful way to see my investment strategy at work.
The method I use is super simple. An investor can get as complicated as they really want to get, however I have found simply tracking the income my entire portfolio throws off to be enough.
I am just using “ simple excel spreadsheet “ to keep track on my dividend received , quarterly , yearly and continuously .
< Example of dividend collected in 2002 >
Do you still remember the amount of dividend you received 10-15 years ago ?
Remember I blog about "Buying My First Stock " , yes , is " Magnum " , also , I have BJTOTO in my portfolio in earlier days ,,,is also a "Sin stocks " , some may look familiar with Public Bank ,Malaysia Cement and Malakof ( a private power plants in Malaysia ), Orient ( manufacturing and distribution of Honda car in Malaysia ) etc ... most of the counters gave quite good dividend yield.
< Dividend collected for certain counter, e.g Cambridge Reit , accumulative>
You may notice that Cambridge is one of my REIT collected early during GFC and it gave me YTD dividend of $214,202.33 . Dividend received from Cambridge has been in reducing trend in recent years . ( as I am divesting some industrial REITs since I am holding too much of Ind Reits in my portfolio ).
If you refer to my blog on ” My Portfolio “ , you may find that “ First Reit “ has became my biggest counter in term of value in % , follow by Accordia and Fraser Comm .
Below is the dividend update from First REIT :
<Disclaimer : above mentioned stocks just meant for illustration purpose and not as advice to buy or sell, please do your own due diligence ( DYODD ) prior investing in these counters >
What about you ? How do you track your dividend ? By using APPs or same as me , by using simple self created excel spreadsheet ?
Do let me know & share with us which apps are you using and if it is really "effective & easy to use " , I'm open to switch !
|<Image credit: aaronkatsman.com>|
Keeping track of all the dividend received and looking at the dividend income grow slowly is also a kind of motivation for me to invest .
"Do you know the only thing that gives me pleasure? It's to see my dividends coming in." John D. Rockefeller
May be records of dividend is much more easy to be verified than “ P&L “ from trading … :) sorry , didn't mean to ….. hahaha .
I am sure everyone will receive statement from CDP after end of the year … for me ,, it is about 35 pages of document , quite a big stack .