Earnings Per Share Calculator in Excel

In this lesson, you will learn how to calculate EPS in Excel.

EPS stands for earnings per share.

Let's build the earnings per share calculator in Excel. To calculate EPS in Excel first you need some data. You need: Net Income, Outstanding Shares and Preferred Dividends

How to calculate EPS?

The formula to calculate EPS is as follows:

Earnings Per Share = Net Income / Outstanding Shares

Copy and paste this eps formula into cell B4: =B2/B3

earning per shareHow to calculate weighted EPS?

The formula to calculate weighted EPS is as follows:

Weighted Earnings Per Share = (Net Income - Preferred Dividends) / Outstanding Shares

Copy and paste this roi formula in cell B5: =(B2-B3)/B4

weighted earning pewr share excel

Downloand a free sample spreadsheet here.

Further reading:
How to calculate ROE?
How to calculate ROA?
How to calculate ROI?
How to calculate ROCE?
How to calculate Weighted Average?