Financial Statement Analysis
- Ratio Analysis of Financial Statements (Formula, Types, Excel)
- Ratio Analysis Advantages
- Ratio Analysis
- Liquidity Ratios
- Cash Ratio
- Quick Ratio
- Quick Ratio Formula
- Current Ratio
- Current Ratio Formula
- Acid Test Ratio Formula
- Defensive Interval Ratio
- Working Capital Ratio
- Working Capital Formula
- Net Working Capital Formula
- Current Ratio vs Quick Ratio
- Bid Ask Spread
- Liquidity vs Solvency
- Liquidity Risk
- Altman Z Score
- Turnover Ratios
- Profitability Ratios
- Profit Margin
- Gross Profit Margin Formula
- Operating Profit Margin Formula
- Net Profit Margin Formula
- EBIDTA Margin
- Earnings Per Share
- Basic EPS
- Diluted EPS
- Basic EPS vs Diluted EPS
- Return on Equity (ROE)
- Return on Capital Employed (ROCE)
- Return on Invested Capital (ROIC)
- ROIC vs ROCE
- Return on Total Assets (ROA)
- Return on Average Capital Employed
- Capital employed Employed
- Return on Average Assets (ROAA)
- Return on Average Equity (ROAE)
- Return on Assets Formula
- Return on Equity Formula
- DuPont Formula
- Net Interest Margin Formula
- Earnings Per Share Formula
- Diluted EPS Formula
- Contribution Margin Formula
- Revenue Per Employee Ratio
- Operating Leverage
- EBIT vs EBITDA
- Capital Gains Yield
- Tax Equivalent Yield
- LTM Revenue
- Operating Expense Ratio Formula
- Overhead Ratio Formula
- Capitalization Rate
- Comparative Income Statement
- Capacity Utilization Rate Formula
- Total Expense Ratio Formula
- Efficiency Ratios
- Dividend Ratios
- Debt Ratios
- Debt to Equity Ratio
- Debt Coverage Ratio
- Debt Ratio
- Debt to Income Ratio Formula (DTI)
- Capital Gearing Ratio
- Capitalization Ratio
- Interest Coverage Ratio
- Times Interest Earned Ratio
- Debt Service Coverage Ratio (DSCR)
- Financial Leverage Ratio
- Net Debt Formula
- Leverage Ratios
- Operating Leverage vs Financial Leverage
- Current Yield
- Debt Yield Ratio
Dividend Yield Formula – Flow of the article
Dividend Yield Formula
Every investor needs to know how much she will get back in return compared to the price she is paying for each share. Dividend Yield formula helps the investors figure out how much return she will get back.
Here’s the formula for dividend yield –
Explanation of Dividend Yield Formula
Let’s take a simple example to illustrate how dividend yield formula works.
Let’s say that X and Y both bought the shares of two different companies. X got to know that his dividend yield is 10% and Y got to know that her dividend yield is 5%.
X got pretty happy since he is getting a lot more compared to what he paid for each share. However, Y got a bit sad to see that her dividend yield – stock is only a meager percentage.
They both consult a financial consultant. And the financial consultant told both X and Y that usually when a company pays more dividend yield, the company’s growth potential is not that good and vice versa.
Knowing that X thought upon his decision to buy the share for more dividend yield, but Y got happy knowing that she made a prudent decision.
From the above example, it’s clear that dividend yield has a lot to do with how a company is approaching its future potential. That’s why for an investor, it’s an important measure. But to get a sound knowledge of a company; the investor also needs to look at other measures like market value of the company, enterprise value, net income for the last year, financial statements etc.
Use of Dividend Yield Formula
The formula that is used for dividend yield is the simplest and any novice can also understand how to calculate it. That’s why its appeal is more to the investor.
But before an investor ever decides to look at the dividend yield; she also needs to look at the past records of the company, how much dividend per share the company paid in recent years, company’s future growth potential etc.
If an investor looks at all the measures along with dividend yield; she will get a holistic approach to the company. And she will also understand whether to invest in that particular company or not.
Example of Dividend Yield Formula
We will now take a practical example of dividend yield formula.
Good Inc. is offering a dividend of $4 per share. Binny has bought few shares of Good Inc. at $100 per share. What would be the dividend yield of Good Inc.?
On the surface, this is a simple example. First, we will calculate the dividend yield and then we will discuss how we can interpret this.
- We know the dividend per share. It is $4 per share.
- We also know the price per share i.e. $100 per share.
Dividend yield of Good Inc. is then –
- Dividend Yield = Annual Dividend per Share / Price per Share = $4 / $100 = 4%.
An investor who doesn’t know the growth potential of Good Inc. may judge that the dividend yield is too low. However, Good Inc. may have a great growth potential for which it pays less dividend and concentrates more on the maximization of wealth for the shareholders.
Dividend Yield Calculator
You can use the following Dividend Yield Calculator
|Dividend Yield (Stock) Formula =||
Dividend Yield in Excel (with Excel Template)
Let us now do the same example above in Excel.
This is very simple. You need to provide the two inputs of Dividend per Share and Price per Share.
You can easily calculate the ratio in the template provided.
You can download this dividend yield template here – Dividend Yield Excel Template
This has been a guide to dividend yield formula, its uses along with practical examples. Here we also provide you with dividend yield calculator with downloadable excel template.