Are you looking to invest your money and earn dividend payments? If so, then download our free dividend tracker spreadsheet. This spreadsheet will help you keep track of all the dividend payments that you receive, making it easier for you to invest smarter. We have also included a tutorial on how to use the spreadsheet, so you can get started immediately!
What is a dividend, and what are its benefits for investors?
Dividends are payments that a company makes to its shareholders, and they are typically paid out quarterly (every three months). As a result, dividends can provide investors with a steady stream of income, which is especially helpful in retirement.
In addition, dividend payments can be reinvested back into the company (known as dividend reinvestment plans, or DRIPs), which can help you grow your investment over time.
In fact, historical data shows that the annual S&P500 return without dividends reinvested is only 6.57%, whereas when the dividends are reinvested, the return is 10.7%.
Why use the dividend tracker spreadsheet?
You might want to use our dividend tracker spreadsheet for a few reasons. First, it can help you keep track of your dividend payments so that you know how much income you are earning from your investments. This is essential information to have when making future investment decisions.
Second, the spreadsheet can also help you track your dividend reinvestment plans (DRIPs). This information can help you understand how your investments are growing over time.
Finally, the dividend tracker spreadsheet can also help you keep track of dividend payments from different companies. This can be helpful if you are diversifying your investment portfolio.
Click here to download the free dividend tracker spreadsheet!
How to use the dividend tracker spreadsheet?
Click on this link to access it via drive and then download it to Excel or keep it on Google Sheets. After that, all you need to do is create a Wisesheets account which you can get for free here, and then download the Wisesheets add-in on Excel or Google Sheets and log in with your account.
Once you have completed these steps, you can change the tickers in cells B2 to B8 and the account type, number of shares, and average cost. You will notice how all the other columns will automatically calculate for you.
If you run out of rows, you can add more and simply drag the formulas for the other columns and change the range of tickers in cell F2.
You can also change the ticker in cell B10 so you can see the previous dividend paid by the company of your choice.
Feel free to make any other additional changes you'd like, such as adding graphs, changing the formatting, etc. it's all up to you!
The different types of dividends, and how can they impact your portfolio?
Dividends can provide investors with a valuable source of income, but it's important to understand the different types of dividend payments before investing. For example, some companies may pay out dividends every quarter, while others may pay out dividends annually.
Dividend payments are not required for most stocks except REITs. Therefore do not be surprised if one of your stocks stops paying dividends or reduces its dividend payments.
It's also important to understand how dividend payments can be reinvested into the company (known as dividend reinvestment plans, or DRIPs). So again, this information can help make future investment decisions.
How to use the dividend tracker to create a long-term investing plan?
The dividend tracker spreadsheet can help you create a long-term investing plan by tracking your dividend payments and reinvestments. In addition, this information can help you understand how your investments are growing over time.
Additionally, the dividend tracker can help you track dividend payments from different companies. This can help assess dividend-paying stocks.
Click here to download the free dividend tracker spreadsheet!
Conclusion
Dividends can provide investors with a valuable source of income, but it's important to understand the different types of dividend payments and how they can impact your portfolio. The dividend tracker spreadsheet can help you track your dividend payments and reinvestments, making it easier for you to create a long-term investing plan.
Want to learn more about dividend investing? Check out this article on the dividend discount model.
Do you have any questions about dividend investing? Leave a comment below, and we'll be happy to help!
3 Responses
I've learn a few good stuff here. Definitely worth bookmarking for revisiting. I surprise how so much attempt you place to create this type of wonderful informative site.
Glad you like it.
the "ttm" causes the spreadsheet to give you the yield for the trailing 12 months. If you're trying to calculate the year to date return for a dividends for a stock can you easily get this somehow?