
Annual Report
Docs + Word6 pages
FeaturedFree
Reinvesting dividends means each payout buys more shares, which pay more dividends the next time. This calculator lets you watch that loop. On the Inputs tab you enter the shares you hold, the price, the dividend yield, the yearly price growth and the number of years. The sheet returns the starting value, the dividends in the first year, the shares at the end and the final value under two choices: reinvest every payout, or take it as cash and leave it uninvested.
The Growth tab lists each year up to thirty, with shares, the value of the reinvested holding, the cash collected and the gain from reinvesting. The Chart tab plots both paths at five-year steps. The model keeps the yield constant as a share of price, so dividends rise as the price rises, and it leaves out taxes and fees. Treat the output as an illustration of the idea, not a forecast.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Inputs tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
It uses each dividend payment to buy more shares of the same holding. The extra shares earn dividends too, so the holding can grow faster than one where the dividends are taken as cash.
No. It applies the yield and price growth you enter to every year. Real prices and dividends change, and taxes and fees reduce the result.
The extra shares from each reinvestment also earn dividends, so the effect builds on itself. It starts small and grows the longer the money stays invested.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free