![]() I have one dividend stocks that I DRIP (Sunlife Financial, SLF.TO). To DRIP or not to DRIP that’s a matter of personal preference for any dividend investor. In addition, when you purchase more shares you can update the numbers here. If you have dividend re-investment plan (or DRIPs) you can change the number of shares that you own. This is self-explanatory and you can input the number of shares that you own of your dividend company. You do not need to input this as the calculation is built into the spreadsheet. The percentage (shown as an increase or decrease, or a positive or negative number) is basically the capital gain or loss divided by the Adjusted Cost Base (ACB). Again, you don’t need to input this, as it is calculated from the dividend spreadsheet automatically. ![]() The capital gain or loss is calculated by subtracting book value (what you have purchased the dividend stock at) from the market value (what the dividend stock is currently priced at on the market). You will want this to be as low as possible □ Capital Gain/ Loss It is the price per share that you bought the stock at. You don’t need to input this, as it is calculated from the dividend spreadsheet. The adjusted cost base is the book value divided by the number of shares that you own. The book value is the actual cost of how much you spent buying these shares including commissions. This includes adding via dripped shares or buy additional purchases of equities. Book Valueīook value will be inputted when you first buy your dividend stock and will be adjusted every time you add to your dividend stock. However, this spreadsheet is in Excel instead. Google Docs has an option where you can input a Google Finance command and it pulls the data so you don’t have to update manually. This number is the market price, or what it is currently sold at on the stock market. PriceĮvery time you want to update your dividend portfolio, you will need to update this manually with the current market price of the dividend stock. It is automatically calculated using the spreadsheet by multiplying the current price by the number of shares owned. Market Valueįor this, you don’t have to input anything into the spreadsheet. Here you can input the Ticker Symbol of the dividend stock that you have purchased in your portfolio. ![]() Here’s an explanation of each column in your Excel spreadsheet that you have just downloaded. If you don’t like subscribing to genymoney.ca you can always unsubscribe, but I do hope that you won’t □ Once you receive it in your email, press the orange button to download it. If you haven’t already downloaded this dividend yield spreadsheet, you can sign up here. Free Dividend Portfolio Tracker Step-by-Step Guide Some brokerages like Scotia iTrade have a dividend tracker (forward yield) built into their dashboard and interface, while others, like Questrade don’t. I personally use a similar one to keep track of my dividends with Google Sheets. Thanks to my investing and Excel spreadsheet savvy husband, he helped create this spreadsheet for me. Here’s how to use a dividend yield spreadsheet to keep track of your dividends which we can’t forget to cultivate and weed, just like your vegetable garden. I personally update my dividend yield spreadsheet on a monthly basis and you can check my recent forward dividend income updates here if you’re interested. Once a company cuts their dividends, this is usually bad news for investors and also for the company. Similar to tracking your net worth or tracking your spending, tracking your dividend yield is a great way to look at how much more in income producing assets you are accumulating.Īlso, unless you are an index investor, it is good practice to review which companies are cutting or increasing dividends. Wealthica: The Personal Capital of Canadaįirst, let me explain why a dividend tracker spreadsheet is a good idea for any avid dividend investor.Free Dividend Portfolio Tracker Step-by-Step Guide.
0 Comments
Leave a Reply. |