Dividend Payout Ratio Formula

Article bySayantan Mukhopadhyay
Reviewed byDheeraj Vaidya, CFA, FRM

Dividend Payout Ratio Formula

A dividend is the portion of the profit that the company shares with its shareholders, and the formula to calculate dividend payout is the percentage ratio of this dividend paid to the shareholders to the net profit for the year.

Here’s this formula –

Dividend Payout Ratio = Dividends/Net Ratio

Key Takeaways

  • The dividend payout ratio is the portion of the earnings that the company decided to distribute as dividends to the shareholders.
  • The formula for calculating the dividend payout ratio is Dividends/Net Ratio, where the net ratio is calculated as (Net Profit / Net Sales) x 100.
  • This ratio can help investors determine the company’s profitability, financial health, and intention to protect shareholders’ interests.
Dividend Payout Ratio Formula

You are free to use this image o your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Dividend Payout Ratio Formula (wallstreetmojo.com)

Explanation

For a company, sharing the profit is an after-thought. First, they decide how much they will reinvestReinvestReinvestment is the process of investing the returns received from investment in dividends, interests, or cash rewards to purchase additional shares and reinvesting the gains. Investors do not opt for cash benefits as they are reinvesting their profits in their portfolio.read more into the company to grow bigger, and the business can multiply the shareholders’ money instead of just sharing it. That’s why this formula is important.

It tells us how much a company pays dividends to the shareholders. And also how much the company is reinvesting into itself, which we call “retained earnings.”

Sometimes, a company doesn’t pay anything to the shareholders because they feel the need to reinvest its profits so that the company can grow faster.

Since the net profits of the company are only used for two purposes, we can conclude that –

Net Income = Retained Earnings + Dividend Payments

If anyone of the above is nil (among retained earningsRetained EarningsRetained Earnings are defined as the cumulative earnings earned by the company till the date after adjusting for the distribution of the dividend or the other distributions to the investors of the company. It is shown as the part of owner’s equity in the liability side of the balance sheet of the company.read more and dividend payments), the entire profit is distributed or invested in the other.

Colgate vs Amazon payout ratio

As we note above, Colgate Dividend Ratio was 61.78% in 2016-17. However, Amazon, Google, and Berkshire Hathway haven’t paid a penny to the shareholders via Dividends.

If an investor looks at the company’s income statement, she would be able to find the net income for the year. And in the balance sheet, retained earnings would be found. So if you need to know how the company has calculated the retained earnings and dividends, you can check the footnotes under the financial statements.

Financial Modeling & Valuation Course (25+ Hours of Video Tutorials)

If you want to learn Financial Modeling & Valuation professionally , then do check this ​Financial Modeling & Valuation Course Bundle​ (25+ hours of video tutorials with step by step McDonald’s Financial Model). Unlock the art of financial modeling and valuation with a comprehensive course covering McDonald’s forecast methodologies, advanced valuation techniques, and financial statements.

Dividend Payout Ratio Formula in Video

 

Example

Let’s look at a practical example of dividend ratio calculation.

You can download this Dividend Payout Ratio Excel Template here – Dividend Payout Ratio Excel Template

Danny Inc. has been in the business for the last few years. Recently it started paying its shareholders dividends. It has paid dividends of $140,000 to the shareholders. The net income of Danny Inc. was $420,000 in the last year. Therefore, Danny Inc. decided to keep retained earnings as 66.67%. Using two methods, find out the dividend ratio of Danny Inc. in the last year. As mentioned in the example, we will use two methods to calculate this ratio.

As mentioned in the example, we will use two methods to calculate this ratio.

First, we will use the first ratio.

  • We know that the dividends paid in the last year were $140,000. And the net profit was $420,000.
  • Using the first ratio of the dividend payout formula, we get –
  • Dividend ratio = Dividends / Net Income = $140,000 / $420,000 = 1/3 = 33.33%.

Now, we will use the second ratio.

We know that 66.67% was kept as retained earnings.

Apply Dividend Payout Ratio Calculation

Let’s look at a practical example to understand the dividend ratio better –

Apple Payout Ratio

source: ycharts

Items20122013201420152016
Dividends ($ bn)2.4910.5611.1311.5612.15
Net Income ($bn)41.7337.0439.5153.3945.69
Dividends Payout Ratio5.97%28.51%28.17%21.65%26.59%

Till 2011, Apple didn’t pay any dividends to its investors. Because they believed that if they reinvested the earnings, they would be able to generate better returns for the investors, which they eventually did.

Uses

Understanding the equation between retained earnings and dividend payments will help an investor comprehend a company’s short-term and long-term goals.

Since many companies also pay a 100% dividend, we can also use an alternative formula for calculating the dividend payout ratio.

Here’s the alternative formula –

alternative formula

The retention ratio is the percentage of profits the company keeps for reinvestment.

Looking at the last dividend payout ratio formulaPayout Ratio FormulaThe payout ratio formula calculates the amount announced as a dividend out of the total earnings (after-tax profits). There are two formulas to calculate the dividend payout ratio using the earning method and the outstanding method. Payout ratio (earning method)= Total dividend paid/Total earning.read more, the investors get ensured about how much they may receive in the near future.

Calculator

You can use the following Dividend Payout Ratio Calculator

Dividends
Net Income
Dividend Payout Ratio Formula
 

Dividend Payout Ratio Formula =
Dividends
=
Net Income
0
= 0
0

Calculate Dividend Payout Ratio 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 Dividends and Net Income.

You can easily calculate the ratio in the template provided.

First, we will use the first ratio.

dividend pay-out ratio (first ratio)

Now, we will use the second ratio.

dividend pay-out ratio in excel

Frequently Asked Questions (FAQs)

What is the formula of dividend payout ratio?

The formula for calculating the dividend payout ratio is Dividends/Net Ratio, where the net ratio is calculated as (Net Profit / Net Sales) x 100. It can also be derived from the 1 – retention ratio.

How can dividend payout ratio be interpreted?

The dividend payout ratio can aid investors in making decisions on various factors, including the organization’s maturity, reinvestment possibilities, sustaining the dividend payout ratio each year, and an increasing trend in dividends.

What are the trends of dividend payout ratio in companies?

It is well known that global banks have a consistent dividend payout ratio with a high average. On the other hand, in terms of dividend payout ratio, internet enterprises are virtually nonexistent. Additionally, it is well known that oil and gas businesses have a low dividend payment ratio.

This article has been a guide to the Dividend Payout Ratio Formula, practical examples, and Dividend Payout ratio calculator along with excel templates. You may also have a look at these articles below to learn more about Financial Analysis –