It is the price an investor is willing to pay for each dollar of a company's earnings. The P/E ratio is calculated with the following mathematical formula: A company whose stock trades at $50 per ...

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.

The dividend payout ratio assesses the dividends paid to shareholders in relation to a company's net earnings, and it is stated as a percentage. A high dividend payout ratio can indicate that a ...