Enrollment for the FMVA™ Certification Program is now OPEN!

Price/Earnings to Growth Ratio Template

Price/Earnings to Growth Ratio Template

This price/earnings to growth ratio template shows you the calculation of PEG ratio given the share price, EPS and EPS growth rate.

Below is a screenshot of the PEG ratio template:

Price/Earnings to Growth Ratio Template Screenshot

 

Download the Free Template

Enter your name and email in the form below and download the free template now!

Price/Earnings to Growth Ratio Template

Download 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.

Financial Analyst Certification

Become a certified Financial Modeling and Valuation Analyst (FMVA)™ by completing CFI’s online financial modeling classes and training program!