Published
Aug 05, 2020
Category
Fundamental Analysis
Works on
Indian Stock Market

01. PEG Ratio Analysis Excel Sheet

OThis Excel Sheet will help us analysis the PEG Ratio of a company. The objective is the spot a company which has an a Good investable PEG ratio for Emerging Markets . The goal is to see if the company is to spot the current status of the Company, is it Over Valued, Under Valued or Fair Valued.

“ the Enterprise Value of a company tells us the Real value the company of its books  .”

02. How to Use the Excel Sheet

The First thing you need to do is Download the Excel Sheet ” Balance Sheet Analysis ” from this Website.

Things that you Need to Get Started –

1. PEG Ratio  – Download the Excel Sheet ( Click  )

2.  Balance Sheet Data – http://www.screener.in ( Click ) 

Then Follow the Steps One by One . ( Same steps as Balance Sheet )

03. PEG Ratio Analysis

This Will give you the Automated Data of the PEG Ratio  and tell us if about the stocks valuation and with this report we will be able to analyse if the Stock that we are analysing can be investable at the current time or not . This gives us an idea for the future outlook of the company and how safe it is for us to invest in it. 

Download Link of the Excel Sheet –  PEG Ratio Analysis Excel Sheet ( Download this )