These are my two favorite templates that I have been using over the years to plan my journey towards early retirement and to keep track on my dividend portfolio.

If you would like to use them as well, then just copy them to your own Google Drive or download them into Excel.

Dividend investment calculator with dividend reinvestment

This is a investment calculator with dividend reinvestment which allows you to calculate the time it takes to become financially independent using a dividend growth and reinvestment strategy.

It includes:

  • the impact of dividend withholding tax
  • yearly dividend growth as a variable
  • different variables for easy simulation

Want your own copy of this template?

Copy the stock dividend reinvestment calculator

dividend reinvestment calculator

Dividend Portfolio Tracker

This is my dividend portfolio tracker which allows you to:

  • Log every transaction: buy / sell / dividend / cash deposits
  • Analyze your dividend portfolio

Read the full instructions here.

Let me know if you find any errors in one of the templates.

Enjoy it! Ah, and remember ๐Ÿ‘‡

Sharing is Caring ๐Ÿ˜Ž

5 1 vote
Article Rating
Notify of
Newest Most Voted
Inline Feedbacks
View all comments
1 year ago

Hi there, thanks for the interesting read and templates. I was trying the dividend portfolio tracker. Great work! I have a few questions. 1) How do I change the upper value on your speedometer from 4000? 2) The doughnut charts do not seem to add up the sector entries (financials, materials etc.). Every sector entry appears on the charts separately. In other words, if I enter three bank stocks and identify them as financials from the pick list, there will be three separate slices on the chart labeled financials.

Reply to  European DGI
1 year ago

Thanks for your prompt reply. Perhaps because I am trying to do this on an iPad, I donโ€™t have these same options. If I tap on the chart, I get an item on the screen that includes โ€œedit chartโ€. However the only edit option include changing the title, colour, type of chart, and legend. Sorry, I am not that familiar with g-sheets. I am away from my desktop for a few weeks, but may have better luck from there.
By the way, I really like the graphics you used in the Q2 podcast! Very clear and easy to digest. Thanks!

Reply to  Michael
1 year ago

Excellent! Back home now so was able to edit per your instructions on my iMac. I really appreciate all you are doing. Cheers.

1 year ago

Hi there! These are great tools, thank you for having put together and shared them! While using the Dividend Portfolio Tracker, I have noted the following: – sheet “Dividend Portfolio”: column J should show the current value in EUR but it actually calculates it based on the original currency (e.g. Novartis in CHF), as it takes into account the price in local currency and the nr of shares. Same thing for the Dividend (column K), i.e. it seems to be showed in the original currency. Would you recommend to use the same formula as in the sheet Transactions? – the… Read more »

Reply to  DDGI
1 year ago

sorry, I am adding a new point that I just spotted:

– sheet “Transactions”:
unless I am mistaken, stocks that are in the portfolio currency (EUR in my case), do not get their cash flow in EUR value unless I force one of the cells that are not supposed to be touched (e.g. column F, by putting 1 as exch.rate or column, J by putting the formula Gxy * Hxy)
Am I doing anything wrong?

thanks again

Leonardo dos Santos
Leonardo dos Santos
1 year ago

Hello Great Work in both spreadsheets!!!!! Just one question: in spreadsheet “Dividend Portfolio” column H – Cost Basis, why are you considering the sum amount of dividends in sheet Transactions – Column J:J as Total Cost for the stock? Does the formula shoudnt be adjusted to consider just values for transactions that were setup as “Buy” and “sell” types?

starting dividend investor
starting dividend investor
3 months ago


I cannot download or open anything om the website. I already subscribes so when I, for example want to download this template, I get an subribe option but no download option. When I click the subscribe option i get the notification that I already subscribed. So basically I subscribed but cant to anything on you’re website. Can you help me out? Besides this nice website and also a nice podcast that you are making ๐Ÿ™‚

European DGI
European DGI(@europeandgi)
Reply to  starting dividend investor
3 months ago

Hi Tom,

I’ve shared the link to you via email. Not sure why it happened, but you should have access now. Apologies for the inconvenience!