We are very glad to let you know that we have created a new Excel Peter Lynch Chart template that illustrates the valuation bands based on the historical median P/E, P/S and P/B ratios. The P/E bands of this template is similar to what Peter Lynch used in his research, except that in his chart, the Earnings Line was drawn at P/E=15.
The valuation bands in this template give you a very clear picture of where the stock valuation is relative to its long-term historical range. You only need to type the stock ticker, and the band charts will update and you will immediately get an idea on how the stock is valued. This will dramatically improve the efficiency of your research.
Please feel free to download the Peter Lynch Chart template here.
You do need to be a Premium Member to use this template. If you have not done so, please download and install GuruFocus Excel add-in from this link.
Once you install GuruFocus Excel add-in, and login your account, you are ready to go.
These are some of the screenshots from the templates:
We also have many other templates here and you are more than welcome to play with it. This is the list of the templates:
Retrieve historical stock price of a stock and draw the chart
GURUF_Fiscal_Year_Quarter_Data
This template retrieve the fundamental data of the fiscal years and quarters.
GURUF_charting_historical_data
This template retrieve the fundamental data of the fiscal years and draw the charts. The charts refreshes when the ticker is changed.
This is a two stage Fair-Value-Calcuator based on discounted earnings. Go here to learn more: http://www.gurufocus.com/news/39330
This template retrieves the items in financial statements.
Retrieve the historical ratios of a stock.
Calculate REIT FFO with "Net Income (Continuing Operations)" + "Depreciation, Depletion and Amortization" - "Sale Of Property, Plant, Equipment".
Receives the current price and key statistical data for the stocks in a portfolio.