Here are the steps to calculate forward P/E in Excel. In Microsoft Excel ... Left-click on "Column Width" from the dropdown and change the value to 30. It helps to first establish the column ...

He contributes to Excel and Algorithmic Trading ... Conversely, you could calculate the whole equation in one cell to arrive at just the final value figure. All three ways are detailed below ...