Excel Dividend Calculator

Download the Excel Dividend Calculator Here.

How to Use the MarketBeat Excel Dividend Calculator

Dividends are a simple way for investors to watch their portfolio grow. But once you’ve selected the right dividend stocks for your portfolio, it’s important to track them. This will let you understand how they are performing right now and how they will perform in the future based on the variables you select. Fortunately, there are analytical tools available to make calculating your projected dividend yield very simple. Our latest tool is the MarketBeat Excel Dividend Calculator. This requires you to provide some basic information which is readily available on equity’s individual stock page on MarketBeat.com. It will also require some assumptions on your part. Some of these you may be able to answer by looking at a company’s most recent earnings report.

Step 1: Select Your Investment Type

You can calculate dividend growth for individual stocks you own, or you can calculate a stock’s dividend yield as a percentage of the value of your entire portfolio. While this includes stocks that don’t pay dividends, calculating dividends this way gives you a percentage that tells you how well the dividend income of a given stock contributes to the value of your entire portfolio.

Step 2: Provide Information About the Particular Stock

Is it taxable? Select Yes or No. What is the distribution frequency? Many stocks pay a quarterly dividend. The tool also lets you select annual, semi-annual or monthly options (Note: The dividend calculator does not factor in special dividends since by their very nature they are irregular.). The other field lets you indicate if you plan on reinvesting the dividends as part of a dividend reinvestment plan (DRIP). Not all stocks do, but a DRIP is one of the easiest ways to enjoy the benefits of compounding.

Step 3: Provide Information About Your Investment Intentions

This includes three fields. First what is your starting balance? Next, how much, if anything, do you plan on contributing to the stock on an annual basis? This does notinclude reinvested dividends. The third field gives you the opportunity to select a length of time to measure. For example, if you are planning on retiring in 10 years, you may only want to see where the stock (or your portfolio) will be in 10 years. If you plan on this stock being a “forever” stock, you may choose a longer time horizon.

Step 4: Provide Information About the Stock’s Dividend

Here’s where you may have to make some assumptions. The last two fields, however, are essential to the accuracy of the calculator. The first is the average annual dividend yield for a particular stock. Because companies are usually very proud of their ability to issue dividends to their shareholders, this information can usually be found on a company’s web site under “Investor Relations” or a similar title. The last field is “Expected Increase % (per year)”. MarketBeat.com will show you a company’s recent dividend history. You may see, for example, that a companyhas increased their dividend by 0.25% every year for the past five years. Is that a guarantee they will do that again? No, but it does give you a reasonable assumption. Once a company starts not only issuing dividends, but increasing them,they will usually make continuing that pattern a priority. If they don’t, it could be an indication that the company is having financial problems.

The final word about using the dividend calculator

It may go without saying, but the results of the calculator are only as good as the data that you provide. Therefore you should be as accurate as possible with the information you provide. If you’re not going to be adding money to the account, don’t say you are. If you are not planning on reinvesting the dividend, don’t indicatethat you are. If the dividend has not changed in several years, don’t assume the company will raise it in the future. With that said, things change. Assumptions you make may change which means youmay have to revisit the calculator to see whether an investment is still serving you well. There are many great dividend stocks that investors can buy and hold for years. But dividend stocks can fall out of favor. Above all else, that’s the reason whya tool like this exists to make it easy for you to get the information you need from a trusted source like MarketBeat.com.

Download the Excel Dividend Calculator Here.

Don't want to download? An online version of the Dividend Calculator is also available here..

More Dividend Resources from MarketBeat

Get 30 Days of MarketBeat All Access Free

Sign up for MarketBeat All Access to gain access to MarketBeat's full suite of research tools:

• Best-in-Class Portfolio Monitoring

  View the latest news, buy/sell ratings, SEC filings and insider transactions for your stocks. Compare your portfolio performance to leading indices and get personalized stock ideas based on your portfolio.

• Stock Ideas and Recommendations

  Get daily stock ideas from top-performing Wall Street analysts. Get short term trading ideas from the MarketBeat Idea Engine. View which stocks are hot on social media with MarketBeat's trending stocks report.

• Advanced Stock Screeners and Research Tools

  Identify stocks that meet your criteria using seven unique stock screeners. See what's happening in the market right now with MarketBeat's real-time news feed. Export data to Excel for your own analysis.

Start Your 30-Day Free Trial

Sign in to your free account to enjoy these benefits

• In-depth profiles and analysis for 20,000 public companies.
• Real-time analyst ratings, insider transactions, earnings data, and more.
• Our daily ratings and market update email newsletter.

Sign in to your free account to enjoy all that MarketBeat has to offer.

• Sign In
• Create Account

Your Email Address:

Your Password:

---

or

Sign in with Facebook Sign in with Google

Forgot your password?

Your Email Address:

Choose a Password:

Create My Account (Free)

---

or

Sign in with Facebook Sign in with Google

By creating a free account, you agree to our terms of service. This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.