Intrinsic Value Of Aurobindo Pharma.xlsx

Growth Rate Considered at 36% EPS 29.16

Inputs

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10

Gross Profit

FUTURE EPS 39.66 53.93 73.35 99.76 135.67 184.51 250.93 341.27 464.13 631.21

GROWTH RATE 0.36 FUTURE PRICE AS PER PROJECTED PE 793.15 1078.69 1467.01 1995.14 2713.39 3690.21 5018.68 6825.41 9282.56 12624.28

12051.28

IMP FORMULAES EGR (Present PAT/Past Pat)^1/n-1 where, eGap between 2013 to 2018 Gross Profit Future Price - Current Price Gross Profit % Future Price At 10th Year/ Current Price(Returns) *100 Inflation Adjusted Value Future Price at 10th Year/(1+INFLTN.RATE)^9 Intrinsic Value Amount that needs to be Adjusted/(1+EGR+INFLTN.RATE)^9 where, Amt.That needs to be Adjusted - Future Price at 10th Year

Now At which Value you can Say that If you Buy the Stock At the Current Price Then You will be getting it at a Bargained Price

EGR

If EGR > PE - Valuations are Cheap If EGR < PE - Valuations are Expensive If EGR = PE - Valuations are where it should originally be.

PROJECTED PE

RETURN RATE BY NIFTY 20

INFLATION ASSUMED 0.12

INTRINSIC VALUE

0.05

RETURNS AS PER NIFTY RETURNS 22.03 573.00 ……….Interpretations:Our Current price of Aurob 573.11 641.76 If we Purchase stock below 718.77 805.02 901.63 1009.82 1131.00 1266.72 Inflation Adjusted Value 1418.73 Inflation Adjusted Return Gross gain % 8137.72 1588.97 975.49 2203.19

Gross Profit For Col. E 1588.97

will be getting it at a Bargained Price

PROJECTED PE

r Current price of Aurobindo Pharma are near to calculations of Intrinsic Value we Purchase stock below this Price then we can say that we have purchased at a bargained price.

Growth Rate Considered at 20% Taking into Consideration Close to Realistic Factors EPS 29.16

Inputs

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10

FUTURE EPS 34.99 41.99 50.39 60.47 72.56 87.07 104.49 125.38 150.46 180.55

Gross Profit

GROWTH RATE 0.2 FUTURE PRICE AS PER PROJECTED PE 699.84 839.81 1007.77 1209.32 1451.19 1741.43 2089.71 2507.65 3009.18 3611.02

3038.02

IMP FORMULAES EGR (Present PAT/Past Pat)^1/n-1 where, eGap between 2013 to 2018 Gross Profit Future Price - Current Price Gross Profit % Future Price At 10th Year/ Current Price(Returns) *100 Inflation Adjusted Value Future Price at 10th Year/(1+INFLTN.RATE)^9 Intrinsic Value Amount that needs to be Adjusted/(1+EGR+INFLTN.RATE)^9 where, Amt.That needs to be Adjusted - Future Price at 10th Year

Now At which Value you can Say that If you Buy the Stock At the Current Price Then You will be getting it at a Bargained Price

EGR

If EGR > PE - Valuations are Cheap If EGR < PE - Valuations are Expensive If EGR = PE - Valuations are where it should originally be.

PROJECTED PE

RETURN RATE BY NIFTY 20

INFLATION ASSUMED 0.12

INTRINSIC VALUE

0.05

RETURNS AS PER NIFTY RETURNS 7.45 573.00 ……….Interpretations:Our Current price of Aurob 484.66 641.76 If we Purchase stock below 718.77 805.02 901.63 1009.82 1131.00 1266.72 Inflation Adjusted Value 1418.73 Inflation Adjusted Return Gross gain % 2327.70 1588.97 975.49 630.20

Gross Profit For Col. E 1588.97

will be getting it at a Bargained Price

PROJECTED PE

r Current price of Aurobindo Pharma are near to calculations of Intrinsic Value we Purchase stock below this Price then we can say that we have purchased at a bargained price.