| Intrinsic Valuation of AXISBANK | |||||||||||
| AXISBANK Free Cash Flow Average and Growth over past 5Y | Key Statistics | ||||||||||
| Year | FCF | FCF Growth | |||||||||
| 2021 | $348,784,600,000 | 18.67% | EPS (FY) | 45.91 | Market Cap | 2237B | |||||
| 2020 | $293,903,500,000 | 17113.89% | P/E Ratio | 13.84 | Total Asset | 11747B | |||||
| 2019 | $1,707,362,000 | -98.58% | Net Income | 141B | Total Debt | 2264B | |||||
| 2018 | $120,143,341,000 | 8.10% | EBITDA | - | Total Liab | 10772B | |||||
| 2017 | $111,145,840,000 | 29.22% | Opr Margin | 0.2437 | Debt/Equity | 1.52 | |||||
| 2016 | $86,013,223,000 | PreTax Margin | 0.2437 | BV/Share | 385.25 | ||||||
| 5Y Median FCF | $175,136,928,600 | 18.67% | |||||||||
| 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): | 4.78% | Current US Bond Yield: | 1.48% | ||||||||
| Forcasting Future Free Cash Flow for next 6Y | Modified Benjamin Graham's Intrinsic Value | ||||||||||
| Year | FCF Projection | ||||||||||
| 2022 | $413,913,741,065 | MBG Intrinsic Value | $961.87 | ||||||||
| 2023 | $491,204,557,319 | ||||||||||
| 2024 | $582,928,019,036 | ||||||||||
| 2025 | $691,779,158,629 | ||||||||||
| 2026 | $820,956,256,495 | ||||||||||
| 2027 | $974,254,813,362 | ||||||||||
| Terminal Value | $43,716,380,268,194 | Net Worth/Share | $318.05 | ||||||||
| DCF Valuation | DCF Valuation "What If" Scenario Table | ||||||||||
| Enterprise Value | $34,827,690,448,478 | Growth Rate | |||||||||
| (+) Cash & Cash Equivalents | $0 | 10619.19 | 1.50% | 2.00% | 2.50% | 3.00% | 3.50% | ||||
| (-) Total Debt | $2,263,949,100,000 | WACC | 4.68% | 7707.3 | 9124.0 | 11190.4 | 14486.9 | 20577.0 | |||
| Equity Value | $32,563,741,348,478 | 4.73% | 7567.2 | 8932.4 | 10909.9 | 14030.4 | 19687.8 | ||||
| Shares Outstanding | 3066500000 | 4.78% | 7431.3 | 8747.8 | 10641.7 | 13599.5 | 18868.2 | ||||
| 5.28% | 6272.2 | 7213.1 | 8492.5 | 10333.1 | 13207.6 | ||||||
| DCF Intrinsic Value | $10,619.19 | 5.78% | 5386.4 | 6087.3 | 7001.9 | 8245.4 | 10034.4 | ||||
| © Swarnadeep Seth (2022) | |||||||||||