Close the Skill Gap -> Enroll to be a Certified Financial Modeling & Valuation Analyst (FMVA)® Today!

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.

  • Excel Modeling Templates
  • PowerPoint Presentation Templates
  • Transaction 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!