Skip to content
The title slide and first slides of the Dividend Reinvestment Calculator template

Dividend Reinvestment Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

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.

Useful for

  • Explaining reinvestment to a new investor
  • Comparing a payout plan against a reinvestment plan
  • Testing how a different yield or price growth changes the gap

What's included

  • 4 tabs: Inputs, Growth, Chart, How to use
  • Inputs: a table
  • Growth: a table
  • Chart: a dashboard with 4 summary figures
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Inputs tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What does dividend reinvestment do?

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.

Does this sheet predict returns?

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.

Why is the gap larger in later years?

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.

  • #financial-calculator
  • #dividend-reinvestment-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 29

Also in Finance

All finance templates
Get this template

Preparing your template…