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
 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
 OIBDA
 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
 CFROI
 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
 EBITDAR
 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.
Recommended Courses
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
Annual Dividends per Share  
Price per Share  
Dividend Yield (Stock) Formula =  
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
Recommended Articles:
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.
Leave a Reply