|
|
|
|
|
|
|
|
|
|
|
|
|
|
Intrinsic Valuation of GODREJCP |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GODREJCP Free Cash Flow Average and Growth
over past 5Y |
|
Key Statistics |
|
|
Year |
|
FCF |
FCF Growth |
|
|
|
|
|
|
|
|
2021 |
|
$11,207,600,000 |
-36.54% |
|
EPS (FY) |
17.44 |
|
Market Cap |
893B |
|
|
2020 |
|
$17,662,100,000 |
31.69% |
|
P/E Ratio |
52.05 |
|
Total Asset |
165B |
|
|
2019 |
|
$13,412,200,000 |
-4.10% |
|
Net Income |
18B |
|
Total Debt |
17B |
|
|
2018 |
|
$13,985,500,000 |
5.91% |
|
EBITDA |
24B |
|
Total Liab |
50B |
|
|
2017 |
|
$13,205,100,000 |
-17.30% |
|
Opr Margin |
0.1757 |
|
Debt/Equity |
0.15 |
|
|
2016 |
|
$15,966,900,000 |
|
|
PreTax Margin |
0.1654 |
|
BV/Share |
113.01 |
|
|
5Y Average FCF |
|
$13,894,500,000 |
-4.07% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Overall Market Assumptions: |
|
|
Assumptions: |
|
|
|
P/E for No-Growth Company: |
7.00 |
|
|
|
Perpetual Growth Rate (g): |
2.50% |
|
|
|
Historical US Bond Yield: |
4.40% |
|
|
|
Discount Rete (WACC): |
6.88% |
|
|
|
Current US Bond Yield: |
1.48% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forcasting Future Free Cash Flow for next 6Y |
|
Modified Benjamin Graham's Intrinsic Value |
|
|
Year |
|
FCF Projection |
|
|
|
|
|
|
|
|
|
2022 |
|
$10,751,585,830 |
|
|
MBG Intrinsic Value |
$366.48 |
|
|
2023 |
|
$10,314,125,938 |
|
|
|
|
|
|
|
|
|
2024 |
|
$9,894,465,388 |
|
|
|
|
|
|
|
|
|
2025 |
|
$9,491,879,962 |
|
|
|
|
|
|
|
|
|
2026 |
|
$9,105,674,908 |
|
|
|
|
|
|
|
|
|
2027 |
|
$8,735,183,743 |
|
|
|
|
|
|
|
|
|
Terminal Value |
|
$204,348,504,226 |
|
|
Net Worth/Share |
$113.01 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DCF Valuation |
|
DCF Valuation "What If" Scenario
Table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enterprise Value |
$175,101,786,192 |
|
|
|
Growth Rate |
|
|
(+) Cash & Cash Equivalents |
$19,520,800,000 |
|
|
173.66 |
1.50% |
2.00% |
2.50% |
3.00% |
3.50% |
|
|
(-) Total Debt |
$17,043,400,000 |
|
WACC |
6.78% |
152.1 |
163.5 |
177.6 |
195.4 |
218.7 |
|
|
Equity Value |
$177,579,186,192 |
|
6.83% |
150.8 |
161.9 |
175.7 |
193.0 |
215.5 |
|
|
Shares Outstanding |
1022545027 |
|
6.88% |
149.4 |
160.3 |
173.7 |
190.6 |
212.4 |
|
|
|
|
|
7.38% |
137.2 |
146.0 |
156.6 |
169.6 |
186.0 |
|
|
DCF Intrinsic Value |
$173.66 |
|
7.88% |
126.8 |
134.1 |
142.6 |
152.9 |
165.6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
© Swarnadeep
Seth (2022) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|