I just went back looked at the last IPO which i avoid and it listed handsomely
this is what DCF for Sheela Form i got Fair price Rs742 and Intrinsic Value 989 it listed for Rs1030 actual not that far from my DCF intrinsic price, I avoid this IPO bcoz i had issue with corporate governance and increase raw material cost and not that bullish on deposable income sector just before demonisation
AT LEAST MY DCF WAS RIGHT IF I NOW LOOK AT MY DCF ESTIMATE I WOULD HAVE APPLIED
HOWEVER IN CASE OF S CHAND IT IS CLEAR CUT AVOID
127. Septa Nov 29, 2016 7:53:14 PM IST I Like It. 2 | Report Abuse
IPO Guru IPO Guru (3500+ Posts, 1800+ Likes)
Discloser i am avoiding this IPO. Removing liquidity from market is dangerous for the economy and this discretionary expenses will have adverse effect
Thanks to Modi Ji this issue is coming at this price band. if not it will would have come close to 40 plus PE given it comes under discretionary expenses and would be very handsomely subscribed
My discount cash flow analysis
Initial Cash Flow: $1,32,20,00,000
Years: 1-5 6-10
Growth Rate: 15% 11%
Terminal Growth Rate: 5% Discount Rate: 10%
Shares Outstanding: 4,87,82,808 Margin of Safety: 25%
Debt Level:
Year Flows Growth Value
1 1,52,03,00,000 15% $1,38,20,90,909
2 1,73,31,42,000 14% $1,43,23,48,760
3 1,95,84,50,460 13% $1,47,14,12,817
4 2,19,34,64,515 12% $1,49,81,65,778
5 2,43,47,45,612 11% $1,51,17,85,467
6 2,70,25,67,629 11% $1,52,55,28,971
7 2,99,98,50,068 11% $1,53,93,97,416
8 3,32,98,33,576 11% $1,55,33,91,938
9 3,69,61,15,269 11% $1,56,75,13,683
10 4,10,26,87,949 11% $1,58,17,63,807
Terminal Year $4,30,78,22,346
PV of Year 1-10 Cash Flows: $15,06,33,99,546
Terminal Value: $33,21,70,39,954
Total PV of Cash Flows: $48,28,04,39,500
Number of Shares: 4,87,82,808
Intrinsic Value (IV): $989.70
Margin of Safety IV: $742.28
What Percentage of IV comes from 69%
the Terminal Value: