• Home
  • Saving Money
  • Dividend Investing
  • Mindset
  • About
    • About
    • Blogging
  • Disclosure
  • Contact
Fresh Dividends, Roadmap to monthly passive income

Fresh Dividends

Home » Dividend Investing » Simple Dividend Calculator Spreadsheet

Last updated on December 29, 2020 ·

Simple Dividend Calculator Spreadsheet

A simple divided calculator spreadsheet does the heavy lifting to figure out how many you need to reach your dividend goals

As part of building your monthly dividend portfolio or general dividend investing goals, you need to calculate how many shares you need. While the math is relatively straightforward, I created a quick dividend calculator spreadsheet to help me look at multiple goals at one time.

By simply entering the stock symbol and quarterly dividend payment I can see how many shares I need to create one new reinvested share per year or per quarter. Or if I want to target dividend amounts per year or quarter, the spreadsheet also calculates that for me.

Quarterly dividend payments are the most common approach. I also set up this spreadsheet to be flexible to allow for monthly, semiannual, or annual dividend payments. Change the number of payments per year to account for the different payment cycles.

Partial view of the dividend reinvestment calculator

What is included in the simple dividend calculator spreadsheet

Depending on your dividend investing goals, you will need to calculate different targets. The spreadsheet I created estimates the number of shares (rounded up to the nearest full share) for:

  • one share per year (approximately a quarter share per quarter)
  • one share per quarter
  • $100 per year in dividends
  • $250 per year in dividends
  • $500 per year in dividends
  • $750 per year in dividends
  • $1,000 per year in dividends
  • $25 per dividend payment
  • $75 per dividend payment
  • $100 per dividend payment
  • $250 per dividend payment
  • $500 per dividend payment

The shares calculated per dividend payment is useful for creating monthly dividend portfolios. This shows you want you’ll receive in the month the dividend pays out. If you purchase 3 stocks with payments that don’t overlap months, you’ll receive money each month of the year.

I also created the share per year calculation to help figure out the investment needed to (approximately) reach one new share per year with reinvestment. In my early mistakes with dividend investing, I didn’t realize partial shares are sold when an account is transferred to a new brokerage company. If you need ideas for stocks you can also check out the Dividend Aristocrats Spreadsheet.

Simple Dividend Calculator Spreadsheet screenshot
Get the spreadsheet

Wrapping up. I’d love feedback on the simple dividend spreadsheet.

Have you had a chance to take a look? I’d love feedback. What additional would you like to calculate as part of figuring out how many shares you need to buy to reach a goal?

Pin for later

Simple Dividend Calculator Spreadsheet: Estimate your monthly income and reinvestment shares
Pin111
Share
Tweet
111 Shares

About Cara

Hello and welcome. My name is Cara and I'm on a mission to help you chart your roadmap to monthly dividend income. Setting and achieving passive income goals is a particular passion of mine. Instead of continuing to procrastinate, jump back in the driver's seat. Let's do this together!

Primary Sidebar

Hello and welcome

Hello and welcome. My name is Cara and I'm on a mission to help you chart your roadmap to monthly dividend income. Setting and achieving passive income goals is a particular passion of mine. Instead of continuing to procrastinate, jump back in the driver's seat. Let's do this together! Read More…

Let’s Connect On Social

  • Instagram
  • Pinterest
  • Twitter

Recently

  • How to make $2000 a month in dividends
  • How to make $1000 a month in dividends
  • How to make $500 a month in dividends
  • No more excuses. 4 reasons to clean your messy house today
  • Do you need a 12 month emergency fund?
  • Terms and Conditions
  • Privacy Policy
  • Disclosure
  • Contact

Copyright © 2020 Cara Peterson
As an Amazon Associate I earn from qualifying purchases.