WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Dividend Payout Ratio Formula

Dividend Payout Ratio Formula

By Sayantan MukhopadhyaySayantan Mukhopadhyay | Reviewed By Dheeraj VaidyaDheeraj 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

DIVIDEND PAYOUT RATIO FORMULA

Explanation

For a company, sharing the profit is an after-thought. First, they decide how much they will reinvest into the company so that the business can 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 is paying a dividend 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 the profits of the company 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 earnings and dividend payments), the entire profit is distributed or invested in the other.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Colgate vs Amazon payout ratio

As we note from 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 income statement of the company, she would be able to find the net income for the year. And in the balance sheet, retained earnings would be found. If you need to know how the company has calculated the retained earnings and also dividends, you can check the footnotes under the financial statements.

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. 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.

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.

  • That means the retention ratio is 66.67%. Then, using the second method, we get –
  • Dividend payout ratio = 1 – Retention Ratio = 1 – 66.67% = 1 – 2/3 = 1/3 = 33.33%.

Apply Dividend Payout Ratio Calculation

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

Apple Payout Ratio

source: ycharts

Items 2012 2013 2014 2015 2016
Dividends ($ bn) 2.49 10.56 11.13 11.56 12.15
Net Income ($bn) 41.73 37.04 39.51 53.39 45.69
Dividends Payout Ratio 5.97% 28.51% 28.17% 21.65% 26.59%

Till 2011, Apple didn’t pay any dividend 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 did eventually.

Uses

Understanding the equation between retained earnings and dividend payments will help an investor comprehend the short term and the long term goal of a company.

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 formula, 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

Dividend Payout Ratio Formula Video

Recommended Articles

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 –

  • Special Dividend – Meaning
  • Mutual Fund Expense Ratio Example
  • Compare – Dividends Ex-Date vs. Record Date
  • Dividend Payment Chronology
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

WallStreetMojo

Download Dividend Payout Ratio Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More