From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

Free Dividend Calculator Online: Calculate Investments

Free dividend income calculator online calculate investment income banner for blog

A dividend calculator is a financial tool that helps investors figure out how much money they’ll get from stock dividends. It typically considers factors like the number of shares owned, current stock price, and dividend amount.

Dividend Calculator

Struggling with manual calculations?
Create KPIs and track your data regularly

Dashboard example from Ajelix BI

Learn more
Fast registration and easy setup

What is a dividend?

A dividend is a portion of a company's profit that is distributed to its shareholders. It's essentially a way for the company to share its financial success with the people who own pieces of the company (the shareholders).

Here are some key points about dividends:

  • Distribution of profits: Dividends are paid out of a company's earnings, not necessarily all of them. The company's board of directors decides how much profit will be distributed as dividends and how much will be reinvested in the business for future growth.
  • Cash or stock: Dividends can be paid in cash, which is the most common form, or in additional shares of the company's stock.
  • Not mandatory: There is no obligation for a company to pay dividends. Even if a company is profitable, it may choose to reinvest all its earnings back into the business.
  • Tax implications: Dividends are taxed differently than capital gains (profits from selling stocks).

What is Dividend yield?

The dividend yield is a financial ratio that tells you the percentage of a company's share price that it pays out in dividends each year. It's a way to measure the income you'd receive from a stock's dividends relative to its current price.

Dividend yield formula

Dividend yield = (Annual dividend per share) / (Current stock price)

For example, let's say a company has a share price of $20 and pays a dividend of $1 per year. Its dividend yield would be:

Dividend yield = ($1 annual dividend) / ($20 current stock price) = 5%

In this example, a 5% dividend yield means that for every $1 you invest in this company's stock, you'd earn $0.05 annually in dividends.

Here are some things to keep in mind about dividend yield:

  • A higher yield generally indicates more income: A higher dividend yield typically suggests a larger portion of the share price is paid out as dividends. This can be attractive to investors seeking current income.
  • Not the only factor to consider: A high dividend yield doesn't necessarily mean it's a good investment. The company's future growth prospects, financial health, and overall risk profile are also important factors to consider.
  • Yield can change: Dividend yields can fluctuate over time as the company's stock price changes or its dividend payout policy evolves.

How To Calculate Dividend Income In Excel?

Calculate dividend income in Excel following this 17-step guide or download the Excel template with the dividend calculator at the bottom of the guide.

1. Create fields for variable values

Name the variable cells and input values for calculations:

  • Stock price
  • Number of shares
  • Investment amount
  • Holding period (years)
  • Annual dividend yield (%)
  • Annual contribution
  • Dividend tax rate (%)
  • Expected rise in dividend payout (%)
  • Expected Rise in Stock Price P.A (%)
  • Dividend reinvestment
Create a variable cells for dividend calculator formulas screenshot from excel
Screenshot from Excel with example for formula variables, image by author

2. Create a table for calculations

Name table headers for calculations with the following values:

  • Year
  • Investment Amount
  • Annual Dividend
  • Yield
  • Yield on cost
  • After DRIP value
  • Investment increase
  • Annual contribution
  • Cumulative dividends
  • Total contributions
Create a table in excel for dividend calculations screenshot from excel
Screenshot from Excel with table for dividend calculations, image by author

3. Fill out the Year and Annual contributions columns

Fill out the first column "Year" with values depending on how many years you want to calculate dividends. For Annual contributions simply type =D6 (a variable field that contains annual contributions value), and press F4 to freeze this cell so you can drag down and fill out the table. Annual contributions usually don't change over the years, if they do, manually insert values.

Screenshot from excel with steps how to fill out year and annual contribution columns
Screenshot from Excel with steps to fill out Year and annual contributions columns

4. Calculate the yield for each year

For the first year type the same yield you have in variables. For the next years calculate the expected rise in dividend payout, type formula =Annual Dividend Yield (%) *(1+Expected Rise in Dividend Payout (%))

Screenshot from Excel on how to calculate yield for each year with formula
Screenshot from Excel on how to calculate yield for each year with formula

5. Fill out the total contributions column

In the first row type the investment amount, in our example it's $10,000. For the next rows type formula: = Investment Amount + Annual Contribution

Screenshot from excel on how to fill our total contribution column
Screenshot from Excel on how to calculate total contributions column

6. Calculate Investment increase

Fill out the first row for the "Investment amount" column, which in our example is $10'000. Then for the "Investment increase" column type formula =Investment Amount + Expected Rise in Stock Price P.A (%).

Screenshot from Excel on how to calculate investment increase for dividens
Screenshot from Excel on how to calculate investment increase for dividend calculation

7. Calculate Annual Dividend

To calculate "Annual Dividend" use the formula =Investment Amount * Yield * (1-Dividend Tax Rate (%))

Screenshot from Excel on how to calculate annual dividend with formula
Screenshot from Excel with formula on how to calculate annual dividend

8. Calculate Yield On Cost

The next step to calculate dividend income is to get "Yield On Cost" values. To do that use this formula =Annual Dividend / Total Contributions

Screenshot from excel on how to calculate yield on cost with formula for dividend
Screenshot from Excel with formula on how to calculate yield on cost

9. Fill out the Cumulative Dividends for 1 year

For the first year "Cumulative Dividends" will be the same as "Annual Dividend". Type =Annual Dividend 1 Year.

Screenshot from Excel on how to calculate cumulative dividends with formula
Screenshot from Excel on how to calculate cumulative dividends with formula

10. Calculate the Investment amount for the 2-year

Once you have calculated values for the 1 year, you can start filling out values for the second year. To get the Investment Amount for 2 years type this formula = After DRIP Value (previous year) + Investment Increase (previous year) + Annual Contribution

Screenshot from Excel on how to calculate investment amount for the second year with formula
Screenshot from Excel on how to calculate investment amount for the second year with formula

11. Fill out the Annual Dividend value for the 2-year

Once you have calculated the "Investment Amount" you can type the formula to get a 2-year "Annual Dividend" or you can drag down the formula from the previous year's calculation. Here's the formula =Investment Amount (2-year) * Yield (2-year) * (1-Dividend Tax Rate (%)).

Screenshot from Excel on how to calculate annual dividend for the second year with formula
Screenshot from Excel on how to calculate annual dividend for the second year with formula

12. Get Yield On Cost for the 2-year

To get the value for 2-year you can drag and fill the formula down from the previous year or use this formula =Annual Dividend (2-year) + Total Contributions (2-year).

Screenshot from Excel on how to calculate yield on cost with formula
Screenshot from Excel on how to calculate yield on cost with formula

13. Calculate the Drip Value for a 2-year

Again to get this value you can drag and fill the formula from the previous year or type this formula =Investment Amount (2-year) + Annual Dividend (2-year).

Screenshot from Excel on how to calculate after drip value with formula
Screenshot from Excel on how to calculate after drip value with formula

14. Calculate Investment Increase for 2-year

Repeat the actions from previous steps to get this value or type this formula =Investment Amount (2-year) * Expected Rise in Stock Price P.A (%).

Screenshot from Excel on how to calculate investment increase with formula
Screenshot from Excel on how to calculate investment increase with formula

15. Calculate Cumulative Dividends 2-year

To get the value for 2-year insert this formula =Cumulative Dividends (previous year) + Annual Dividend (the same year).

Screenshot from Excel on how to calculate cumulative dividends for the second year with formula
Screenshot from Excel on how to calculate cumulative dividends with formula

16. Fill out the values for the rest of the years

Now you have values and formulas for two years and you can easily fill out formulas for the next years gradually, like we did in the previous steps.

Screenshot from Excel on how to calculate dividends for all years with formulas
Screenshot from Excel on how to calculate dividends for all years based on formulas

17. Find the total results for your investment plan

Once you have filled out the table for all years, you get the Ending Balance, Total Dividend Income, and Yield on Cost.

Screenshot from Excel on how to calculate total dividends and ending balance
Screenshot from Excel with total dividends, ending balance, and yield on costs after 10-year investment

Download the Dividend Calculator in the Excel Template

Dividend Calculator in Excel template screenshot
Screenshot from Excel dividend calculator template

Download your dividend investment Excel template below 👇

When are dividends paid?

The frequency of dividend payments varies depending on the company's dividend policy. Here's a breakdown of the common payment schedules:

FrequencyDescription
QuarterlyMost frequent payout schedule, providing consistent income throughout the year.
Semi-AnnuallyDividends are distributed twice a year, typically in June and December.
AnnuallyLess frequent approach, with payouts happening just once a year.
SpecialOne-time dividend payment outside of the regular schedule.
Dividend payout frequency

What are the Benefits of Owning a Dividend Stock?

There are a couple of key benefits to owning dividend stocks:

  • Regular income: Dividend-paying companies share a portion of their profits with shareholders through regular payments. This provides investors with a steady stream of income, which can be used for living expenses, reinvesting in more stocks, or other purposes.
  • Potential for compounding: When you reinvest your dividends to buy more shares of the same stock (or a different stock), you benefit from compounding. This means your returns are earned not just on your original investment, but also on any reinvested dividends. Over time, this compounding effect can significantly grow your wealth.
  • Lower volatility: Dividend-paying stocks tend to be larger, more established companies with a history of profitability. These companies are generally less volatile than growth stocks, which can be more sensitive to market fluctuations. This can provide some stability to your portfolio during down markets.
  • Hedge against inflation: Some companies also raise their dividends over time. This can help to offset the effects of inflation, which can erode the purchasing power of your money over time.
what are the benefits of owning a dividend stock infographic
4 benefits of owning a stock dividend, infographic by author

Here are some things to keep in mind about dividend stocks:

  • Not all dividend stocks are created equal: A high dividend yield isn't always a good sign. It could indicate that the company is struggling to grow and is instead returning profits to shareholders. It's important to consider the company's overall financial health and future prospects before investing in a dividend stock.
  • Dividends are not guaranteed: Companies can cut or suspend their dividends at any time. This can happen if the company's profits decline or if it needs to conserve cash for other purposes.

FAQ

Why do companies pay dividends?

Companies pay dividends to share profits with shareholders and incentivize them to hold onto the stock. It's a way to return some of the company's earnings to investors.

What factors affect a company's dividend policy?

Several factors affect a company's dividend policy, including profitability, growth plans, and debt levels. Companies with strong profits may prioritize returning cash to shareholders through dividends, while growing companies may reinvest profits for future expansion. Debt levels can also impact dividends, as companies with high debt may need to prioritize debt repayment over payouts.

Are dividends a reliable source of income?

Dividends can be a reliable source of income but with some caveats. The payout is not guaranteed as companies can cut or suspend dividends anytime. A decline in the stock price can offset dividend income. Dividends are typically taxed, reducing your overall return.

How are dividends taxed?

Dividends are taxed differently depending on their type:
Qualified dividends: Generally taxed at a lower capital gains rate than ordinary income (potentially 0%, 15%, or 20%).
Ordinary dividends: Taxed at your regular income tax rate (up to 37%).

How often are dividends typically paid out?

Companies typically pay dividends quarterly, meaning four times a year. However, some companies may pay them: semi-annually (twice a year), annually (once a year), or occasionally as a special dividend (outside the regular schedule).

Disclaimer: The information on this page is for educational purposes only and should not be construed as financial advice. While we strive to provide accurate information, investing involves inherent risks. Please consult with a qualified financial advisor before making any investment decisions.

Setup and monitor your KPIs regularly using Ajelix BI

Ad hoc financial analysis report example from ajelix bi portal