| Intrinsic Valuation of HDFCBANK | |||||||||||
| HDFCBANK Free Cash Flow Average and Growth over past 5Y | Key Statistics | ||||||||||
| Year | FCF | FCF Growth | |||||||||
| 2021 | $213,173,900,000 | -63.93% | EPS (FY) | 68.31 | Market Cap | 7929B | |||||
| 2020 | $591,042,764,000 | 33.23% | P/E Ratio | 19.92 | Total Asset | 21649B | |||||
| 2019 | $443,610,430,000 | 64.80% | Net Income | 381B | Total Debt | 2423B | |||||
| 2018 | $269,179,715,000 | 42.41% | EBITDA | - | Total Liab | 18749B | |||||
| 2017 | $189,017,216,000 | -50.36% | Opr Margin | 0.3067 | Debt/Equity | 0.84 | |||||
| 2016 | $380,791,461,000 | PreTax Margin | 0.3067 | BV/Share | 445.99 | ||||||
| 5Y Average FCF | $341,204,805,000 | 5.23% | |||||||||
| 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): | 7.43% | Current US Bond Yield: | 1.48% | ||||||||
| Forcasting Future Free Cash Flow for next 6Y | Modified Benjamin Graham's Intrinsic Value | ||||||||||
| Year | FCF Projection | ||||||||||
| 2022 | $224,323,342,239 | MBG Intrinsic Value | $1,436.59 | ||||||||
| 2023 | $236,055,923,701 | ||||||||||
| 2024 | $248,402,143,789 | ||||||||||
| 2025 | $261,394,097,093 | ||||||||||
| 2026 | $275,065,556,813 | ||||||||||
| 2027 | $289,452,062,561 | ||||||||||
| Terminal Value | $6,018,159,867,288 | Net Worth/Share | $524.06 | ||||||||
| DCF Valuation | DCF Valuation "What If" Scenario Table | ||||||||||
| Enterprise Value | $4,834,527,023,864 | Growth Rate | |||||||||
| (+) Cash & Cash Equivalents | $0 | 435.79 | 1.50% | 2.00% | 2.50% | 3.00% | 3.50% | ||||
| (-) Total Debt | $2,423,192,200,000 | WACC | 7.33% | 333.0 | 388.0 | 454.5 | 536.3 | 639.5 | |||
| Equity Value | $2,411,334,823,864 | 7.38% | 326.1 | 380.0 | 445.0 | 524.9 | 625.3 | ||||
| Shares Outstanding | 5533203566 | 7.43% | 319.4 | 372.2 | 435.8 | 513.7 | 611.4 | ||||
| 7.93% | 257.8 | 301.2 | 352.6 | 414.4 | 490.2 | ||||||
| DCF Intrinsic Value | $435.79 | 8.43% | 205.3 | 241.4 | 283.6 | 333.6 | 393.7 | ||||
| © Swarnadeep Seth (2022) | |||||||||||