How Much Can You Make in Dividend Income? Free Spreadsheet (2024)

By David Carlson / Last updated: / 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.

1K Shares

How Much Can You Make in Dividend Income? Free Spreadsheet (1)

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:


How Much Can You Make in Dividend Income? Free Spreadsheet (2)


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.


How Much Can You Make in Dividend Income? Free Spreadsheet (3)


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!

How Much Can You Make in Dividend Income? Free Spreadsheet (4)

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

1K Shares

How Much Can You Make in Dividend Income? Free Spreadsheet (5)

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. How Much Can You Make in Dividend Income? Free Spreadsheet (6)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.

    • How Much Can You Make in Dividend Income? Free Spreadsheet (7)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. How Much Can You Make in Dividend Income? Free Spreadsheet (8)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.

    • How Much Can You Make in Dividend Income? Free Spreadsheet (9)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. How Much Can You Make in Dividend Income? Free Spreadsheet (10)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.

    • How Much Can You Make in Dividend Income? Free Spreadsheet (11)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. How Much Can You Make in Dividend Income? Free Spreadsheet (12)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.

    • How Much Can You Make in Dividend Income? Free Spreadsheet (13)David Carlson says

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

  5. How Much Can You Make in Dividend Income? Free Spreadsheet (14)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.

    • How Much Can You Make in Dividend Income? Free Spreadsheet (15)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!).

How Much Can You Make in Dividend Income? Free Spreadsheet (2024)

FAQs

How much can you make from dividends? ›

The average dividend yield on S&P 500 index companies that pay a dividend historically fluctuates somewhere between 2% and 5%, depending on market conditions. 7 In general, it pays to do your homework on stocks yielding more than 8% to find out what is truly going on with the company.

How much money do you need to make $1000 month in dividends? ›

The truth is that most investors won't have the money to generate $1,000 per month in dividends; not at first, anyway. Even if you find a market-beating series of investments that average 3% annual yield, you would still need $400,000 in up-front capital to hit your targets.

How do you calculate how much you will make in dividends? ›

To calculate a stock's dividend yield, all you need to do is divide the stock's annual dividend by its current share price. This value gives you the amount of money the stock's dividend pays out on every dollar invested in the stock.

How much money do you need to make $50000 a year off dividends? ›

If, for example, your portfolio gets to a value of $1.5 million, you could invest in a fund or multiple investments that yield an average of 3.3%. At that rate, you could generate $50,000 in annual dividends. With a lower portfolio balance of $1 million, you would need to target an average yield of 5%.

How much do I need to invest to make $1,000 a month? ›

To make $1,000 per month on T-bills, you would need to invest $240,000 at a 5% rate. This is a solid return — and probably one of the safest investments available today. But do you have $240,000 sitting around? That's the hard part.

How can I make $1000 a month passive income? ›

Passive Income: 7 Ways To Make an Extra $1,000 a Month
  1. Buy US Treasuries. U.S. Treasuries are still paying attractive yields on short-term investments. ...
  2. Rent Out Your Yard. ...
  3. Rent Out Your Car. ...
  4. Rental Real Estate. ...
  5. Publish an E-Book. ...
  6. Become an Affiliate. ...
  7. Sell an Online Course. ...
  8. Bottom Line.
6 days ago

How much can you make in dividends with $1 million dollars? ›

Stocks in the S&P 500 index currently yield about 1.5% on aggregate. That means, if you have $1 million invested in a mutual fund or exchange-traded fund that tracks the index, you could expect annual dividend income of about $15,000.

How much to make $500 a month in dividends? ›

To consistently earn $500 per month from dividends, you'll need to invest around $113,208 based on Realty Income's current dividend yield of 5.3%. This calculation is derived from dividing your annual dividend goal ($6,000) by the yield percentage.

How much does Warren Buffett make from Coca-Cola dividends? ›

A massive passive income stream

Berkshire currently owns 400 million shares of Coca-Cola. This means that on an annualized basis, Warren Buffett's company generates $736 million in dividend income from the beverage giant. That is a huge passive income stream that likely explains why Buffett isn't exiting the position.

How do you calculate dividends in Excel? ›

Suppose you are invested in a company that paid a total of $5 million in dividends last year and it has five million shares outstanding. In Microsoft Excel, enter "Dividends Per Share" in cell A1. Next, enter "=5000000/5000000" in cell B1; the dividends per share for this company is $1 per share.

How much cash do you need to live off dividends? ›

If you are considering a dividend-focused strategy, you should carefully assess your income needs and risk tolerance. For example, if you require an income of 100,000 per year and were looking at a dividend yield of 10%, you would need to invest 1,000,000.

How much can you make in dividends with $100 K? ›

How Much Can You Make in Dividends with $100K?
Portfolio Dividend YieldDividend Payments With $100K
1%$1,000
2%$2,000
3%$3,000
4%$4,000
6 more rows
Mar 23, 2024

How much do you need to make 3000 a month in dividends? ›

Let's consider an investment in dividend stocks for $3,000 a month. If the average dividend yield of your portfolio is 4%, you'd need a substantial investment to generate $3,000 per month. To be precise, you'd need an investment of $900,000.

How much invested to make $1,000 a year in dividends? ›

And if you pick companies with attractive yields, the income can really add up as you grow your portfolio. For example, investing $15,000 evenly across these five high-quality, high-yielding dividend stocks would, at their current payout rates, generate almost $1,000 of annual dividend income.

How to make $5,000 a month in dividends? ›

To generate $5,000 per month in dividends, you would need a portfolio value of approximately $1 million invested in stocks with an average dividend yield of 5%. For example, Johnson & Johnson stock currently yields 2.7% annually. $1 million invested would generate about $27,000 per year or $2,250 per month.

How much money do I need to invest to make $3000 a month in dividends? ›

If you were to invest in a company offering a 4% annual dividend yield, you would need to invest about $900,000 to generate a monthly income of $3000. While this might seem like a hefty sum, remember that this investment isn't just generating income—it's also likely to appreciate over time.

Top Articles
Latest Posts
Article information

Author: Aron Pacocha

Last Updated:

Views: 6432

Rating: 4.8 / 5 (68 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Aron Pacocha

Birthday: 1999-08-12

Address: 3808 Moen Corner, Gorczanyport, FL 67364-2074

Phone: +393457723392

Job: Retail Consultant

Hobby: Jewelry making, Cooking, Gaming, Reading, Juggling, Cabaret, Origami

Introduction: My name is Aron Pacocha, I am a happy, tasty, innocent, proud, talented, courageous, magnificent person who loves writing and wants to share my knowledge and understanding with you.