In cell B7, input the formula "=B6/B5" to render the EPS ratio. Earnings per share (EPS) is an important profitability measure used in relating a stock's price to a company's actual earnings.

To calculate a company's P/E ratio, divide the price of one share of that company's stock by the earnings per share (often abbreviated EPS) of that company’s stock over a period of 12 months.

ratio. To calculate earnings per share, divide a company’s annual or quarterly profit by the number of shares of stock it has outstanding. Note: If a company has both preferred and common ...