Publication number: ELQ-79722-1
View all versions & Certificate
Forward PE (Price/Earnings) Ratio Excel Template
A template to help investors calculate forward PE ratio in Excel.
Dheeraj Vaidya CFA FRM offers you this business tool for free!
download for free
Add to bookmarks
People using this tool also downloaded
Scenario Graph TemplateVisualize the different options a stock price can take according to a number of variables2,128
Terminal Value Calculation Excel TemplateCompute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,086
Comparable Company AnalysisArrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.1,013
Alibaba IPO Financial ModelA full IPO financial model ready to be adapted and tweaked to any other company734
Colgate Financial Model (Unsolved & Solved Versions)A full financial model ready to be adapted to any other company + a blank template981
NPV Calculator (Excel Template)Calculate Net Present Value with ease by using this Excel spreadsheet.1,173
Valuation Waterfall GraphShow your audience how the share price of a target company can be broken up in its sub-components752
Beta Calculation WorksheetCompute the Beta needed for your CAPM as to calculate the expected return of a company's share514
Free Cash Flow (FCFF) TemplateCompute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)389
Private Equity Chart TemplateVisualize the Valuation multiple of Stock or Index over a period of time.507
Private Equity Band Chart TemplateCompute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index553
Box IPO (Initial Public Offering)Indepth analysis of BOX IPO with DCF and relative valuation314
Any questions on Forward PE (Price/Earnings) Ratio Excel Template?
The user community and author are here to help. Go ahead!