Here's how to calculate a company's forward P/E ratio for the next period using Microsoft Excel. The forward ... It helps to first establish the column heading names. You can label these however ...

Using Excel, you can define and calculate placement of data within the spreadsheet by specifying the column and row identifiers ... Click inside cell A1 and type "100" into the cell.