Question: how to calculate weighted average shares outstanding in excel?
Answer: 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. The weighted average number of outstanding shares in our example would be 150,000 shares.