Earning Per Share

Basic EPS does not factor any dilutable securities into consideration. It serves as an indicator of a company's profitability

How calculated

(Net income - preferred dividend)/weighted average shares outstanding

Example usage

=EarningsPerShare("MSFT") - Returns a company's net profit per common outstanding share


A company's number of shares outstanding is not static and may fluctuate wildly over time.



Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!