| 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) | |||||||||||