EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Diluted EPS Formula
Secondary Sidebar
Finance Blog
  • Accounting Fundamentals Resources (720+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Resources (374+)
  • Credit Research Fundamentals (6+)
  • Economics (104+)
  • Finance Formula (384+)
  • Financial Modeling in Excel (16+)
  • Investment Banking Resources (142+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (26+)
  • Insurance Resources (15+)
  • Top Finance Books (33+)
Finance Blog Courses
  • Investment Banking Course
  • Investment Banking Online Course
  • Financial Modeling Certification

Diluted EPS Formula

By Madhuri ThakurMadhuri Thakur

Diluted-EPS-Formula

Diluted EPS Formula (Table of Contents)

  • Diluted EPS Formula
  • Diluted EPS Calculator
  • Diluted EPS Formula in Excel (With Excel Template)

Diluted EPS Formula

Diluted EPS

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

Where,

Convertible Securities = Convertible preferred shares + Convertible debt + Stock options + warrants

Examples

Suppose Company ABC has the following structure of shares and dilutive securities at the end of a fiscal year:

You can download this Diluted EPS Formula Excel Template here – Diluted EPS Formula Excel Template
  • Weighted average Common shares outstanding: 800,000
  • Convertible preferred shares: 10,000, convertible into 5 shares of common stock each and paying dividend of $10 per share
  • Convertible Debt: $20,000 of 5% bonds convertible into 5,000 shares
  • Stock Options outstanding at the beginning of the year: 10,000 with the exercise price of $45 (Average market price of company shares during the year was $55 per share)
  • Net Income before preferred dividend=$2,000,000, tax rate 25%
Particulars ($) Basic EPS Diluted EPS
Net income 20,00,000 20,00,000
Less: Preferred Dividend 1,00,000 –
Add: After-tax cost of interest – 750
Numerator 19,00,000 20,00,750
Weighted average number of common shares outstanding 8,00,000 8,00,000
Additional shares issued if  preferred shares converted – 50,000
Additional shares issued if debt converted 5,000
Additional shares issued If options exercised (in-the-money) – 181.8
Denominator 8,00,000 8,56,818
EPS 2.38 2.34

 

Diluted EPS Formula= Net Income(Before Preferred Dividends)+After Tax Cost of Interest / (Common Shares Outstanding +Additional Shares Against Exercise of Convertible Securities)

  • Diluted EPS = (20,00,000 + 750) / (8,00,000 + 50,000 + 5,000 + 1,818)
  • Diluted EPS = 20,00,750 / 8,56,818
  • Diluted EPS = 2.34

Explanation of Diluted EPS Formula

  • Definition: Diluted EPS represents a company’s earnings performance (income per share) assuming all its dilutive convertible securities are exercised. Convertible securities could be preferred shares, debentures, unexercised stock options and warrants. Diluted EPS considers what would happen if the dilutive securities are exercised by the holder. Since dilutive securities effectively increase the number of shares outstanding, EPS falls.
  • Dilutive vs Antidilutive securities: Each of these convertible securities needs to be dilutive which means that their inclusion in the computation of diluted EPS should not yield a higher EPS value as compared to basic EPS.

For example, consider Company AD has the following structure of shares and convertible securities at the end of a fiscal year:

  • Weighted average Common shares outstanding: 800,000
  • Convertible preferred shares: 10,000, convertible into 3 shares of common stock   of  each and paying dividend of $10 per share
  • Net Income before preferred dividend=$2,000,000
Particulars ($) Basic EPS Diluted EPS if converted
Net income 20,00,000 20,00,000
Less: Preferred Dividend 1,00,000 –
Numerator 19,00,000 20,00,000
Weighted average number of common shares outstanding 8,00,000 8,00,000
Additional shares issued if  preferred shares converted – 30,000
Denominator 8,00,000 8,30,000
EPS 2.38 2.41

 

Diluted EPS Formula = Net Income(Before Preferred Dividends)+After Tax Cost of Interest / (Common Shares Outstanding +Additional Shares Against Exercise of Convertible Securities)

  • Diluted EPS = (20,00,000 + 0) / (8,00,000 + 30,000)
  • Diluted EPS = 20,00,000 / 8,30,000
  • Diluted EPS = 2.41

Since Diluted EPS (if preferred are converted) exceeds basic EPS, these convertible preferred shares are antidilutive and hence, will not be included in the computation of diluted EPS. Hence, diluted EPS is always less than or equal to basic EPS.

  • Computation for convertible preferred shares/debentures: In these cases, diluted EPS is calculated using the if-converted method which assumed that the securities had been converted at the beginning of the year.

For preferred shares, after conversion, there would be no preferred shares outstanding, hence no preferred dividends would be given an additional common shares would be issued which would increase common shares outstanding value. Consider the above example of company ABC assuming only convertible preferred shares are there and other convertibles are absent. The computation would be as follows:

Particulars Basic EPS Diluted EPS
Net income 20,00,000 20,00,000
Less: Preferred Dividend 1,00,000 –
Numerator 19,00,000 20,00,000
Weighted average number of common shares outstanding 8,00,000 8,00,000
Additional shares issued if  preferred shares converted – 50,000
Denominator 8,00,000 8,50,000
EPS 2.38 2.35

 

Diluted EPS Formula = Net Income(Before Preferred Dividends)+After Tax Cost of Interest / (Common Shares Outstanding +Additional Shares Against Exercise of Convertible Securities)

  • Diluted EPS = (20,00,000 + 0) / (8,00,000 + 50,000)
  • Diluted EPS = 20,00,000 / 8,50,000
  • Diluted EPS = 2.35

For convertible debentures, if conversion takes place, there would be additional common shares while company will not pay any interest on the convertible debt meaning thereby that net income will increase by post-tax amount of interest payment. Consider the above example of company ABC assuming only convertible debt are there and other convertibles are absent. The computation would be as follows:

Particulars Basic EPS Diluted EPS
Net income 20,00,000 20,00,000
Add: After tax cost of interest

(20,000*0.05*(1-0.25))***

– 750
Numerator 20,00,000 20,00,750
Weighted average number of common shares outstanding 8,00,000 8,00,000
Additional shares issued if debt converted – 5,000
Denominator 8,00,000 8,05,000
EPS 2.50 2.49

*** Tax rate-25%, interest rate-5%, debt-$20,000

 

Diluted EPS Formula = Net Income(Before Preferred Dividends)+After Tax Cost of Interest / (Common Shares Outstanding +Additional Shares Against Exercise of Convertible Securities)

  • Diluted EPS = (20,00,000 + 750) / (8,00,000 + 5,000)
  • Diluted EPS = 20,00,750 / 8,05,000
  • Diluted EPS = 2.49
  • Computation for stock options and warrants: Under IFRS, shares outstanding is calculated by increased for an excess of a number of new converted shares over and above the no of “inferred” shares that would have to be issued at the average market price of the period for receiving the conversion proceeds. Consider the above example of company ABC assuming only unexercised stock options are there and other convertibles are absent. The computation would be as follows:
Increase in shares outstanding  
Proceeds from option exercise (10,000*45) $4,50,000
New shares issued proceeds @$55 per share for receiving same proceeds (inferred shares) (450,000/55) 8,182
Actual shares issued under options 10,000
Dilutive shares from options 1,818

 

Dilutive shares from options = Actual shares – New shares issued

  • Dilutive shares from options =  10,000 – 8,182
  • Dilutive shares from options = 1,818
Particulars Basic EPS Diluted EPS
Net income 20,00,000 20,00,000
Numerator 20,00,000 20,00,000
Weighted average number of common shares outstanding 8,00,000 8,00,000
Additional shares issued If options exercised – 1,818
Denominator 8,00,000 8,01,818
EPS 2.50 2.49

 

Diluted EPS Formula = Net Income(Before Preferred Dividends)+After Tax Cost of Interest / (Common Shares Outstanding +Additional Shares Against Exercise of Convertible Securities)

  • Diluted EPS = (20,00,000 + 0) / (8,00,000 + 1,818)
  • Diluted EPS = 20,00,000 / 8,01,818
  • Diluted EPS = 2.49

Only in-the-money options may be considered for dilution since they are most likely to be exercised. The options are considered in-the-money if the exercise price is lower than the average market price during the specified period used for computing EPS.

Significance and Use of Diluted EPS Formula

  • Complex capital structure and conservatism: Most companies have a complex capital structure consisting of securities having conversion option for which the companies are committed to issuing additional shares in future. Complex capital structure is specially maintained to lower the cost of capital. For example, financial institutions lending convertible debt would charge a lower interest than otherwise equivalent non-convertible debt. When assessing a company’s financial health, however, it is more appropriate to take the more conservative diluted EPS assuming all conversions are exercised although it is unlikely that all conversions will take place simultaneously.
  • The difference in basic and diluted EPS: Most analysts and investors are critical of a big difference in basic and diluted EPS. Effectively, this means that the company has a very complex capital structure and significant commitments should the exercise materialize. Another point to note is the actual difference figure. A $0.1 difference between the two EPS may not be as significant in case of $10 million outstanding shares as in case of $10 billion outstanding shares. In the former case, $1 million is not available to exist, investors, while in the latter case it is $1000 million.
  • Diluted EPS vs Basic EPS for comparison: For a simple capital structure with no conversion options, diluted EPS and basic EPS are same. When comparing with a complex capital structure, it is more appropriate to use Diluted EPS to facilitate “apple to apple” comparison across time and peers
  • Impact on company’s P/E and other valuation measures: Diluted EPS adversely impacts P/E ratio, so shareholders generally dislike companies issuing dilutive securities. Again, analysts find it is less cumbersome to calculate P/E by using a total market cap in the numerator and total earnings in the denominator in case of a complex capital structure rather than check for each and every conversion in the financial statements.

Diluted EPS Formula Calculator

You can use the following Diluted EPS Formula Calculator

Net Income
After Tax Cost of Interest
Common Shares Outstanding
Additional shares issued if preferred shares converted
Additional shares issued if debt converted
Additional shares issued If options exercised (in-the-money)
Diluted EPS Formula =
 

Diluted EPS Formula =
(Net Income + After Tax Cost of Interest)
=
(Common Shares Outstanding + Additional shares issued if preferred shares converted + Additional shares issued if debt converted + Additional shares issued If options exercised (in-the-money) )
(0+0)
= 0
(0+0+0+0)

Diluted EPS Formula in Excel (With Excel Template)

Here we will do the same example of the Diluted EPS formula in Excel. It is very easy and simple.

You can easily calculate the Diluted EPS using Formula in the template provided.

Example #1

Calculation of EPS for Example 1

Example #2

calculation of EPS for Example 2

Example #3

Calculation of EPS for Example 3

Example #4

calculation of EPS for Example 4

Example #5.1

Calculation of Dilutive share from option

Example #5.2

Calculation of EPS for Example 5

Recommended Articles

This has been a guide to a Diluted EPS formula. Here we discuss its uses along with practical examples. We also provide you with Diluted EPS Formula Calculator with downloadable excel template. You may also look at the following articles to learn more –

  1. Formula for Perpetuity
  2. Tax Equivalent Yield Formula
  3. Calculator for Capital Gains Yield Formula
  4. Template for Dividends Per Share Formula
  5. Shares Outstanding Formula
  6. Key Differences of Stock Option vs RSU
  7. Dilution Formula ( Examples with Excel Template)
Popular Course in this category
Financial Analyst Masters Training Program
  250+ Online Courses |  1000+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Investment Banking Training4.9
Investment Banking Training4.8
Financial Modeling Training4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

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

Download Diluted EPS Formula Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Diluted EPS Formula Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more