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