how to calculate forward p e in excel
using microsoft excel you can calculate a company s forward p e for the next fiscal year the forward p e formula is the company s market price per share divided by its expected earnings per share to set up your excel sheet for example assume that company abc is currently trading at 50 and has an expected eps of 2 60 on the other hand company def currently has a market value per share of 30 and has an expected eps of 1 80 