EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Diluted EPS Formula
 

Diluted EPS Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated November 23, 2023

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

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

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 a 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 an 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 are issued if  preferred shares converted – 50,000
Additional shares are issued if the debt is converted. 5,000
Additional shares issued If options are 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 holder exercises the dilutive securities. 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 than 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 a 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 are 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 anti-dilutive and 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 assumes 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, and 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 are issued if  preferred shares are 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

There would be additional common shares if conversion takes place for convertible debentures. At the same time, the company will not pay any interest on the convertible debt, meaning that net income will increase by the post-tax amount of interest payment. Consider the above example of company ABC assuming only convertible debt is 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 are issued if debt is 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 are calculated by an increase for an excess of many newly 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 exist 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 are issued If options are 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 will most likely 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 with conversion options for which the companies are committed to issuing additional shares in the future. A complex capital structure is specially maintained to lower the cost of capital. For example, financial institutions lending convertible debt would charge lower interest than 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 occur simultaneously.
  • The difference in basic and diluted EPS: Most analysts and investors are critical of the big difference between basic and diluted EPS. This means 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 the case of $10 million outstanding shares as in the 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: Diluted EPS and basic EPS are the same for a simple capital structure with no conversion options. When comparing with a complex capital structure, it is more appropriate to use Diluted EPS to facilitate an “apple to apple” comparison across time and peers.
  • Impact on company’s P/E and other valuation measures: Diluted EPS adversely impacts the P/E ratio, so shareholders generally dislike companies issuing dilutive securities. Again, analysts find it is less difficult to calculate P/E using a total market cap in the numerator and total earnings in the denominator in case of a complex capital structure rather than checking for each 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 the 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 a Diluted EPS Formula Calculator with a 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)

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
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

EDUCBA

Download Diluted EPS Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

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

🚀 Limited Time Offer! - 🎁 ENROLL NOW