Published
May 9, 2020
Category
Fundamental Analysis
Works on
Indian Stock Market

01. Forward PE Ratio Analysis Excel Sheet

OThis Excel Sheet will help us analysis the Forward PE Ratio of a company. The objective is the spot a company thats Forward PE Ratio is Lower than the Current PE ratio, as that would signify if the stock is Under Valued . 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 price to Earnings of a company tells us how much times the price are we paying for the companies earnings .”

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. Forward PE Excel Sheet – 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. Forward PE Ratio Analysis

This Will give you the Automated Data of the Forward PE 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 –  Forward PE Ratio Excel Sheet ( Download this )