I have never really thought about what my 10 year plan looks like. Considering I make my decisions based on the long term implications, this is rather odd. It took me over three years to find the right house. I went through 3 or 4 realtors and even then it took me almost a year to find a house I wanted to buy. I didn’t want to go to college, but went and focused heavily on my studies. It was my job after all, I probably spent around 40-50 hours a week studying when I was not in class. I wanted to do well, so that I could get a good job, which I believed I would need for the next 40 years.
When I started investing, the plan was to get rich. Which as a plan lacks detail and is lazy, but I got caught up in the market euphoria and dropped the ball for a few years. Once I began dividend growth investing more than two years ago, I began to plan somewhat. I created a spreadsheet that mapped out expected dividends over the next 30 years with a yearly cash contribution I felt was sustainable (given the randomness of life).
Until recently I have not sat down and asked myself the question:
Where do you want to go?
To do this day, I honestly can’t answer that. I don’t know. I think I would like to have enough side income to take a position that allows me to be outside more. I say this, but I am rather risk averse and don’t make many changes. This may be many years away, in the mean time, I created a spreadsheet that helps me map out my expected future income.
Lets start with an example, suppose you start with the following parameters:
|Yearly Dividends||1000||Dividends paid in a 12 month period.|
|Yield||3.5%||Average yield of your portfolio.|
|Dividend Growth||8%||Overall dividend growth rate.|
Simplifying assumptions I use in the formula:
- Reinvest all dividends at the end of year at average rate.
- Forward dividends are adjusted at the end of the year.
- Additional funds are invested once per year when dividends are, assuming the “Average Portfolio Yield”.
After year one, reinvesting :
= (Current Yearly Dividends + Dividends received * avg. rate)*(1+Dividend growth rate)
= (1000 + 35*.035)*(1+.08)
= (1000 + 1.23)* 1.08
After one year, your dividends would have gone from$ 1000 to $1081.33. Similarly, for year two, you would use $1081.33 as your “Current Yearly Dividends” and compute the same formula.
Suppose you are adding $1000 to your investment at the average portfolio yield or 3.5%. This would add an additional $35 to your income. This value would be added to what was computed to simulate the investment at the beginning of the next year. Your year two starting 12 month dividends would be $1116.33 after investing an additional $1000 earned in year one.
Do you recognize this formula? With the exception of adding additional funds, this formula is for annual compounding.
I made some basic assumptions that simplifies the calculation:
- It doesn’t take into account reinvesting dividends as soon as your able.
- It doesn’t take new money added to your account throughout the year.
Both of these issues will affects your overall estimates in a given year. Suppose you earned $10000 dividends/year and we reinvest quarterly vs once at the end of the year.
For annual compounding, your 12 month forward dividends will be 10350 after one year. If no additional capital, but the dividend income is reinvested.
Quarterly compounding will do the following each quarter. Note, the “12 Month FWD Dividends” column is what your income will be at the end of the quarter.
|Quarter||Quarterly Dividends||12 month FWD Dividends|
At the end, the difference is small ($4.66), however it is something to remember when compounding annually vs quarterly. For my purposes, annual compounding will provide a floor to my dividend income estimates, assuming I am able to make the additional assumptions (extra capital, average growth rate and after yield of 3.5%) reality.
My 10 year growth estimates
Here is the first 10 years of projected dividends of my portfolio assuming 8% growth, 3.5% average yield and 10200 additional yearly deposits.
|Expected Year||Date Passed||Milestone|
In 10 years from my last milestone (6/1/2014), I want to have $18,328.29 additional yearly income. I think this is achievable, at least for now. I have included a longer version of this chart on my Progress page.
That is were I hope to be heading. The market is fairly interesting right now. There are several quality companies approaching my buy targets and with my recent purchases of XOM and CVX, I am patiently waiting to add additional shares of other companies I expressed interest in purchasing a week ago.
What do you think? Do my estimates seem crazy or mis-calculated?
Disclaimer: Long CVX, XOM.