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)

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.


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 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 can you realistically make with 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 much money do you need to make $50000 a year off dividends? ›

And the higher that balance gets, the less of a dividend yield you'll need to generate some significant income. 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.

How to 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 to make $1,000 a year in dividends? ›

Want to Gain $1,000 in Annual-Dividend Income? Invest $11,765 in These Outstanding High-Yield Dividend Stocks | The Motley Fool.

Can you live off of dividend income? ›

Living off dividends is a financial strategy that appeals to those aiming for a reliable income stream without tapping into their investment principal. This approach has intrigued many investors, from early-career individuals to those nearing retirement.

How much money do I need to invest to make $4000 a month? ›

Making $4,000 a month based on your investments alone is not a small feat. For example, if you have an investment or combination of investments with a 9.5% yield, you would have to invest $500,000 or more potentially. This is a high amount, but could almost guarantee you a $4,000 monthly dividend income.

How much do I need to invest to make $1000 a month? ›

A stock portfolio focused on dividends can generate $1,000 per month or more in perpetual passive income, Mircea Iosif wrote on Medium. “For example, at a 4% dividend yield, you would need a portfolio worth $300,000.

How much do I need to invest to get 500 a month in dividends? ›

That usually comes in quarterly, semi-annual or annual payments. Shares of public companies that split profits with shareholders by paying cash dividends yield between 2% and 6% a year. With that in mind, putting $250,000 into low-yielding dividend stocks or $83,333 into high-yielding shares will get your $500 a month.

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

The payments are considered passive income since you can collect the dividends whether you trade the stock actively or not. 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%.

How to make 3k a month in dividends? ›

A well-constructed dividend portfolio could potentially yield anywhere from 2% to 8% per year. This means that to earn $3,000 monthly from dividend stocks, the required initial investment could range from $450,000 to $1.8 million, depending on the yield.

How much do I need to invest to make 400 a month in dividends? ›

That's right; you save over $30,000 if you want to create $400 per month in passive income. Furthermore, this could be cash set aside in your TFSA, meaning it would be all tax free, with plenty left over for other investments.

How much dividends does 100K make? ›

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 do you make $2000 in dividends? ›

Three high-yielding stocks that can help you generate some decent dividend income right now are Pfizer (NYSE: PFE), Bank of Nova Scotia (NYSE: BNS), and AT&T (NYSE: T). By investing $30,000 into these three stocks, you can expect to collect about $2,000 per year in dividends.

How much money in dividends to make $5000 a month? ›

Invest in Dividend Stocks

The payments are considered passive income since you can collect the dividends whether you trade the stock actively or not. 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%.

How much to invest to get $3,000 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.

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

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 to make $500 a month in dividends? ›

Dividend-paying Stocks

Shares of public companies that split profits with shareholders by paying cash dividends yield between 2% and 6% a year. With that in mind, putting $250,000 into low-yielding dividend stocks or $83,333 into high-yielding shares will get your $500 a month.

Top Articles
Latest Posts
Article information

Author: Rev. Leonie Wyman

Last Updated:

Views: 5463

Rating: 4.9 / 5 (79 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Rev. Leonie Wyman

Birthday: 1993-07-01

Address: Suite 763 6272 Lang Bypass, New Xochitlport, VT 72704-3308

Phone: +22014484519944

Job: Banking Officer

Hobby: Sailing, Gaming, Basketball, Calligraphy, Mycology, Astronomy, Juggling

Introduction: My name is Rev. Leonie Wyman, I am a colorful, tasty, splendid, fair, witty, gorgeous, splendid person who loves writing and wants to share my knowledge and understanding with you.