• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Start Here
  • Work with David
  • Our Services
  • Contact
Young Adult Money

Make more. Save more. Live better.

  • Blog
  • Credit Cards
    • Rewards
    • Cash Back
    • Travel
    • Airlines
    • Hotels
    • Balance Transfer
    • Student
    • Business
  • FREE Budget Spreadsheet
  • FREE Student Loan Spreadsheet
This Just In... Check out the latest travel rewards credit card offers

How Much Can You Make in Dividend Income? This Spreadsheet Will Show You

By David Carlson / Last updated: January 19, 2024 / Budgeting, Download, Investing, Make Money, Personal Finance, Save Money

We may receive compensation from companies mentioned within this post via affiliate links. Read our full advertiser disclosure. Opinions, reviews, analyses & recommendations are the author’s alone, and have not been reviewed, endorsed or approved by any of these entities.
Pin1K
Share2
Tweet
Email
Buffer27
Share
1K Shares


How Much Can You Make in Dividend Income? This Spreadsheet Will Show You

A popular topic in personal finance is passive income.

Income that doesn’t require you to trade your time for money is “the dream” for many people.

There are many different forms of passive income, but the ultimate passive income is dividend income.

Dividend income comes from owning dividend-paying stocks. Not every company pays dividends. If a company is focused 100% on growth, they are going to use all their earnings to continue to grow their business.

With that being said there are many large companies that are focused on growth that pay a dividend. In fact it would almost be silly for a publicly traded company to not have a growth strategy.

Many of the large blue chip companies pay dividends, though their dividend yield (Amount paid out in dividends annually divided by current stock price) can vary. For example, Best Buy has a relatively high dividend yield of 4.18%, while Visa has a modest 0.80% dividend yield.

Even if you have other financial priorities that take precedence, learning and being aware of the opportunities that come with dividend income can motivate people to save more money, pay off debt faster, and make more money so that they can take advantage of all the benefits that come from dividend income.

With that in mind, let’s get to the real question here: how much can you make in dividend income?

 

How Much Can You Make in Dividend Income?

 
The first thing I need to say before answering this question is this: it’s not easy to make a sizable amount of dividend income. If it was easy no one would work and everyone would simply live off of their passive dividend income.

Using the spreadsheet I created, let’s look at what you would be able to make annually from dividends if you invested $5,000 in 3M stocks:

 
3M Dividend Analysis Tool

 

Join our Community to Receive your FREE Dividend Income Spreadsheet

 
Okay so you’d only make $123 each year. Now that may not feel like much, but remember it’s also reasonable to expect 3M’s stock to appreciate over time. Also, don’t forget how great dividend income is: you are getting $123 by simply owning $5,000 worth of 3M stock! No effort required.

Let’s take a look at a higher investment amount: $100,000.

 
3M Dividend Analysis Tool 100k

 
Nearly $2,500 a year – not too bad! You can see why dividend income is so attractive, especially to those looking to retire early or who don’t want to spend down their assets in retirement.

Quick math shows that owning $1 million of 3M stock would yield $25,000 a year in entirely passive income. Do you have $2 million to invest? double it up to $50,000 a year.

I don’t know about you, but this sort of scenario analysis is incredibly motivating to me.

I spend most of my free time working on side hustles to increase my income, and while paying off debt is the primary goal right now, long-term I would love to regularly funnel “extra” side hustle income into dividend-paying stocks.

If you are an entrepreneur or want to be an entrepreneur, dividend income just might give you the motivation needed to put in the long hours and hard work to build your business. After all, if you are able to sell for a couple million dollars – or more – you very well could live off of passive dividend income the rest of your life.

 

Want to try out some scenarios in the dividend income tool?

Get the spreadsheet below and find out how much you can make in dividend income with your current and future investments.

 

Join our Community to Receive your FREE Dividend Income Spreadsheet

 

Check out some of our favorite personal finance resources:

Are you getting the best credit card rewards? Check out the top cash back credit card offers (updated daily)

Make extra money: 15 ways to make money from your computer

  • Get our FREE Automated Budget Spreadsheet and our Student Loan Spreadsheet

Get the First Chapter Free!

Student Loan Solution Cover - 3D

Join our online community and get the first chapter of the book Student Loan Solution absolutely FREE!

Pin1K
Share2
Tweet
Email
Buffer27
Share
1K Shares

David Carlson

David Carlson is the founder of Young Adult Money. He is a nationally recognized speaker and the author of Student Loan Solution (2019) and Hustle Away Debt (2016). His opinions have been featured on such media outlets as The New York Times, The Washington Post, Cheddar, NBC's KARE11, and more.
Connect:

Comments Policy

Comments, responses, and other user-generated content is not provided or commissioned by this site or our advertisers. Responses have not been reviewed, approved, or otherwise endorsed by this website or its advertisers. It is not the responsibility of advertisers or this website to ensure that all comments and/or questions are answered. With all that being said, please comment away!

Reader Interactions

Comments

  1. Josh says

    I have just become more serious about dividend investing in the last year or two. Previously I was more focused on the actual share price & selling when it raised x%.

    If I buy direct company stock, I make sure it pays a dividend. I have even added to my portfolio dividend mutual funds and ETFs.

    I think the spreadsheet is a huge help because brokerages only tend to focus on the dividend yield & the hypothetical return of a $10,000 investment of up to the past 10 years which might not include reinvested dividends in the calculations.

    • David Carlson says

      Very cool to hear, Josh. I think right now there is a huge number of people who are really focused on just getting started investing (i.e. contributing to a 401k) and paying down debt, but long-term I think looking at dividend income can be really motivating. I’ve found that even having a small amount of dividend income can motivate me to try to earn more.

  2. John @ Frugal Rules says

    Cool spreadsheet! I think dividend income is a great way to bring in some additional income/another income stream. Like Josh said, many brokerages only provide the tools to see things like yield and return on higher amounts. While still helpful, it doesn’t serve a lot of investors – especially those starting out.

    We do some dividend investing, and just have it reinvested into the ETFs we’re using, but will likely rely on dividend income in later years.

    • David Carlson says

      Good to hear about the dividend investing, John. I think reinvesting dividends is the way to go, and I do the same thing with the dividends I receive from the company stock I own. Ideally you can push off using or living on dividend income as long as possible, but I can also see the appeal of starting to use it early on. After all, it feels pretty great to know the money you just spent was from completely passive income!

  3. Andrew@LivingRichCheaply says

    I have a few dividend paying stocks and I can see why it’s enticing to have consistent passive income. There are also a lot of blogs that focus on dividend growth stock investing. I’m mostly in index funds but for the individual stocks that I do invest in, I’m more focused on growth rather than having them pay dividends as those companies are generally more stable. Dividends are cool but I think I’d prefer a company that has more growth and appreciation.

    • David Carlson says

      “Dividends are cool” – can’t disagree with that! I also am focused on growth stocks at this time, but I think it would be great to have consistent dividend income down the road to live off of.

  4. Michael says

    Dividend is the easiest form of passive income one can think of. Honestly, I don’t know of any other passive income that take less work.

    To insulate yourself from the misfortune of a single company stock, you could invest in a dividend ETF, for example, SCHD, that seeks to track the performance of the U.S. Dow Jones 100 Dividend Index. With an expense ratio of 0.07%, it makes dividend investing super inexpensive and easy.

    I am long SCHD and plan to accumulate slowly and steadily.

    • David Carlson says

      Great tip about SCHD. A great way to go if you want to stay diversified.

  5. Manuel says

    I also love dividend payments. They always feel like “you have something secure from your stocks”. Anyway, I always try to reinvest the dividends directly. This helps you over the long run to grow even more of them and to live a richer life when you retire. I like stocks that reinvest the dividends for you directly.

    • David Carlson says

      Reinvesting dividends is a great idea for those who are looking to continue to bolster their holdings. Especially considering how long it can take to build up your dividend income, reinvesting is the way to go until you really need to start using the dividend income for daily life (i.e. in retirement!).

Primary Sidebar

Credit Cards

  • Best Travel Rewards Cards
  • Best Balance Transfer Cards
  • Best Cash Back Credit Cards
  • Best Business And Side Hustle Credit Cards
  • Best Student Credit Cards

Start a Blog:

How to Start a Blog that Makes Money
 

Top Posts

  • 15 Ways You Can Make Money From Your Computer Right Now
  • When You Should and Shouldn’t Refinance Student Loans
  • How Much Money You Will Need to Make $1,000 in Dividends

Free Spreadsheets & Downloads

  • Free Automated Budget Spreadsheet
  • Student Loan Repayment Spreadsheet
  • The Ultimate Personal Finance Checklist
  • 401k Spreadsheet to Analyze your Options
  • Wedding Budget Spreadsheet
  • 52 Week Money Challenge Spreadsheet and Printable

First Chapter Free!

Join our online community and receive the first chapter of Student Loan Solution absolutely FREE.

If you don't see the email in your inbox, please check your spam folder.

Connect:

Categories:

Search:

Get the New Book!

Student Loan Solution: 5 Steps to Take Control of Your Student Loans and Financial Life is available on Amazon by clicking here, or by clicking on the graphic below.

Make more. Save more. Live better.

Site Directory:

  • About
  • Contact
  • Advertise
  • Recommendations
  • Finance Tools
  • Credit Cards
  • Insurance
  • Banking
  • Investing

Disclaimer | Privacy Policy

Feedback? Questions?
Contact us and let us know what you think.

Connect:

Search This Site:

Copyright © 2012–2024 Young Adult Money, LLC / All Rights Reserved
Designed by LizTheresa.com / Developed by Nuts and Bolts Media

Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Statistics

Marketing

Features
Always active

Always active
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}
Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}