WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Diluted EPS Formula

By Pritha BanerjeePritha Banerjee | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Formula to Calculate Diluted EPS

Diluted EPS is a measurement of profitability and is calculated as the ratio of company’s income to the number of outstanding shares after taking into consideration dilutive securites like convertible debt, preferred stocks, options and warrants.

Let’s have a look at the formula of diluted earnings per share –

Diluted Eps = (net Income – Preferred Stock Dividends) / (Weighted Average Number of Shares Outstanding + the Conversion of Any in The Money Options, Warrants and Other Dilutive Securities)

DILUTED EPS FORMULA

From the above-diluted earnings per share formula, you can understand you need to look at the entire balance sheet and the income statement Diluted EPS Calculation.

Explanation

There is a difference between basic and diluted earnings per share.  In basic earnings per share (EPS), the idea is to find out the net income per share of the firm. For example, if a firm has a net income of $100,000 and the firm has 10,000 outstanding shares; then the earnings per share (EPS) would be = ($100,000 / 10,000) = $10 per share.

However, in this case, the idea is about realization. In diluted earnings per share (DPS), along with the common outstanding shares, we will also consider convertible shares – the shares which have the possibility of turning into the company’s shares.

That’s why, in almost all situations, DPS would always be lower than the earnings per share (this is basic math – in the case of DPS, the denominator is much bigger).

Example of Diluted Earnings per Share Formula

Let’s take an example for Diluted EPS Calculation.

You can download this Diluted Earnings per Share Excel Template here – Diluted Earnings per Share Excel Template

Good Inc. has the following information in the year-end 2017 –

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
  • Net Income: $450,000
  • Common Shares Outstanding: 50,000
  • Preferred Stock Dividend: $50,000
  • Unexercised Employee Stock Options: 5000
  • Convertible Preferred Stocks: 23,000
  • Convertible Debt: 10,000
  • Warrants: 2000

Calculate basic earnings per share and the DPS

All information is given in the example above. We will put it in the diluted earnings per share formula.

  • First, we will find out the earnings per share.
  • Basic Earnings per share = Net Income / Common Shares Outstanding = $450,000 / 50,000 = $9 per share.

Diluted Earnings per Share Formula = (Net Income – Preferred Stock Dividends) / (Common Shares Outstanding + Unexercised Employee Stock Options + Convertible Preferred Stocks + Convertible Debt + Warrants)

  • Or, Diluted EPS Formula = ($450,000 – $50,000) / (50,000 + 5000 + 23,000 + 10,000 + 2000)
  • Or, DPS = $400,000 / 90,000 = $4.44 per share.

Use of Diluted EPS

If you look at the financial statements, you may not get the information related to the diluted earnings per share. You need to look at notes along with the financial statements to have a sense of diluted earnings per share.

Using a diluted EPS formula helps investors know what would be the earnings per share if all or a few convertible securities convert into the company’s shares.

As an investor, you need to look at both – earnings per share and diluted earnings per share to have a holistic view of earnings per share.

Diluted EPS Calculator

You can use the following Diluted EPS Calculator

Net Income
Preferred Stock Dividends
Common Shares Outstanding
Unexercised Employee Stock options
Convertible Preferred Stocks
Convertible Debt
Warrants
Diluted Earnings per Share Formula =
 

Diluted Earnings per Share Formula =
(Net Income − Preferred Stock Dividends)
=
(Common Shares Outstanding + Unexercised Employee Stock options + Convertible Preferred Stocks + Convertible Debt + Warrants)
(0−0)
= 0
(0+0+0+0+0)

Calculate Diluted Earnings per Share 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 Net income and Common Shares Outstanding.

You can easily do the Diluted EPS Calculation in the template provided.

First, we will find out the earnings per share.

earnings per share

Here is the formula for Diluted EPS Calculation

Diluted EPS Formula = (Net Income – Preferred Stock Dividends) / (Common Shares Outstanding + Unexercised Employee Stock Options + Convertible Preferred Stocks + Convertible Debt + Warrants)

diluted earnings per share in excel

Diluted EPS Formula Video

Recommended Articles:

This has been a guide to Diluted EPS Formula. Here we discuss how to calculate diluted earnings per share along with practical examples and downloadable excel templates. You may also have a look at these articles below to learn more about Financial Analysis –

  • EPS – Full Form
  • Compare – Basic EPS vs. Diluted EPS
  • Diluted Shares Examples
  • Types of Stock Dilution
0 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 Diluted Earnings per Share Excel Template

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