The price-to-earnings ratio (P/E) is one of the most widely used metrics for investors and analysts to determine stock valuation. It shows whether a company’s stock price is overvalued or ...

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.