Price/Earnings to Growth Ratio Template
This price/earnings to growth ratio template shows you the calculation of the PEG ratio given the share price, EPS, and EPS growth rate.
Below is a screenshot of the PEG ratio template:
Download the Free Template
Enter your name and email in the form below and download the free template now!
Price/Earnings to Growth Ratio TemplateDownload the free Excel template now to advance your finance knowledge!
The PEG ratio is a company’s Price/Earnings ratio divided by its earnings growth rate over a period of time (typically the next 1-3 years). The PEG ratio adjusts the traditional P/E ratio by taking into account the growth rate in earnings per share that are expected in the future. This can help “adjust” companies that have a high growth rate and a high price to earnings ratio.
The PEG ratio formula is as follows:
PEG = Share Price / Earnings per share / Earnings per Share growth rate
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.