< Back to blog post

(Updated as on 29-July’19)

Fundamentals

  • EV = Enterprise Value (Rs.Cr.)
  • ROE = Return on Equity (%)
  • RoCE = Return on Capital Employed (%)
  • D/E = Debt Equity Ratio

Price Valuation

  • P/E = Price to Earning Ratio
  • P/B = Price to Book Value Ratio
  • PEG: PE to Growth Ratio.

Quick Resource:

SLStock NameEVROERoCED/EP/EP/BPEG
1P&G (Hygiene)34,37457.1772.940.0086.3134.489.94
2Colgate-Palmolive31,11348.3276.630.0041.8019.544.62
3HDFC AMC43,68335.0842.080.0045.8613.91
4L&T Infotech 23,83635.2043.670.0017.215.020.91
5Oracle Financial25,98529.8448.740.0020.796.0453.37
6Glaxosmithkline (Healthcare) 26,90925.9338.450.0031.557.572.32
7Titan Co.97,09824.9435.570.0169.9316.195.14
8Info Edge26,61840.2216.600.0045.0910.800.63
9Hero Motocorp 46,12727.1642.240.0214.313.761.42
10Britannia63,43530.3244.220.0455.3315.152.31
11Eicher Motors 43,65124.7936.950.0221.295.290.73
12Pidilite Ind.61,98124.0135.630.0368.3415.274.36
13Marico 45,99941.2241.500.1241.6715.632.38
14Bajaj Auto73,41220.9727.120.0115.483.132.16
15ACC 26,60115.1920.700.0017.042.701.54
16Divi’s Lab.42,78721.0028.280.0232.676.352.77
17Havells India 42,47519.7731.440.0255.6110.304.65
18Hindustan Zinc 78,22322.8832.200.0812.202.694.68
19Tech Mahindra 55,10122.7434.890.1014.443.451.99
20Petronet LNG 32,28023.1038.650.1515.983.48
21Dabur India 75,56626.2631.130.1751.2412.625.42
22Interglobe Aviation 50,40041.7349.380.3545.817.47-3.86
23NMDC 29,10216.1826.680.027.371.40-0.76
24United Breweries 37,42115.7164.710.1265.9611.663.67
25Zee Ent.37,83418.9827.330.1221.904.111.45
26Berger Paints31,87421.3831.500.2163.9612.894.31
27Avenue Supermarts89,35017.7126.790.1387.0515.090.73
28Godrej Consumer65,33934.6221.050.4727.058.721.16
29Aurobindo Pharma 36,50722.9923.530.4113.952.380.92
30United Spirits 45,67924.8870.830.9355.6112.943.37
31BPCL1,05,45725.2230.771.039.561.910.28
32UPL 49,69825.7619.500.7231.763.133.17
33Biocon 29,52918.0017.790.4029.234.421.46
34HPCL64,84020.6024.090.936.271.380.10
35Motherson Sumi43,65520.0526.481.1222.113.471.77
36JSW Steel 1,02,20324.1622.261.399.581.690.23
37Vedanta 90,66415.4920.251.078.860.95-1.86
38Adani Ports1,00,06117.7415.361.1219.803.221.08

< Back to blog post

Stock Analysis Worksheet

Use MS Excel to find intrinsic value of stocks