Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

PE Band Valuation Method

PE Band Valuation uses forward Price-to-Earning i.e forecasted earnings in the P/E calculation. Different price bands are made according to the forward P/E and the stock is plotted against them to understand where it lies at any point in time. This template can be used to understand what are the different forward P/E multiples range that the stock can lie on the basis of the historical performance. The current stock price can be checked where it lies on the P/E Band and hence the upside/downside can be determined
PE Band Valuation Method - MarketXLS

Created by: MarketXLS

 
Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today