background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for May 2024 for May 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for May 2024 is Open
Wall Street Prep

Weighted Average Shares Outstanding

Step-by-Step Guide to Understanding Weighted Average Shares Outstanding

Last Updated December 28, 2022

Learn Online Now

Weighted Average Shares Outstanding

How to Calculate Weighted Average Shares Outstanding

The weighted average shares outstanding represents the number of common shares outstanding, after adjusting for the share count changes that occurred throughout a given period.

Over the course of a reporting period—most often a fiscal year—the total number of common shares in circulation increases and decreases multiple times for most public companies.

The following are common corporate actions that impact the number of shares outstanding:

  • Stock Buyback: The company decides to repurchase previously issued common shares, which reduces the number of shares in circulation.
  • New Stock Issuance: The company raises more capital by issuing more shares, which increases the number of shares outstanding (and creates additional dilution).
  • Conversion of Dilutive Securities: The company issued potentially dilutive securities in the past, such as options, warrants, restricted stock units (RSUs), and convertible debt. If the criteria for the security to be exercised are met and the holder decides to convert, additional shares are issued post-conversion (e.g. an option is now in-the-money and executed by the holder or the vesting period has passed for warrants).

In order to calculate a company’s earnings per share (EPS), a company’s net income is divided by its weighted average shares outstanding.

Earnings Per Share (EPS) = (Net Income  Preferred Dividends) ÷ Weighted Average Shares Outstanding

The numerator in the earning per share (EPS) formula is net income from the income statement, which tracks the financial performance of a company over a period of time.

If the beginning or ending share count were used, there would be a mismatch in the timing between the numerator (which typically spans the full fiscal year) and the denominator. Therefore, the misalignment in timing must be rectified by using the weighted average shares outstanding in the earning per share (EPS) calculation.

Weighted Average Shares Outstanding Formula

The formula to calculate the weighted average shares outstanding is as follows:

Weighted Average Shares Outstanding = Σ (Common Shares Outstanding × % Weight)

The sum of the “% Weight” inputs must equal 100% to ensure the entire period is covered.

Weighted Average Shares Outstanding Calculator — Excel Template

We’ll now move on to a modeling exercise, which you can access by filling out the form below.

dl

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Weighted Average Shares Outstanding Calculation Example

Suppose we’re tasked with calculating the weighted average shares outstanding of a public company for the fiscal year ending 2021.

On the final date of Q-4 2020, 12/31/2020, the company’s total number of common shares outstanding was 460 million.

The day right after (1/01/21)—the first date of the next quarter—the company completes a recurring stock buyback every three months as part of its share repurchase program, in which the number of repurchased shares each quarter was 5 million, 4.8 million, 4.6 million, and 4.5 million, respectively.

Stock Buyback Program

  • 01/01/21: -5 million
  • 04/01/21: -4.8 million
  • 07/01/21: -4.6 million
  • 10/01/21: -4.5 million

For simplicity, we’ll also assume the conversion of diluted securities occurs on the same dates.

From the start of Q-1 to Q-4, the net dilution from the converted securities was 100,000, 120,000, 125,000, and 150,000, respectively.

Net Dilution (Post-Conversion)

  • 01/01/21: +100,000
  • 04/01/21: +120,000
  • 07/01/21: +125,000
  • 10/01/21: +150,000

The “Ending Shares Outstanding” represents the common share count on the first date of the quarter.

  • Q-1 (01/01/21): 455,100
  • Q-2 (04/01/21): 450,420
  • Q-3: 07/01/21): 445,945
  • Q-4 (10/01/21): 441,595

The “% Weight” for each period is 25%, since each time period represents a quarter of the fiscal year.

Using the SUMPRODUCT function, we’ll calculate the weighted average shares outstanding over fiscal year 2021, which comes out to 448,265.

Weighted Average Shares Outstanding Calculator

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
0 Comments
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.