| Intrinsic Valuation of: INDIANB | |||||||||||
| Free Cash Flow Average and Growth over past 5Y | Key Statistics | ||||||||||
| Year | FCF | FCF (FCF/Revenue) | |||||||||
| 2020 | - | - | EPS (FY) | 81 | Market Cap | ₹880B | |||||
| 2021 | - | - (-) | P/E Ratio | 8 | Total Asset | ₹8,770B | |||||
| 2022 | ₹284B | - (-) | Net Income | ₹113B | Total Debt | ₹0 | |||||
| 2023 | ₹-282B | -199.3% (-185.4%) | EBITDA | - | Total Liab | ₹8,055B | |||||
| 2024 | ₹-92B | 67.3% (71.2%) | Opr Margin | - | Debt/Equity | - | |||||
| 2025 | ₹169B | 282.4% (265.1%) | PreTax Margin | - | BV/Share | 531 | |||||
| 5Y Average FCF | ₹20B | 50.1% (50.3%) | |||||||||
| Overall Market Assumptions: | |||||||||||
| Assumptions: | P/E for No-Growth Company: | 7.0 | |||||||||
| Perpetual Growth Rate (g): | 2.5% | Historical US Bond Yield: | 4.4% | ||||||||
| Discount Rate (WACC): | 7.4% | Current US Bond Yield: | 3.5% | ||||||||
| Forcasting Future Free Cash Flow for next 6Y | Modified Benjamin Graham's Intrinsic Value | ||||||||||
| Year | FCF Projection (25.0%) | ||||||||||
| 2026 | ₹211B | MBG Intrinsic Value | ₹728 | ||||||||
| 2027 | ₹263B | ||||||||||
| 2028 | ₹329B | ||||||||||
| 2029 | ₹412B | ||||||||||
| 2030 | ₹514B | ||||||||||
| 2031 | ₹643B | ||||||||||
| Terminal Value | ₹13,369B | Net Worth/Share | ₹531 | ||||||||
| DCF Valuation | DCF Valuation "What If" Scenario Table | ||||||||||
| Enterprise Value | ₹10,473B | Growth Rate | |||||||||
| (+) Cash & Cash Equivalents | ₹550B | ₹8,183 | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% | ||||
| (-) Total Debt | ₹0 | WACC | 7.3% | 7,169 | 7,708 | 8,359 | 9,160 | 10,171 | |||
| Equity Value | ₹11,023B | 7.4% | 7,105 | 7,633 | 8,270 | 9,053 | 10,036 | ||||
| Shares Outstanding | 1,346,960,000 | 7.4% | 7,042 | 7,560 | 8,183 | 8,947 | 9,905 | ||||
| 7.9% | 6,470 | 6,898 | 7,404 | 8,013 | 8,759 | ||||||
| DCF Intrinsic Value | ₹8,183 | 8.4% | 5,982 | 6,340 | 6,757 | 7,252 | 7,847 | ||||
| Analyzed by QuantJuice (2025) | |||||||||||