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,320
Terminal Value Calculation Excel TemplateCompute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,150
Comparable Company AnalysisArrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.1,072
Alibaba IPO Financial ModelA full IPO financial model ready to be adapted and tweaked to any other company781
Colgate Financial Model (Unsolved & Solved Versions)A full financial model ready to be adapted to any other company + a blank template1,024
NPV Calculator (Excel Template)Calculate Net Present Value with ease by using this Excel spreadsheet.1,255
Valuation Waterfall GraphShow your audience how the share price of a target company can be broken up in its sub-components811
Beta Calculation WorksheetCompute the Beta needed for your CAPM as to calculate the expected return of a company's share567
Private Equity Chart TemplateVisualize the Valuation multiple of Stock or Index over a period of time.533
Free Cash Flow (FCFF) TemplateCompute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)408
Box IPO (Initial Public Offering)Indepth analysis of BOX IPO with DCF and relative valuation329
Private Equity Band Chart TemplateCompute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index564
Any questions on Forward PE (Price/Earnings) Ratio Excel Template?
The user community and author are here to help. Go ahead!