As a result, the forward P/E ratio can more accurately reflect a company's valuation vs. using the historical P/E ratio. Here are the steps to calculate forward P/E in Excel.

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...