**Contents**show

The weighted average number of shares is calculated by taking the number of outstanding shares and multiplying the portion of the reporting period those shares covered, doing this for each portion and, finally, summing the total.

To calculate the weighted average cost per share, the investor can multiply the number of shares acquired at each price by that price, add those values, and then divide the total value by the total number of shares.

The formula for diluted earnings per share is a company’s net income (excluding preferred dividends) divided by its total share count — including both outstanding and diluted shares. As with basic EPS, for accuracy, it is best to use a weighted average of the company’s outstanding shares for the period.

Diluted Weighted Average Shares represents the number of shares for Diluted EPS computation. This is used as a denominator for computation of Diluted EPS Including/Excluding Extraordinary Items. Diluted EPS may be different from Basic EPS when a company reports convertible preferred stock or convertible debt.

It is calculated by dividing the company’s earnings for a given period by the number of common shares outstanding. Assume a company has 150,000 outstanding shares at the beginning of the year but buys back half of them in September, leaving only 75,000 at the end of the year.

## How do you calculate time-weighted average?

A time-weighted average is equal to the sum of the portion of each time period (as a decimal, such as 0.25 hour) multiplied by the levels of the substance or agent during the time period divided by the hours in the workday (usually 8 hours).

Basic Weighted Average Shares represents the weighted average common shares outstanding less the dilution of stock options for a given period. These shares are used to calculate Basic EPS.

Weighted average share outstanding is calculated by multiplying an outstanding number of shares after considering issuance and buybacks of shares in each reporting period with its time-weighted portion and thereafter summing up the total for each reporting period in a fiscal year.

For each change in the common shares:

- Compute the number of shares outstanding after each change in the common shares. …
- Weight the shares outstanding by the portion of the year between this change and next change: weight = days outstanding / 365 = months outstanding / 12.

Just take the market capitalization figure and divide it by the share price. The result is the number of shares on which the market capitalization number was based.

You will do that by dividing the total investment amount by the current share price. For example, if you have invested $5,000 to buy company ABC’s stock with a current value of $40, you will receive $5,000/$40 = 125 shares.

If you know the number of treasury stock, or shares reclaimed by the company but not retired, and the number of shares outstanding, you can calculate shares issued: shares issued = shares outstanding + treasury stock.

## How do you calculate weighted average in Excel?

To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM.

- First, the AVERAGE function below calculates the normal average of three scores. …
- Below you can find the corresponding weights of the scores. …
- We can use the SUMPRODUCT function in Excel to calculate the number above the fraction line (370).